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

Currently Filtered by

Category

Floor Pads Stripping

Refine Search

  GO
 
Brand

3M(34)

Boardwalk(27)

Americo(17)

Scotch-Brite(11)

GMT(9)

Oreck Commercial(2)

Scotch-Brite PROFESSIONAL(1)

 
Height

1"(39)

3/4"(10)

1/2"(10)

14"(3)

2/5"(3)

0.75"(3)

20"(2)

28"(2)

3/10"(2)

0.3"(2)

12"(1)

1.125"(1)

3"(1)

 
Color(s)

Black(39)

Green(12)

Blue(10)

Maroon(9)

Gray(8)

Brown(8)

Green/Amber(5)

Grayish Black(3)

Purple(2)

White(2)

Red(1)

Steel Gray(1)

White/Blue(1)

 
Diameter

20"(18)

17"(14)

19"(11)

13"(9)

14"(9)

18"(7)

12"(6)

16"(6)

15"(4)

21"(3)

14" x 28"(1)

14" x 20"(1)

22"(1)

24"(1)

4" x 10"(1)

6" x 9"(1)

 
Manufacturer Part Number

40011218(1)

08279(1)

08384(1)

08383(1)

08382(1)

08381(1)

08380(1)

08379(1)

08378(1)

08377(1)

08376(1)

08278(1)

08405(1)

08277(1)

08276(1)

08275(1)

08274(1)

08273(1)

08272(1)

08271(1)

08270(1)

02590(1)

02498(1)

08386(1)

08407(1)

120202(1)

18049(1)

437053(1)

SPP20(1)

SPP19(1)

SPP18(1)

SPP17(1)

SPP14X32(1)

SPP13(1)

98(1)

4610(1)

18052(1)

18046(1)

08413(1)

18045(1)

18044(1)

08743(1)

08448(1)

08447(1)

08445(1)

08443(1)

08442(1)

08441(1)

08418(1)

120203(1)

120200(1)

400113(1)

400320(1)

4014BLU(1)

4014 BLA(1)

4013 GRE(1)

4013 BLU(1)

4013BLA(1)

4012BLA(1)

420720(1)

42071428(1)

42071420(1)

400317(1)

4016 BLA(1)

40031428(1)

40031420(1)

400314(1)

400313(1)

400120(1)

400119(1)

400117(1)

40011428(1)

40011420(1)

400114(1)

4015 BLA(1)

4016 BLU(1)

120192(1)

4020BLA(1)

120190(1)

120180(1)

120172(1)

120171(1)

120170(1)

4021 BLA(1)

4020 RED(1)

4020 HIP(1)

4020 GRE(1)

4020BLU(1)

4019 HIP(1)

4016GRE(1)

4019 GRE(1)

4019 BLU(1)

4019BLA(1)

4018 GRE(1)

4018 BLU(1)

4018BLA(1)

4017HIP(1)

4017 GRE(1)

4017BLU(1)

4017BLA(1)

437071(1)

 
Country of Origin

US(87)

CA(9)

IT(3)

FR(2)

 
Width

14"(4)

12"(2)

18"(1)

20"(1)

28"(1)

32"(1)

 
Material(s)

Nylon/Polyester Blend(24)

Non-Woven Nylon/Polyester Fiber(19)

Polyester Fiber(10)

Nylon(10)

Steel Wool(9)

Non-Woven Fiber(8)

Non-Woven Polyester Fiber(6)

Synthetic Fiber(5)

Recycled Polyester Fiber(4)

Non-Woven Natural/Polyester Fiber(1)

Non-Woven Nylon; Polyester Fiber(1)

Foam(1)

Fiber; Mineral; Resin(1)

Cloth(1)

Plastic(1)

 
For Use With

Rotary Machine Speed of 175-600 rpm(29)

Rotary or Automatic Machine Speed of 175-600 rpm(26)

Rotary Floor Machines(19)

Auto-scrubbers, swing machines, or rectangular floor machines(5)

Machines Speed of 350 rpm(4)

Rotary Floor Machines 175-600 rpm(3)

3M Neutral Cleaner(3)

Rotary Machine Speed of 175-3000 rpm(1)

Rotary, Automatic, Electric, Battery or Propane Floor Finishing Machines at Low to Ultra High Speed, 175-1500 RPM and above(1)

3M Doodlebug Pad Holders(1)

Hand Scrubbing(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved