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

Currently Filtered by

Category

Mops

Refine Search

  GO
 
Brand

Rubbermaid Commercial(5)

Rubbermaid Commercial HYGEN(1)

LYSOL Brand(1)

Swiffer(1)

 
Warranty

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

 
Special Features

With Double-Sided Frame(1)

Swiffer Bissell SteamBoost Mop Starter Kit(1)

 
Application

Floors(6)

Floor Maintenance(1)

 
For Use With

Swiffer SteamBoost Pad Refill(1)

 
Manufacturer Part Number

2031093(1)

3486108(1)

6435BZE(1)

1863885(1)

1835529(1)

57045(1)

1835528(1)

85801(1)

 
Country of Origin

CN(6)

US(2)

 
Quantity

1 each(7)

1 kit(1)

 
Handle Material

Steel(3)

Plastic(2)

Metal(1)

Aluminum/Plastic(1)

 
Handle Color

Yellow/Black(2)

Bronze(1)

Black/Silver(1)

Blue/Silver(1)

 
Handle Length

52"(3)

48"(2)

22" to 47 1/2"(1)

55 4/5"(1)

 
Mop Head Size

18" Wide(1)

12" Wide(1)

16"(1)

17-1/2" Wide(1)

9" Wide(1)

18"(1)

10" x 5"(1)

 
Mop Head Material

Microfiber(2)

Cellulose Sponge(1)

Microfiber; Polyester(1)

Nonwoven Fiber(1)

Cellulene Sponge(1)

 
Mop Head Color

Blue(2)

White(2)

Yellow(1)

Green(1)

 
Mop Head Style

Pad(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved