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_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') 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(41)

Boardwalk(27)

Americo(17)

Scotch-Brite(12)

GMT(12)

Oreck Commercial(2)

Scotch-Brite PROFESSIONAL(1)

 
Height

1"(43)

3/4"(14)

1/2"(10)

3/10"(3)

2/5"(3)

14"(3)

20"(2)

0.75"(2)

28"(2)

3"(1)

0.3"(1)

12"(1)

1.125"(1)

 
Color(s)

Black(42)

Blue(14)

Green(12)

Gray(11)

Maroon(11)

Brown(7)

Grayish Black(3)

Green/Orange(3)

Green/Amber(2)

White(2)

Purple(2)

Red(1)

White/Blue(1)

Steel Gray(1)

 
Diameter

20"(19)

17"(16)

19"(12)

13"(11)

14"(9)

18"(8)

12"(7)

16"(7)

15"(4)

21"(3)

4" x 10"(1)

6" x 9"(1)

24"(1)

12" x 18"(1)

14" x 20"(1)

14" x 28"(1)

22"(1)

23"(1)

 
Manufacturer Part Number

08381(1)

08382(1)

08380(1)

08379(1)

08377(1)

08378(1)

08383(1)

08384(1)

08406(1)

08407(1)

08405(1)

08386(1)

08385(1)

08376(1)

08375(1)

08272(1)

08273(1)

08271(1)

08270(1)

02590(1)

08274(1)

08275(1)

08279(1)

08374(1)

08278(1)

08277(1)

08276(1)

08409(1)

08410(1)

SPP12X18(1)

SPP13(1)

98(1)

4610(1)

18052(1)

SPP14X32(1)

SPP17(1)

437053(1)

437071(1)

SPP20(1)

SPP19(1)

SPP18(1)

18049(1)

18046(1)

08441(1)

08442(1)

08418(1)

08413(1)

08412(1)

08443(1)

08445(1)

18044(1)

18045(1)

08743(1)

08448(1)

08447(1)

02498(1)

120203(1)

4013BLA(1)

4013 BLU(1)

4012BLA(1)

420720(1)

42071428(1)

4013 GRE(1)

4014 BLA(1)

4016 BLU(1)

4016GRE(1)

4016 BLA(1)

4015 BLA(1)

4014BLU(1)

42071420(1)

400320(1)

40011428(1)

400117(1)

40011420(1)

400114(1)

400113(1)

400119(1)

400120(1)

40031428(1)

400317(1)

40031420(1)

400314(1)

400313(1)

4017BLA(1)

4017BLU(1)

120172(1)

120173(1)

120171(1)

120170(1)

4021 BLA(1)

120180(1)

120182(1)

120201(1)

120202(1)

120200(1)

120192(1)

120190(1)

4020 RED(1)

4020 HIP(1)

4018 BLU(1)

4018 GRE(1)

4018BLA(1)

4017HIP(1)

4017 GRE(1)

4019BLA(1)

4019 BLU(1)

4020BLU(1)

4020 GRE(1)

4020BLA(1)

4019 HIP(1)

4019 GRE(1)

40011218(1)

 
Country of Origin

US(97)

CA(10)

IT(3)

FR(2)

 
Width

14"(4)

12"(2)

32"(1)

20"(1)

18"(1)

28"(1)

 
Material(s)

Non-Woven Nylon/Polyester Fiber(25)

Nylon/Polyester Blend(24)

Steel Wool(12)

Nylon(10)

Polyester Fiber(10)

Non-Woven Fiber(9)

Non-Woven Polyester Fiber(6)

Synthetic Fiber(5)

Recycled Polyester Fiber(4)

Non-Woven Natural/Polyester Fiber(2)

Plastic(1)

Cloth(1)

Non-Woven Nylon; Polyester Fiber(1)

Foam(1)

Fiber; Mineral; Resin(1)

 
For Use With

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

Rotary Machine Speed of 175-600 rpm(29)

Rotary Floor Machines(19)

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

Machines Speed of 350 rpm(4)

3M Neutral Cleaner(4)

Rotary Floor Machines 175-600 rpm(3)

Hand Scrubbing(1)

3M Doodlebug Pad Holders(1)

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

Rotary Machine Speed of 175-3000 rpm(1)

 
 
 

© 2019-2020 Dependable Office Supply, All Rights Reserved