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

Currently Filtered by

Category

Floor And Carpet Cleaners

Refine Search

  GO
 
Brand

Zep Commercial(14)

RMC(8)

Betco(8)

Zep(7)

Resolve(6)

Big 3 Packaging(6)

Simple Green(5)

Franklin(4)

Diversey(4)

Spot Shot(4)

Franklin Chemical(3)

Genuine Joe(3)

Green Earth(3)

Mop & Glo(3)

Shout(2)

WD-40(2)

Stops Rust(2)

MISTY(2)

Swiffer(2)

Mr. Clean(2)

Spic and Span(2)

Murphy(2)

Clorox(2)

Method(2)

Scotchgard(1)

Wypall(1)

Church & Dwight(1)

 
Color

Clear(21)

Blue(15)

Yellow(10)

White(10)

Green(7)

Red(7)

Tan(5)

Orange(4)

Lemon(2)

Sand(2)

Multi(2)

Purple(2)

Off White(2)

Light Yellow(2)

Black(1)

Pale Yellow(1)

Translucent(1)

Denim Blue(1)

Milky Green(1)

White Clear(1)

Light Straw(1)

Light Green(1)

Brown(1)

 
Recycled

No(94)

Yes(6)

 
Packaged Quantity

1 Each(44)

4 / Carton(18)

12 / Carton(13)

6 / Carton(8)

50 / Each(3)

2 / Carton(3)

3 / Carton(2)

1 Carton(2)

100 / Pack(1)

20 / Pack(1)

8 / Carton(1)

36 / Pallet(1)

350 / Carton(1)

45 / Carton(1)

1 Bottle(1)

1 / Carton(1)

 
Assembly Required

No(100)

 
Weight (Approximate)

2.58 lb(2)

9.33 lb(1)

 
Recommended Use

Stain Remover(29)

Dirt Remover(26)

Soil Remover(22)

Grease Remover(17)

Odor Remover(10)

Coffee Remover(10)

Spot Remover(7)

Food Remover(7)

Grime Remover(7)

Oil Remover(6)

Blood Remover(5)

Wine Remover(5)

Scuff Mark Remover(5)

Residue Remover(5)

Ink Remover(4)

Heel Mark Remover(3)

Tea Remover(3)

Lipstick Remover(3)

Pet Dander Remover(3)

Make-up Remover(3)

Soda Remover(3)

Paint Remover(2)

Hard Water Remover(2)

Film Remover(2)

Spill Remover(2)

Streak Remover(2)

Scratch Remover(2)

Finish Remover(2)

Organic Matter Remover(1)

Grape Juice Remover(1)

Fingerprint Remover(1)

Spaghetti Sauce Remover(1)

Starch Remover(1)

Fat Remover(1)

Scum Remover(1)

Wax Remover(1)

Dust Remover(1)

Urine Remover(1)

Allergen Remover(1)

Grass Remover(1)

Mud Remover(1)

Dust Mite Remover(1)

Fluid Remover(1)

Solvent Remover(1)

Gum Remover(1)

Adhesive Remover(1)

Haze Remover(1)

Smudge Remover(1)

 
Cleaner Type

Liquid(48)

Spray(22)

Foam Spray(5)

Oil(2)

Powder(1)

Gel(1)

Cloth(1)

Aerosol(1)

 
Composition

Water(12)

Fragrance(5)

Hydrogen peroxide(4)

Enzyme(2)

Acrylic Copolymer(2)

Alkaline(2)

Benzisothiazolinone(2)

Surfactant(2)

Isopropyl Alcohol(2)

Dipropylene Glycol Monoethyl Ether(2)

Tributoxyethyl Phosphate(2)

Bleach(2)

Diethylene Glycol Monoethyl Ether(2)

Chlorine(2)

Lauramidopropyl Dimethylamine Oxide(2)

Trisodium MGDA(2)

Sodium Tallate(2)

Coconut(2)

Ammonium Salt(1)

Ammonia(1)

Silicone Emulsion(1)

Ammonium Hydroxide(1)

Rosin Modified Maleic Resin(1)

Partially Fluorinated Alcohol(1)

Phosphorus Oxide (P2O5)(1)

Oxidized Polyethylene(1)

Polyethoxylated Methyloctadecylammonium Methyl Sulfate(1)

Modified Acrylic Polymer(1)

Zinc Oxide(1)

Preservative(1)

Aqua(1)

Trideceth-3(1)

Dipropylene Glycol Monomethyl Ether(1)

ppg-10-laureth-7(1)

