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','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 '%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(29)

Rubbermaid Commercial HYGEN(5)

Swiffer(5)

Scotch-Brite(1)

Unger(1)

 
Warranty

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

Manufacturer's limited lifetime warranty.(1)

 
Special Features

5" Headband(3)

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

Medium Shrinkless Mop Head(2)

Large Microfiber Mop Head(2)

Medium Microfiber Mop Head(2)

1" Headband(2)

Large Shrinkless Mop Head-Length: 19 1/2"; Diameter: 61 3/10"(1)

Large Shrinkless Mop Head(1)

15mm Pile(1)

 
Application

Floor Maintenance(27)

Floors(11)

Floors; Walls(1)

Window Cleaning(1)

Walls(1)

 
For Use With

Swiffer WetJet 92811 and 92810(4)

Rubbermaid Commercial Invader Wet Mop Handles(4)

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

MMM005(1)

Rubbermaid Commercial Q560 Pad Holder(1)

U110 Wedge Mop Handle and Frame(1)

Rubbermaid Commercial S216 and S226 Wall Washer Kits(1)

Rubbermaid Commercial Q550 Pad Holder(1)

Rubbermaid Commercial Microfiber Mopping System(1)

Maximizer Overhead Cleaning Tool(1)

Rubbermaid Steel Roller Sponge Mop(1)

Rubbermaid Commercial 1863901; Rubbermaid Commercial FGH215000000; Rubbermaid Commercial FGH216000000; Rubbermaid Commercial FGH225000000; Rubbermaid Commercial FGH226000000; Rubbermaid Commercial FGH235000000; Rubbermaid Commercial FGH236000000; Rubbermaid Commercial FGH246000000; Rubbermaid Commercial FGH24600BL00; Rubbermaid Commercial FGH24600GR00; Rubbermaid Commercial FGH24600GY00; Rubbermaid Commercial FGH24600RD00(1)

2017061 Spill Mop Handle(1)

Rubbermaid Commercial HYGEN Q560(1)

Rubbermaid Commercial HYGEN Clean Water System(1)

Swiffer 85801; Swiffer 85801CT(1)

Unger SmartColor Mop Holder(1)

 
Manufacturer Part Number

M-005-R(1)

F21800(1)

A153 GRE(1)

A21206WHICT(1)

A25206WHI(1)

A25206WHICT(1)

A413(1)

D253 BLU(1)

E238(1)

J15300YEL(1)

2025506(1)

Q410 RED(1)

Q42600GR00(1)

Q438(1)

Q449(1)

Q820 BLU(1)

S299(1)

U130(1)

V118(1)

6436 YEL(1)

2025502(1)

08443(1)

1924783(1)

08443CT(1)

81790(1)

81790CT(1)

85824(1)

1791678CT(1)

1822352(1)

1924782(1)

1924784(1)

2018825(1)

1924785(1)

1924812(1)

1924813(1)

1924814(1)

1924815(1)

2017059(1)

2018784(1)

2018786(1)

MM40R(1)

 
Country of Origin

US(24)

CN(8)

VN(5)

CA(2)

KR(1)

DE(1)

 
Head Type

Wet Mop(13)

Microfiber(7)

Dust Mop(5)

Wet/Dry Pad(4)

Wet Mop Pad(3)

Looped-End(2)

Wet Pad(1)

Sponge(1)

Cut-End(1)

Dust(1)

Microfiber Flat Mop(1)

 
Washable

Yes(27)

No(10)

 
Mop Head Size

Medium(7)

Large(7)

11.3 x 5.4(4)

24 oz(3)

#20(2)

17" Wide(1)

18.5 x 5.5 x 0.5(1)

13 1/2"w x 17 1/2"l(1)

9w x 5d(1)

13.75w x 5.5d x 0.5h(1)

48" x 9"(1)

36"(1)

24w x 9d(1)

12" Wide(1)

24 x 5(1)

11" x 5.25" x 0.188"(1)

2.625" x 1.375" x 0.5"(1)

2.63" x 1.38" x 0.25"(1)

18"(1)

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

10" x 9"(1)

16w x 5d(1)

 
Mop Head Material

Microfiber(14)

Cotton(6)

Blended(4)

Cotton/Synthetic Blend(4)

Nonwoven Fiber(3)

Cotton/Synthetic(3)

Cloth(2)

Polyester Fibers(2)

Cellulose Sponge(1)

Four-Ply Blended Yarn(1)

 
Mop Head Color

White(15)

Green(9)

Blue(8)

Yellow(3)

Gray(2)

Red(2)

White/Blue(1)

Orange/White(1)

 
Mop Head Style

Looped End(9)

Pad Refill(5)

Pad(4)

Cut End(4)

Microfiber Wet Room Pad(2)

Microfiber(1)

Cotton Mop(1)

Flat Wet Mop(1)

Microfiber Flat Mop(1)

 
Headband Color

Green(5)

Black(4)

White(4)

Blue(3)

Red(2)

Yellow(1)

 
Headband Size

Large(4)

Medium(4)

1 in(4)

5 in(3)

5"(2)

1"(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved

Powered by SITS Erp