Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_46` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('113380')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%PackagingTapes' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('PackagingTapes' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+PackagingTapes' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"PackagingTapes"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"PackagingTapes"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"PackagingTapes"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"PackagingTapes"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+PackagingTapes' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='PackagingTapes',`category_4` ='PackagingTapes') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'PackagingTapes,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('PackagingTapes', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Packaging Tapes

Refine Search

  GO
 
Brand

Scotch(30)

Duck Brand(18)

ipg(6)

Sparco(5)

T-REX(4)

Tartan(4)

Business Source(3)

 
Color

Clear(59)

Natural(4)

Tan(3)

Crystal Clear(2)

Brown(2)

 
Recycled

No(69)

Yes(1)

 
Packaged Quantity

6 / Pack(22)

4 / Pack(8)

1 / Roll(8)

36 / Carton(5)

3 / Pack(4)

2 / Pack(4)

8 / Pack(4)

10 / Carton(3)

1 Roll(2)

1 Each(2)

24 / Carton(2)

8 / Carton(1)

6 / Carton(1)

16 / Carton(1)

18 / Pack(1)

18 / Carton(1)

48 / Carton(1)

 
Weight (Approximate)

1.73 lb(1)

 
Durability

Split Resistant(17)

UV Resistant(12)

Breakage Resistance(11)

Tear Resistant(10)

Moisture Resistant(9)

Temperature Resistant(7)

Abrasion Resistant(4)

Weather Resistant(4)

Damage Resistant(4)

Scuff Resistant(3)

Long Lasting(3)

Dust Resistant(3)

Dirt Resistant(3)

Humidity Resistant(3)

Sliver Resistant(2)

Water Resistant(2)

Fade Resistant(1)

Age Resistant(1)

Nick Resistant(1)

Slip Resistant(1)

 
Backing Thickness

3.10 mil(9)

1.90 mil(4)

2.60 mil(3)

2 mil(2)

2.80 mil(2)

3 mil(2)

1.60 mil(1)

3.54 mil(1)

2.95 mil(1)

 
Tape Thickness

3.1 mil(20)

2.6 mil(6)

2.4 mil(4)

1.9 mil(4)

2.2 mil(3)

2.3 mil(3)

6.3 mil(1)

3.4 mil(1)

3.5 mil(1)

2.8 mil(1)

 
Core Diameter

3"(42)

1.50"(2)

 
Strength Type

Tensile(31)

Adhesive(8)

 
Manufacturer Part Number

32946(1)

37504RD(1)

3500403(1)

3500406(1)

3500-6(1)

35548X50(1)

35572X50CL(1)

3650-4(1)

36506(1)

36506DP3(1)

3650S4RD(1)

37102CR(1)

37102CRPK(1)

3710-2-TN(1)

37102TNPK(1)

3750(1)

37506(1)

34508(1)

38506(1)

74962(1)

74961(1)

64012(1)

64011(1)

3850CS36(1)

38506DP3(1)

3850-4RD(1)

3750CS36ST(1)

3850-2ST(1)

3850(1)

3842-2(1)

3750T(1)

3750G6(1)

3750-CS48(1)

350021RD(1)

34503(1)

32951(1)

241510(1)

284713(1)

282195(1)

280068(1)

280065(1)

241514(1)

241513(1)

241508(1)

284983(1)

1288647(1)

07307(1)

0007725(1)

00-07496(1)

7424(1)

32956(1)

284982(1)

285045(1)

3350XW6(1)

K2800(1)

3350L6(1)

33506(1)

1506(1)

K7450(1)

K7004(1)

K7000(1)

84464(1)

285723(1)

71676(1)

HP260C-03(1)

HP260C(1)

CS-55-6PK(1)

299016(1)

285724(1)

74963(1)

 
Country of Origin

United States(54)

Taiwan(11)

China(5)

 
Material

Synthetic Rubber Resin(22)

Acrylic(8)

Fiber(4)

Natural Rubber(3)

Pressure-sensitive Poly(2)

Rubber Resin(1)

 
Tape Length

54.60 yd(29)

55 yd(10)

60 yd(7)

35 yd(4)

110 yd(3)

66.60 ft(2)

66 ft(2)

150 yd(2)

43.70 yd(2)

54.68 yd(2)

54.67 yd(1)

109.30 yd(1)

200 yd(1)

125 yd(1)

109 yd(1)

50 yd(1)

 
Tape Width

1.88"(48)

2"(6)

3"(5)

2.83"(4)

1.89"(1)

 
Backing Material

Rubber Resin(11)

Acrylic(7)

Polypropylene(3)

Synthetic Rubber(2)

Synthetic Rubber Resin(2)

Polyester(2)

Adhesive(1)

Rubber(1)

 
Dispenser Included

No(22)

Yes(18)

 
Dispenser Type

Pistol Grip(4)

 
 
 

© 2019-2020 Innovative Copy Products, All Rights Reserved