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

Currently Filtered by

Category

Cleaning Products

Refine Search

  GO
 
Brand

Simple Green(19)

Diversey(10)

Zep Commercial(8)

Misty(6)

WEIMAN(6)

Spray Nine(5)

Clorox(4)

Professional EASY-OFF(4)

Armor All(3)

Boardwalk(3)

Formula 409(3)

BREAK-UP(3)

Theochem Laboratories(3)

Kess(3)

WD-40(2)

EASY-OFF(2)

Seventh Generation(2)

LYSOL Brand(2)

CLR PRO(2)

Method(2)

Scotch-Brite PROFESSIONAL(2)

Zep Professional(2)

Dymon(1)

Hope's(1)

Seventh Generation Professional(1)

Franklin Cleaning Technology(1)

Dust-Off(1)

Endust for Electronics(1)

Suma(1)

Chase Products(1)

 
Packing Type

Bottle(43)

Spray Bottle(23)

Aerosol(16)

Smart Tube Spray Bottle(4)

Pail(3)

Drum(3)

Can(2)

Packet(2)

Trigger Spray Bottle(2)

Squeeze Bottle(2)

Bottle of Concentrate(1)

Container(1)

RTD Bottle(1)

Kit(1)

 
Manufacturer Part Number

1002262(1)

13006(1)

18401(1)

18203(1)

14010(1)

14002(1)

13455(1)

13421(1)

13406(1)

13012CT(1)

13012(1)

13008(1)

13005EA(1)

19005(1)

13005CT(1)

44725CT(1)

22858CT(1)

22858(1)

89771EA(1)

89771CT(1)

87980(1)

87979CT(1)

80689CT(1)

79556EA(1)

18402(1)

19010(1)

74017(1)

137(1)

1041483(1)

ZUMM8EA(1)

ZUMM8CT(1)

ZUCIT128CT(1)

ZUALL32EA(1)

ZUALL32CT(1)

ZU50532EA(1)

ZU50532CT(1)

1046806(1)

137EA(1)

109EA(1)

19024(1)

109(1)

107EA(1)

107(1)

300363(1)

300356(1)

505918EA(1)

505918(1)

100960-QT(1)

19128(1)

19055(1)

79556(1)

00065CT(1)

1002285(1)

00014(1)

904495(1)

100986236(1)

100870948(1)

100839702(1)

35306EA(1)

35306CT(1)

30865CT(1)

30865(1)

30861CT(1)

30861(1)

5161(1)

93313117(1)

4812(1)

350AEA(1)

350ACT(1)

10710(1)

10228EA(1)

10228CT(1)

1038695(1)

1033954(1)

1003210(1)

1003164(1)

93062493(1)

95002232(1)

00065(1)

268014CT(1)

29603(1)

26012(1)

TITAN4(1)

PURPLEPWR(1)

GREASE-O(1)

GM4PROCT(1)

GM-4PRO(1)

36120(1)

26832CT(1)

26832(1)

26801-4(1)

95401786(1)

22732(1)

22GR6(1)

F266022(1)

DCKB(1)

096000(1)

CBD991209(1)

CBD991206EA(1)

CBD991206(1)

95891164(1)

95877531(1)

957278280(1)

1041483EA(1)

 
Country of Origin

US(97)

CA(7)

 
Capacity (Volume)

1 gal(28)

32 oz(16)

20 oz(7)

24 oz(7)

22 oz(5)

28 oz(4)

19 oz(4)

128 oz(4)

5 gal(3)

8 oz(3)

55 gal(3)

1 qt(2)

14.5 oz(2)

18 oz(2)

3.78 L(1)

2.5 L(1)

16 oz(1)

1500 mL(1)

5 L(1)

2 oz(1)

18.000 oz(1)

3 L(1)

17 oz(1)

3.2 oz(1)

14 oz(1)

2 qt(1)

1.32 gal(1)

 
Scent

Unscented(46)

Citrus(12)

Sassafras(7)

Lemon(6)

Fresh(4)

Clean(4)

Mandarin Orange(3)

Pleasant(3)

Apple Orchard(2)

Floral(2)

Apple(2)

Neutral(1)

Fresh Pine(1)

Acidic(1)

Lavender(1)

Slight(1)

 
Dirt Types

Grease; Grime; Lubricants; Oil-Based Soil(20)

Carbon; Food Debris; Grease; Grime; Oil-Based Soil; Organic Matter; Smoke Film(13)

Grease; Grime(5)

Dirt; Oil; Grease; Hydraulic Fluid; Exhaust Residue; Fresh Paint; Wallpaper Paste; Soap Scum; Burned-on Food; Soot; Ash; Smoke Film; Carpet Stains; Fabric Stains; Scuff Marks; Bacteria; Dust; Fungus; Germs; Grime; Mildew; Mold; Organic Matter; Viruses; Water-Based Soil(4)

