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_1` 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 ('60295')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%MountingTape' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('MountingTape' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MountingTape' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MountingTape"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MountingTape"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MountingTape"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MountingTape"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MountingTape' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MountingTape',`category_4` ='MountingTape') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MountingTape,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MountingTape', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Mounting Tape

Refine Search

  GO
 
Brand

Scotch(17)

Command(14)

Duck(2)

 
Height

Assorted(1)

 
Color(s)

White(17)

Clear(9)

Black(3)

Gray(2)

 
Depth

0.1"(7)

0.03"(1)

Assorted(1)

 
Size

Assorted(1)

 
Manufacturer Part Number

1289275(1)

17201S52NA(1)

R101(1)

R100(1)

924-3/4(1)

924-1/2(1)

859(1)

7225(1)

414P(1)

411P(1)

410P(1)

4011-LONG(1)

17213ES(1)

17209ES(1)

17206ES(1)

17202ES(1)

17201ES(1)

HU-15-6(1)

17201CABPK(1)

17201BLKES(1)

17200CLRES(1)

17024S256NA(1)

17024ES(1)

17024CABPK(1)

1702448ES(1)

17021CLRES(1)

112L(1)

111P(1)

110-MR(1)

110-LONG(1)

110(1)

108(1)

R105(1)

 
Country of Origin

US(32)

CN(1)

 
Width

1"(9)

0.75"(6)

0.63"(5)

3/4"(4)

0.5"(3)

5/8"(1)

0.5"; 0.63"(1)

Assorted(1)

0.69"(1)

1/2"(1)

7/8"(1)

 
Length

1.75"(4)

2.75"(4)

1"(3)

60"(3)

1,296"(2)

3.63"(1)

3"(1)

0.69"(1)

0.75"(1)

450"(1)

2.75"; 3.63"(1)

36 yd(1)

2.13"(1)

15 ft(1)

1 3/4";2 3/4";3 3/4"(1)

1 3/4"(1)

125"(1)

38 yds(1)

9.75 yds(1)

75"(1)

7/8"(1)

 
Capacity (Weight)

Up to 1 lb per pair(4)

3 lb(3)

6 lb(1)

1 lb(1)

4 lb(1)

3 lb; 4 lb(1)

Sawtooth: 4 lbs; Small: 1 lb per pair; Large: 4 lbs per pair; Wire Hanger: 5 lbs(1)

 
Mounting

Adhesive(29)

Wall(1)

 
Number of Hangers/Hooks

38(1)

 
Mounting Application

Double-Sided Adhesive(18)

Command Adhesive(11)

Press-On Adhesive(2)

Adhesive(1)

 
Permanent/Removable/Repositionable

Removable(15)

Permanent(13)

Repositionable(2)

Removable; Repositionable(2)

 
Holds

Up to 2 lb(7)

Up to 1 lb per pair(4)

Up to 1 lb(3)

Up to 3 lb per pair(3)

Up to 0.5 lb(2)

Up to 10 lbs(1)

Up to 0.33 lb (on two tabs)(1)

Up to 1/4 lb (6 tabs)(1)

Up to 30 lbs(1)

Up to 15 lbs(1)

Up to 3 lb per pair; Up to 4 lb per pair(1)

Up to 5 lb(1)

Up to 1/3 lb (2 Squares)(1)

Up to 4 lb per pair(1)

Up to 1 lb per pair(1)

Up to 6 lb per pair(1)

1 lb; 3 lb; 5 lb(1)

Up to 0.6 lb(1)

 
Refill(s) For

Scotch Tape Applicator MMMATG700 Sold Separately(2)

 
Hook Material

Plastic(1)

 
Hanger/Hook Type

Hook(1)

 
Hook Color

White(1)

 
Hanger Material

Plastic(1)

 
Hook Base Material

Plastic(1)

 
Hanger Color

White(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved