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_15` 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','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 '%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(19)

Simple Green(5)

Resolve(5)

Diversey(4)

Betco(3)

Spot Shot(3)

Genuine Joe(3)

RMC(3)

MISTY(2)

WD-40(2)

Stops Rust(2)

Mr. Clean(2)

Spic and Span(2)

Method(2)

Clorox(2)

Zep Commercial(2)

Swiffer(1)

Mop & Glo(1)

Scotchgard(1)

Wypall(1)

Murphy(1)

Chicopee(1)

 
Color

Blue(12)

Clear(12)

White(7)

Red(7)

Green(6)

Yellow(5)

Brown(4)

Orange(3)

Tan(2)

Sand(2)

White Clear(1)

Denim Blue(1)

Lemon(1)

Translucent(1)

Light Yellow(1)

Black(1)

 
Recycled

No(62)

Yes(5)

 
Packaged Quantity

1 Each(34)

12 / Carton(11)

4 / Carton(9)

6 / Carton(5)

2 / Carton(2)

3 / Carton(2)

100 / Carton(1)

350 / Carton(1)

45 / Carton(1)

1 Bottle(1)

 
Assembly Required

No(67)

 
Weight (Approximate)

2.58 lb(2)

9.33 lb(1)

 
Recommended Use

Stain Remover(23)

Dirt Remover(14)

Grease Remover(10)

Soil Remover(10)

Coffee Remover(9)

Odor Remover(8)

Spot Remover(6)

Scuff Mark Remover(5)

Grime Remover(5)

Blood Remover(5)

Residue Remover(4)

Food Remover(4)

Oil Remover(3)

Ink Remover(3)

Wine Remover(3)

Lipstick Remover(3)

Heel Mark Remover(2)

Soda Remover(2)

Tea Remover(2)

Spill Remover(2)

Film Remover(2)

Hard Water Remover(2)

Spaghetti Sauce Remover(1)

Make-up Remover(1)

Fingerprint Remover(1)

Streak Remover(1)

Adhesive Remover(1)

Pet Dander Remover(1)

Fluid Remover(1)

Solvent Remover(1)

Gum Remover(1)

Organic Matter Remover(1)

Urine Remover(1)

Lint Remover(1)

Dust Remover(1)

Wax Remover(1)

Smudge Remover(1)

 
Cleaner Type

Liquid(29)

Spray(17)

Foam Spray(6)

Cloth(2)

Oil(1)

Gel(1)

 
Composition

Water(5)

Hydrogen peroxide(4)

Enzyme(2)

Bleach(2)

Surfactant(2)

Alkaline(2)

Chlorine(2)

Fragrance(2)

Trisodium MGDA(1)

Lauramidopropyl Dimethylamine Oxide(1)

Polymer(1)

Sodium Tallate(1)

Coconut(1)

Aqua(1)

Preservative(1)

Silicone Emulsion(1)

Ammonia(1)

Dipropylene Glycol Monomethyl Ether(1)

 
Cleaner Volume

1 gal (128 fl oz)(25)

0.25 gal (32 fl oz)(14)

5 gal (640 fl oz)(3)

0.13 gal (16 fl oz)(2)

0.37 gal (47.34 fl oz)(2)

0.20 gal (25 fl oz)(2)

0.17 gal (22 fl oz)(2)

12 fl oz(2)

0.16 gal (20 fl oz)(2)

0.11 gal (14 fl oz)(1)

3 fl oz(1)

0.33 gal (42.20 fl oz)(1)

0.14 gal (18 fl oz)(1)

0.15 gal (19 fl oz)(1)

 
Quantity Per Container

25(1)

 
Cleaner Weight

32 oz (2 lb)(1)

22 oz (1.37 lb)(1)

64 oz (4 lb)(1)

128 oz (8 lb)(1)

 
Cleaner Size

24" Width x 24" Length(1)

8.30" Width x 16.80" Length(1)

 
Cleaner Form

Concentrate(17)

Ready-To-Use(4)

 
Manufacturer Part Number

1033704(1)

ZUFSLR128CT(1)

11201(1)

11201CT(1)

15128(1)

15128CT(1)

18402(1)

009729(1)

00993(1)

00993CT(1)

28030(1)

28030CT(1)

ZUCEC128(1)

ZUCEC128CT(1)

ZUFGC19CT(1)

ZUFSLR128(1)

ZUHLF128(1)

271455(1)

ZUHLF128CT(1)

ZUHLF32(1)

ZUHLF32CT(1)

ZUHTC128(1)

ZUHTC128CT(1)

ZUHTC32(1)

ZUHTC32CT(1)

ZUHTFF128(1)

ZUHTFF128CT(1)

ZULFFS128(1)

ZULFFS128CT(1)

ZUNEUT128(1)

ZUNEUT128CT(1)

ZUNRS128(1)

271455CT(1)

11849315CT(1)

1038048(1)

12890(1)

1840500(1)

60605-00(1)

6590500(1)

0911(1)

30892(1)

31415(1)

01151(1)

904192(1)

904192CT(1)

95122613(1)

95122613CT(1)

99671(1)

99671CT(1)

99682CT(1)

410716(1)

PC11849315(1)

00562(1)

00563(1)

02001CT(1)

02011(1)

02621CT(1)

02621EA(1)

77810(1)

00601(1)

00706(1)

00706CT(1)

74297CT(1)

97402CT(1)

58347402(1)

12000227(1)

ZUNRS128CT(1)

 
Country of Origin

United States(65)

Canada(2)

 
Scent

Fresh(5)

Lemon(3)

Mild(2)

Citrus(2)

Light Lemon(1)

Natural(1)

Almond(1)

Lemon Ginger(1)

Open-Window Fresh(1)

 
Container Type

Bottle(4)

Bag(1)

 
 
 

© 2020-2021 Gann Office Suppliers , All Rights Reserved