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') 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)

Zep(7)

Betco(6)

Diversey(4)

Simple Green(4)

Resolve(4)

Big 3 Packaging(4)

Spot Shot(3)

Genuine Joe(3)

RMC(3)

WD-40(2)

Stops Rust(2)

Spic and Span(2)

Green Earth(2)

Mr. Clean(2)

Method(2)

Chicopee(1)

Professional Lysol(1)

Clorox(1)

Scotchgard(1)

Swiffer(1)

MISTY(1)

 
Color

Blue(15)

Clear(11)

Yellow(8)

White(7)

Red(7)

Green(5)

Orange(4)

Purple(2)

Sand(2)

Black(1)

Brown(1)

Tan(1)

Translucent(1)

White Clear(1)

Light Green(1)

Lemon(1)

Milky White(1)

 
Recycled

No(65)

Yes(5)

 
Packaged Quantity

1 Each(33)

12 / Carton(11)

4 / Carton(10)

6 / Carton(5)

50 / Each(3)

2 / Carton(2)

3 / Carton(2)

1 Bottle(1)

45 / Carton(1)

100 / Carton(1)

100 / Each(1)

 
Assembly Required

No(70)

 
Weight (Approximate)

2.58 lb(2)

9.33 lb(1)

 
Recommended Use

Stain Remover(22)

Dirt Remover(17)

Soil Remover(12)

Coffee Remover(9)

Grease Remover(8)

Odor Remover(7)

Spot Remover(7)

Grime Remover(5)

Blood Remover(5)

Scuff Mark Remover(4)

Residue Remover(4)

Food Remover(3)

Ink Remover(3)

Wine Remover(3)

Lipstick Remover(3)

Oil Remover(3)

Hard Water Remover(2)

Tea Remover(2)

Soda Remover(2)

Gum Remover(2)

Starch Remover(2)

Heel Mark Remover(2)

Fingerprint Remover(1)

Smudge Remover(1)

Film Remover(1)

Spaghetti Sauce Remover(1)

Spill Remover(1)

Make-up Remover(1)

Adhesive Remover(1)

Protein Remover(1)

Lint Remover(1)

Dust Remover(1)

Wax Remover(1)

Urine Remover(1)

Fat Remover(1)

Organic Matter Remover(1)

Bacteria Remover(1)

Pet Dander Remover(1)

 
Cleaner Type

Liquid(32)

Spray(15)

Foam Spray(6)

Cloth(1)

Gel(1)

 
Composition

Hydrogen peroxide(4)

Water(4)

Surfactant(2)

Enzyme(2)

Alkaline(2)

Bleach(2)

Chlorine(2)

Polymer(1)

Ammonia(1)

Fragrance(1)

Detergent(1)

 
Cleaner Volume

1 gal (128 fl oz)(25)

0.25 gal (32 fl oz)(12)

5 gal (640 fl oz)(3)

0.37 gal (47.34 fl oz)(2)

0.20 gal (25 fl oz)(2)

0.16 gal (20 fl oz)(2)

12 fl oz(2)

0.13 gal (16 fl oz)(2)

0.14 gal (18 fl oz)(1)

0.15 gal (19 fl oz)(1)

0.17 gal (22 fl oz)(1)

0.11 gal (14 fl oz)(1)

0.50 gal (64 fl oz)(1)

0.53 gal (67.63 fl oz)(1)

250 gal(1)

3 fl oz(1)

0.33 gal (42.20 fl oz)(1)

 
Quantity Per Container

25(1)

 
Cleaner Weight

32 oz (2 lb)(2)

128 oz (8 lb)(1)

64 oz (4 lb)(1)

0.53 oz (0.03 lb)(1)

0.79 oz (0.05 lb)(1)

22 oz (1.37 lb)(1)

 
Cleaner Size

24" Width x 24" Length(1)

 
Cleaner Form

Concentrate(18)

Ready-To-Use(3)

 
Non-Acidic

Yes(1)

 
Manufacturer Part Number

28030(1)

00993CT(1)

00993(1)

28030CT(1)

ZUCEC128(1)

ZUFGC19CT(1)

ZUCEC128CT(1)

009729(1)

15128CT(1)

271455(1)

11849315CT(1)

PC11849315(1)

271455CT(1)

11201(1)

15128(1)

11201CT(1)

ZUFSLR128(1)

ZUFSLR128CT(1)

ZULFFS128CT(1)

ZULFFS128(1)

ZUHTFF128CT(1)

ZUNEUT128(1)

ZUNEUT128CT(1)

ZUNRS128CT(1)

ZUNRS128(1)

ZUHTFF128(1)

ZUHTC32CT(1)

ZUHLF32(1)

ZUHLF128CT(1)

ZUHLF128(1)

ZUHLF32CT(1)

ZUHTC128(1)

ZUHTC32(1)

ZUHTC128CT(1)

12000227(1)

58347402(1)

5789504(1)

5749504(1)

57351004(1)

0911(1)

31415(1)

904192CT(1)

904192(1)

5687504(1)

6590500(1)

2584700(1)

1840500(1)

1331200(1)

4200400(1)

53604-00(1)

60605-00(1)

5364700(1)

95122613(1)

95122613CT(1)

77810(1)

02621EA(1)

02621CT(1)

00706(1)

00706CT(1)

97402CT(1)

74297CT(1)

02011(1)

02001CT(1)

99671CT(1)

99671(1)

99682CT(1)

410716(1)

00563(1)

00562(1)

1038048(1)

 
Country of Origin

United States(68)

Canada(2)

 
Scent

Fresh(4)

Citrus(3)

Mild(2)

Lemon(2)

Almond(1)

Open-Window Fresh(1)

Lemon Ginger(1)

Lavender(1)

New Green(1)

Rain Fresh(1)

Ocean Fresh(1)

Light Lemon(1)

Ocean(1)

 
Container Type

Bottle(5)

Bag(1)

 
 
 

© 2019-2020 Gann Office Suppliers , All Rights Reserved