Bacteria; Fungus; Grease; Grime; Oil; Soil(4)

Debris; Dust; Grease; Fingerprints; Soil; Smudges(3)

Carbon; Grease; Grime; Lubricants; Oil-Based Soil; Smoke Film; Tar(2)

Food(2)

Grease; Fat; Oil(2)

Baked and Burnt on Foods; Germs; Grease; Grime(2)

Grease; Oil; Dirt; Dust(2)

Grease; Grime; Ink; Lubricants; Oil-Based Soil; Tar(2)

Dirt; Grease; Grime; Soap Scum(2)

Dirt; Residue; Soil(2)

Grease; Grime; Oil-Based Soil; Organic Matter; Water-Based Soil(2)

Grease; Grime; Surface Stains(2)

Brake Fluid; Grease; Grime; Lubricants; Oil-Based Soil; Water-Based Soil(2)

Dust(2)

Bacteria; Grease; Grime; HIV-1; Oil; Smoke Film; Soil; Viruses(2)

Baked-on Food(2)

Surface Spots; Stains(2)

Grease; Oil; Dirt; Dust; Soap Scum(1)

Adhesives; Dirt; Germs; Grease; Grime; Oil(1)

Dirt; Grease; Lubricants; Oil(1)

Build-Up; Grime; Heavy Grease; Oil(1)

Dirt; Grease; Grime(1)

Fingerprints; Grease; Grime; Oil(1)

Rust Stains(1)

Dirt; Grease(1)

Debris; Dirt; Dust(1)

Stains(1)

Coffee; Grease; Ink; Oil(1)

Adhesive; Grease; Grime; Lubricants; Oil-Based Soil(1)

Adhesives; Dust; Grease; Grime; Oil-Based Soil; Water-Based Soil(1)

Grease; Grime; Hydraulic Fluid; Lubricants; Oil-Based Soil; Tar(1)

Carbon; Dirt; Grease; Grime; Ink; Oil; Scuff Mark; Smoke Film; Tire Mark; Wax(1)

Grease; Fats; Carbonized Soil(1)

Food Residue; Grease(1)

Grease; Oils; Proteins(1)

Grease; Oil; Soil(1)

Food Soils; Grease; Grime; Petroleum; Stains(1)

Grease; Soil(1)

Food Debris; Grease; Grime; Oil-Based Soil; Organic Matter; Smoke Film(1)

Dirt;Food Stain;Grease;Grime(1)

Baked-on Grease; Baked-on Food(1)

 
Chemical Compound

Water based non-ionic surfactant(10)

Water Based Non-Ionic Surfactant(4)

N-Alkyl Dimethyl Benzyl Ammonium Chloride; N-Alkyl Dimethyl Ethybenzyl Ammonium Chloride; Ethoxylated Alcohols; Dipropylene Glycol Mononbutyl Ether(4)

Ethanol(2)

Alkyl (67% C12, 25% C14, 7% C16, 1% C8-C10-C18) dimethyl benzyl ammonium chlorides(2)

Ethoxylated Alcohol(2)

Sodium Carbonate(2)

Sodium Hydroxide; Diethylene Glycol Monobutyl Ether(2)

Natural Ingredients; Plant-Derived Surfactants(2)

Sodium Metasilicate-Pentahydrate HR NOAH; 2 Butoxyethanol; Linear Alcohol Ethoxylate(2)

D-Glucopyranose; Oligomers; Decyl Octyl Glycosides(2)

Diethylene Glycol Monobutyl Ether(1)

Glycollic Acid; Oxalic Acid; Phosphoric Acid(1)

Alcohols, C9-11, ethoxylated; C14-16-alkane hydroxy and C14- 16-alkene; Sadium Salts; Sulfonic Acids(1)

Alkyl(C9-11) Alcohol; Ethoxylated(1)

Alcohols; C9-11; Ethoxylated(1)

Benzenesulfonic Acid; C10-16-alkyl Derivis(1)

Tetrasodium Ethylenediaminetetraacetate(1)

Fatty Acids; Tall-Oil; Sulfonic Acids; C14-16-alkane hydroxy and C14-16-alkene; sodium salts; Alcohols; C12-16; ethoxylated(1)

Silicone Polymer(1)

Sodium Xylene Sulfonate(1)

Sodium Hydroxide(1)

Triethanolamine; Ethoxylated Alcohol; Propylene Glycol Butyl Ether; Tetrapotassium Pyrophosphate; Potassium Silicate(1)

Triethylene glycol(1)

Benzyl Alcohol; Diethylene Glycol Monoethyl Ether(1)

152a Difluoroethane(1)

Potassium Hydroxide; Tripropylene Glycol Methyl Ether; Sodium Metasilicate(1)

Sodium Chloride(1)

 
Number of Tabs (Single-Use Packs)

36(1)

40(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved