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

Currently Filtered by

Category

Mop Heads

Refine Search

  GO
 
Brand

Rubbermaid Commercial(17)

Swiffer(5)

Rubbermaid Commercial HYGEN(3)

Unger(1)

Scotch-Brite(1)

 
Warranty

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

 
Special Features

Medium Microfiber Mop Head(2)

Extra Power-With the scrubbing power of Mr. Clean Magic Eraser.(2)

Large Microfiber Mop Head(2)

Medium Shrinkless Mop Head(2)

Large Shrinkless Mop Head(2)

15mm Pile(1)

1" Headband(1)

 
Application

Floor Maintenance(20)

Floors(5)

Window Cleaning(1)

Floors; Walls(1)

 
For Use With

Rubbermaid Commercial Invader Wet Mop Handles(4)

Swiffer WetJet System(4)

Maximizer 3-in-1 Floor Prep Tool(2)

Rubbermaid Commercial Gripper Wet Mop Handles(1)

Rubbermaid Commercial Microfiber Mopping System(1)

Unger SmartColor Mop Holder(1)

Maximizer Overhead Cleaning Tool(1)

Rubbermaid Steel Roller Sponge Mop(1)

Rubbermaid Commercial 2017161 Spill Mop Handle(1)

Swiffer Bissell SteamBoost Mop(1)

Rubbermaid Commercial HYGEN Clean Water System(1)

Rubbermaid Commercial HYGEN Quick-Connect Wet/Dry Frame(1)

Scotch-Brite Microfiber Hardwood Floor Mop(1)

 
Manufacturer Part Number

2018786(1)

2018825(1)

2018784(1)

2017059(1)

1924815(1)

2025502(1)

2025506(1)

V118(1)

MM40R(1)

Q42600GR00(1)

F21800(1)

6436 YEL(1)

1924814(1)

1924813(1)

81790CT(1)

85824(1)

81790(1)

08443CT(1)

08443(1)

1791678CT(1)

1822352(1)

1924785(1)

1924812(1)

1924784(1)

1924783(1)

1924782(1)

M-005-R(1)

 
Country of Origin

US(14)

CN(8)

CA(2)

DE(1)

ID(1)

KR(1)

 
Head Type

Wet Mop(8)

Microfiber(7)

Wet/Dry Pad(4)

Dust Mop(2)

Microfiber Flat Mop(1)

Cut-End(1)

Sponge(1)

Wet Pad(1)

 
Washable

Yes(13)

No(10)

 
Mop Head Size

Medium(4)

11.3" x 5.4"(4)

Large(4)

#20(2)

24 oz(2)

16w x 5d(1)

12" Wide(1)

24w x 9d(1)

11" x 5.25" x 0.188"(1)

2.63" x 1.38" x 0.25"(1)

10" x 9"(1)

17 1/2"l x 12"w x 1/2"h(1)

18 in(1)

17" Wide(1)

2.625" x 1.375" x 0.5"(1)

 
Mop Head Material

Microfiber(10)

Blended(4)

Cotton(4)

Nonwoven Fiber(3)

Cloth(2)

Polyester Fibers(2)

Cellulose Sponge(1)

 
Mop Head Color

White(9)

Green(6)

Blue(5)

Yellow(2)

Gray(2)

Red(1)

White/Blue(1)

Orange/White(1)

 
Mop Head Style

Pad Refill(5)

Pad(4)

Cut End(1)

Microfiber Flat Mop(1)

Looped End(1)

Cotton Mop(1)

Microfiber(1)

Flat Wet Mop(1)

 
Headband Color

Black(4)

White(3)

Blue(2)

Green(2)

 
Headband Size

Large(4)

Medium(4)

1 in(1)

1"(1)

5"(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved