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

Currently Filtered by

Category

Floor Dusters And Accessories

Refine Search
  GO
 
Brand

Swiffer(7)

Rubbermaid Commercial HYGEN(2)

3M(1)

Unger(1)

 
Warranty

Manufacturer's limited one-year warranty.(2)

 
Special Features

Value Pack-Stock up and save!(2)

Easy Trap Flip Holder-Clamping mechanism holds duster cloth.(1)

Professional Max Sweeper-17" wide head provides more than twice the surface area of regular Swiffer Sweeper.(1)

Swiffer WetJet Mop Starter Kit-Includes everything needed for clean floors, with one power mop, 5 pads, and one 500 mL bottle of solution.(1)

Standard Frame(1)

Quick Connect Squeegee Frame-Unique pull type squeegee for water and debris collection.(1)

 
Application

Floor Maintenance(3)

Floors; General Purpose(2)

Floors(2)

Hard Floors(1)

Bare Floors; Baseboards; Ceilings; Walls(1)

Bare Floors(1)

Restroom Floors(1)

 
For Use With

Swiffer Sweepers PGC 09060, PGC 92815CT; Swiffer Max Sweeper PGC 37108; Swiffer Sweep + Trap PGC 92713CT; Swiffer Sweep + Vac PGC 92705CT(2)

3M Easy Trap Duster Cloths;Threaded-Tip Mop Handles(1)

Swiffer Sweeper Cloths(1)

Swiffer Professional Max Sweeper Cloths(1)

Swiffer Max Sweeper PGC37108; Swiffer XL Sweeper 92816(1)

Swiffer WetJet Pads PGC08443CT, PGC08441, PGC81790CT; Swiffer WetJet Solution PGC83061, PGC23679CT, PGC23682, PGC91228(1)

Swiffer Sweepers PGC 09060, PGC 92815CT; Swiffer Max Sweeper PGC 37108(1)

Rubbermaid Commercial Q745, Q750, Q755, Q760, Q765, Q770, Q775, Q820, Q810, Q410, Q415, Q416, Q412, Q418(1)

Wet/Dry Microfiber Mops(1)

Unger MM40R, MB40R(1)

 
Applicable Material

Finished Hardwood; Sealed Tile; Vinyl; Ceramic; Finished Floors(3)

Sealed Hardwood; Tile; Vinyl(1)

 
Dirt Types

Dust; Dirt; Hair; Pet Hair; Crumbs(2)

Dust;Dirt;Hair;Pet Hair;Crumbs(1)

Debris;Dirt;Dust;Food Particles;Grime(1)

 
Manufacturer Part Number

59247(1)

09060CT(1)

33407CT(1)

37108(1)

37109(1)

82822CT(1)

92811CT(1)

95531CT(1)

Q559 BLA(1)

Q570(1)

SM40R(1)

 
Country of Origin

CN(5)

CA(4)

US(2)

 
Width

23"(1)

10.63"(1)

17.88"(1)

10.4"(1)

10"(1)

18"(1)

24"(1)

16"(1)

 
Depth

4"(1)

3.38"(1)

4.5"(1)

4 1/4"(1)

 
Color(s)

White(4)

Black(2)

Yellow(1)

Red(1)

 
Material(s)

Cloth(4)

Plastic(2)

Aluminum(1)

Nylon(1)

 
Length

8"(3)

10"(1)

 
Scent

Unscented(3)

Open Window Fresh(1)

 
Handle Material

Aluminum/Plastic(3)

 
Number of Plies

1(4)

 
Packaging

Box(3)

Shrink-Wrapped Resealable Tub(1)

 
Towel/Wipe Type

Dry Floor Wipes(2)

Dry Wipes(1)

Wet Floor Wipes(1)

 
Number of Towels/Wipes Per Container

32(1)

16(1)

37(1)

12(1)

 
Handle Color

Green/Silver(2)

Purple/Silver(1)

 
Handle Length

46"(3)

 
Mop Head Size

23" x 4"(1)

10 x 4.8(1)

17" x 5"(1)

11 x 5(1)

4 1/4 x 16(1)

 
Mop Head Material

Cloth(3)

 
Mop Head Color

White(3)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved

Powered by SITS Erp