Sodium Alkyl Sulfate(1)

Polymer(1)

Baking Soda(1)

Disodium Capryloamphodiproprionate(1)

Disodium EDTA(1)

Octenylsuccinic Acid(1)

Disodium Carboxylate(1)

Dipropylene Glycol n-propyl Ether(1)

Methylisothiazolinone(1)

Methoxyisopropanol(1)

Ethyl Glycerin Acetal Levulinate(1)

Sodium Citrate(1)

Detergent(1)

Phenoxyethanol(1)

Colorants(1)

Citric Acid(1)

 
Cleaner Volume

1 gal (128 fl oz)(33)

0.25 gal (32 fl oz)(20)

5 gal (640 fl oz)(8)

0.17 gal (22 fl oz)(3)

0.16 gal (20 fl oz)(2)

12 fl oz(2)

0.14 gal (18 fl oz)(2)

0.33 gal (42.20 fl oz)(2)

0.20 gal (25 fl oz)(2)

0.37 gal (47.34 fl oz)(2)

0.50 gal (64 fl oz)(2)

0.11 gal (14 fl oz)(1)

3 fl oz(1)

0.13 gal (16 fl oz)(1)

250 gal(1)

2.50 gal (320 fl oz)(1)

0.53 gal (67.63 fl oz)(1)

0.15 gal (19 fl oz)(1)

 
Cleaner Weight

64 oz (4 lb)(2)

0.79 oz (0.05 lb)(1)

42.60 oz (2.66 lb)(1)

32 oz (2 lb)(1)

22 oz (1.37 lb)(1)

128 oz (8 lb)(1)

 
Cleaner Size

8.30" Width x 16.80" Length(1)

 
Cleaner Form

Concentrate(25)

Ready-To-Use(9)

 
Manufacturer Part Number

1033704(1)

11849315CT(1)

18402(1)

15128CT(1)

15128(1)

11201CT(1)

11201(1)

697265CT(1)

697265(1)

271455CT(1)

271455(1)

PC11849315(1)

009729CT(1)

11927246(1)

11904125(1)

11904045(1)

11847945(1)

11808445(1)

11767489(1)

58347402(1)

97402CT(1)

89333(1)

74297CT(1)

009729(1)

00993(1)

00706CT(1)

ZUHTC128(1)

ZUNRS128(1)

ZUNEUT128CT(1)

ZUNEUT128(1)

ZULFFS128CT(1)

ZULFFS128(1)

ZUHTFF128CT(1)

ZUHTFF128(1)

ZUHTC32CT(1)

ZUHTC32(1)

ZUHTC128CT(1)

ZUHLF32CT(1)

00993CT(1)

ZUHLF32(1)

ZUHLF128CT(1)

ZUHLF128(1)

ZUFSLR128CT(1)

ZUFSLR128(1)

ZUFGC19CT(1)

ZUCEC128CT(1)

ZUCEC128(1)

28030CT(1)

28030(1)

74297(1)

00706(1)

1033704CT(1)

5687504(1)

01151(1)

31415(1)

30892(1)

3320084113CT(1)

5964B12(1)

59642012(1)

59641004(1)

5789504(1)

5749504(1)

6590500(1)

904192(1)

6081200(1)

60605-00(1)

5364700(1)

5360400CT(1)

53604-00(1)

4200400CT(1)

4200400(1)

2584700(1)

1840500(1)

1540500(1)

01151CT(1)

904192CT(1)

00601CT(1)

12890(1)

00601(1)

77810CT(1)

77810(1)

02621EA(1)

02621CT(1)

02011(1)

02001CT(1)

00563CT(1)

00563(1)

410716(1)

99682CT(1)

95122613(1)

99671CT(1)

99671(1)

F216022EA(1)

F216022CT(1)

538022(1)

465226PL(1)

465226(1)

380422CT(1)

380422(1)

95122613CT(1)

ZUNRS128CT(1)

 
Country of Origin

United States(99)

Canada(2)

 
Material

Polyethylene Terephthalate (PET)(1)

 
Scent

Fresh(7)

Lemon(5)

Citrus(4)

Mild(2)

Fresh Herbal(2)

Polymeric(2)

Lemon Ginger(2)

Open-Window Fresh(2)

Rain Fresh(1)

Clean Bouquet(1)

Ocean Fresh(1)

Ocean(1)

Natural(1)

Pleasant(1)

Apple(1)

Floral(1)

Banana(1)

Fresh Citrus(1)

 
Container Type

Bottle(6)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved