Banner1 Banner1
 
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_36` 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 ('691')) 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

Boardwalk(40)

Rubbermaid Commercial(5)

Swiffer(5)

LYSOL Brand(3)

Rubbermaid Commercial HYGEN(2)

Quickie(2)

Scotch-Brite(1)

Mr. Clean(1)

 
Manufacturer Part Number

724RCT(1)

720R(1)

724REA(1)

M-005-R(1)

08443CT(1)

08443(1)

542CT(1)

503WHEA(1)

503BLEA(1)

503BLCT(1)

503GNCT(1)

503GNEA(1)

503WHCT(1)

81790(1)

85802(1)

G781(1)

6436 YEL(1)

Q409BLUEA(1)

Q41000BLU(1)

Q415BE(1)

Q411 BLU(1)

1822352(1)

720784M6(1)

570442(1)

85802CT(1)

570911(1)

590941M(1)

604ZQK(1)

502WHEA(1)

502WHCT(1)

1636(1)

1624(1)

2016CCT(1)

2016CEA(1)

2020CEA(1)

2020CCT(1)

1360(1)

1348(1)

1124(1)

1118(1)

1136(1)

1324(1)

1336(1)

2024CCT(1)

2024CEA(1)

424CCT(1)

4024RCT(1)

424CEA(1)

424REA(1)

502BLEA(1)

502BLCT(1)

4024CCT(1)

224CCT(1)

2032CEA(1)

2032CCT(1)

216CCT(1)

220CCT(1)

220RCT(1)

446841(1)

 
Country of Origin

US(36)

CN(16)

ID(4)

CA(2)

KR(1)

 
For Use With

Swiffer WetJet System(3)

Swiffer Bissell SteamBoost Mop(2)

UNS834(2)

Rubbermaid Steel Roller Sponge Mop(1)

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

Rubbermaid PVA Sponge Mop(1)

Quickie Flip & Shine Dual Sided Microfiber Hardwood Floor Mop(1)

Rubbermaid Commercial Light Commercial Spray Mop(1)

Rubbermaid Commercial Pad Holders(1)

Quickie Lysol Self Wringing Mop(1)

Scotch-Brite Microfiber Hardwood Floor Mop(1)

Lie-Flat Screw-In Handles(1)

Quickie Lysol Sponge Mop(1)

Mr. Clean Roller Mop 446840(1)

Quickie Lysol Cone Mop Supreme(1)

Quickie Swivel Soft Hardwood Dust Mop(1)

 
Washable

Yes(15)

No(6)

 
Headband Color

White(3)

Blue(2)

 
Headband Size

1 1/4 in(3)

2 1/2"(1)

2"(1)

 
Head Type

Wet Mop(33)

Dust Mop(11)

Wet/Dry Pad(5)

Microfiber(4)

Sponge(4)

Wet Mop Pad(1)

Woven Fibers(1)

 
Mop Head Size

Large(6)

24 oz(6)

Medium(5)

#24(4)

11.3" x 5.4"(3)

24w x 5d(3)

20 oz(3)

10" x 9"(2)

#20(2)

#32(2)

#16(2)

36w x 5d(2)

6 3/4" x 1 3/4" x 11"(1)

19 1/2"(1)

18" Wide(1)

18 in(1)

12" Wide(1)

8" Wide(1)

18"(1)

18 1/2 x 5 1/2 x 1/2 in(1)

10 1/2" Wide(1)

18" x 5"(1)

16 oz(1)

60 x 5(1)

48 x 5(1)

24" x 5"(1)

11 1/2 x 3 13/20 x 2 1/4(1)

9" Wide(1)

17" Wide(1)

36" x 5"(1)

11" Wide(1)

 
Mop Head Material

Cotton(17)

Cotton;Synthetic(10)

Microfiber(8)

Rayon(6)

Cotton/Synthetic Blend(5)

Premium Cotton(3)

Nonwoven Fiber(2)

Chenille Microfiber(1)

Polyvinyl Alcohol(1)

Woven Fibers(1)

Cellulose Sponge(1)

Cloth(1)

Rayon/Polyester(1)

Foam(1)

Cellulene Sponge(1)

 
Mop Head Color

White(35)

Blue(12)

Green(5)

Yellow(2)

White/Blue(2)

Blue/Gray(1)

Green/Blue(1)

White/Blue Stripes(1)

 
Mop Head Style

Looped End(19)

Cut End(19)

Pad Refill(5)

Microfiber(2)

Microfiber Wet Room Pad(2)

Dual-Sided Microfiber(1)

Cellulene Sponge(1)

Foam Roller(1)

Woven Fibers(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved