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') 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)

3M(1)

 
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)

 
Application

Floor Maintenance(3)

Floors; General Purpose(2)

Floors(2)

Hard Floors(1)

 
For Use With

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

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

Swiffer Sweeper Cloths(1)

Swiffer Professional Max Sweeper Cloths(1)

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

Swiffer WetJet Pads and Solution Bottles(1)

Swiffer Sweepers 09060, 92815; Swiffer Max Sweeper 37108(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)

 
Country of Origin

CA(4)

CN(2)

US(2)

 
Width

23"(1)

10 5/8"(1)

17 7/8"(1)

10 2/5"(1)

10"(1)

 
Depth

4"(1)

 
Color(s)

White(4)

Black(1)

 
Material(s)

Cloth(4)

Plastic(1)

 
Length

8"(3)

10"(1)

 
Quantity

3 per carton(2)

1 each(1)

2 per carton(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 4/5"(1)

17" x 5"(1)

11" x 5"(1)

 
Mop Head Material

Cloth(3)

 
Mop Head Color

White(3)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved

Powered by SITS Erp