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','spl_call_for_price') 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(16)

Diversey(9)

Boardwalk(9)

EASY-OFF(7)

Spray Nine(7)

Professional EASY-OFF(6)

Zep Commercial(5)

WEIMAN(5)

Misty(4)

Formula 409(4)

BREAK-UP(3)

Armor All(3)

AbilityOne(2)

LYSOL Brand(2)

Kess(2)

Scotch-Brite PROFESSIONAL(2)

Claire(2)

Zep Professional(2)

Method(1)

Falcon Safety Products(1)

Endust for Electronics(1)

Suma(1)

Theochem Laboratories(1)

Chase Products(1)

 
Recycled

No(1)

 
Packaged Quantity

2 / Carton(1)

 
Assembly Required

No(1)

 
Application

Degreaser/Cleaner(54)

Oven and Grill Cleaner(7)

Bathrooms; Breakrooms; Kitchens; Offices; Manufacturing Plants; Appliances; Equipment; Automotive; Medical Offices & Exam Rooms; Hospitals/Healthcare; Veterinary Medicine; Machinery/ Tools(6)

Leather/Rubber/Vinyl Treatment(4)

Oven & Grill Cleaner(4)

Electronics/Antistatic Cleaner(3)

Countertops(3)

All-Purpose(3)

Electric Ranges(2)

Countertops; Painted Surfaces; Tile(1)

Rust/Hard Water Stain Remover(1)

All Washable Surfaces(1)

Liquid Oven and Grill Cleaner(1)

Contact Cleaner(1)

Ovens; Stoves(1)

Walls(1)

Cleaner/Degreaser(1)

Appliances; Grills; Stovetops; Tools; Engines; Kitchen Surfaces(1)

 
Recommended Use

Grease Remover(1)

Petroleum Remover(1)

Tire Mark(1)

Food Soil Remover(1)

Dirt Remover(1)

Grime Remover(1)

Stain Remover(1)

Ink Remover(1)

Graffiti Remover(1)

Heel Mark Remover(1)

Paint Remover(1)

Marker Remover(1)

 
Applicable Material

Barbecue Grills; Grills; Ovens(9)

Carpet; Ceramics; Cement/Concrete; Enamel; Fabric; Fiberglass; Laminates; Metal; Plastic; Upholstery(8)

Tables; Walls; Floors; Countertops; Exterior Surfaces of Refrigerators; Tubs; Showers; Glazed Tile; Toilet Exteriors; Garbage Pails(6)

Metal(5)

Ceramics; Enamel; Metal(4)

Ceramics; Cement/Concrete; Enamel; Fiberglass; Laminates; Metal; Plastic(4)

Ceramic; Fiberglass; Glass; Laminates; Metal; Plastic(4)

Ceramics; Fiberglass; Glass; Laminates; Metal; Plastic(3)

Hard Surfaces(3)

Ceramics; Enamel; Glass; Metal; Plastic(2)

Ceramic; Glass(2)

Granite; Marble; Quartz; Onyx; Travertine; Limestone; Slate; Laminate; Porcelain; Ceramic; Tile; Fiberglass; Non-Porous Hard, Sealed Surfaces(2)

Enamel; Fiberglass; Metal; Plastic; Rubber(2)

ABS Polypropylene; Acrylic; Cast Iron; Ceramic; Chrome; Concrete; Enamel; Fiberglass; Formica; Glass; HDPE; Polished Marble; Porcelain; PVC; Stainless Steel(2)

Appliance Exteriors; Cabinets; Counters; Sinks; Stovetops(2)

Ceramics; Cement/Concrete; Enamel; Fiberglass; Laminates; Metal; Plastic; Vinyl(2)

Ceramics; Enamel; Glass; Metal(2)

Laminates; Leather; Plastic; Rubber; Vinyl(2)

Aluminum; Brass; Chrome; Copper; Glass; Glazed Porcelain; Mirrors; Painted Surfaces; Plastic; Stainless Steel(2)

Hard Surfaces; Kitchen Surfaces Floors; Counters; Walls(1)

Chrome; Fiberglass; Formica; Linoleum; Porcelain(1)

Aluminum; Fiberglass; Metal; Plastic; Stainless Steel(1)

Aluminium; Concrete; Fiberglass; Stainless Steel(1)

Fiberglass; Porcelain; Stainless Steel; Tile(1)

Porcelain; Stainless Steel; Tile; Walls(1)

Ceramics; Enamel; Fiberglass; Laminates; Metal; Plastic; Finished/Sealed Wood(1)

Leather(1)

Ceramic; Fabric(1)

Hard, Non-Porous Surfaces(1)

Ceramic; Laminate; Metal; Plastic; Rubber(1)

Plastic; Rubber; Vinyl(1)

Counters; Tables; Refrigerators; Concrete and Ceramic Floors; Grinders; Hoods; Grills; Engines; Machinery and Tools(1)

Ceramic; Enamel; Fiberglass; Glass; Laminates; Metal; Plastic(1)

Cast Iron; Ceramic; Porcelain; Stainless Steel(1)

Grills; Griddles: Grills; Ovens(1)

Cast Iron; Ceramics; Glass; Porcelain; Stainless Steel(1)

Multi-Surface(1)

Granite; Marble; Stone(1)

Cabinets; Concrete; Counters; Floors; Walls(1)

Asphalt; Ceramics; Cement/Concrete; Conveyors; Enamel; Engines; Fiberglass; Grills; Industrial & Farm Equipment; Laminates; Machinery; Metal; Mowers; Ovens; Plaster; Plastic; Rubber; RVs; Tools; Trailers; Trunks; Vents; Vinyl(1)

Metal; Plastic; Rubber(1)

Hard Non-Porous Surfaces(1)

Metal; Stainless Steel(1)

Multi Surface(1)

All Washable Surfaces(1)

Kitchen Surfaces(1)

Steel(1)

 
Dirt Types

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

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

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

Carbon; Food Debris; Grease; Grime; Oil-Based Soil; Organic Matter(5)

Grease; Grime(5)

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

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

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

Food(2)

Grease; Grime; Surface Stains(2)

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

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

Dust(2)

Coffee; Grease; Ink; Oil(2)

Dust; Grease; Grime(2)

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

Rust Stains(1)

Dirt; Grease(1)

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

Fingerprints; Grease; Grime; Oil(1)

Dirt; Grease; Grime(1)

Dirt; Grease; Lubricants; Oil(1)

Debris; Dirt; Dust(1)

Dirt; Residue; Soil(1)

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

Grease; Oil; Dirt; Dust(1)

Food-Based Soils; Grease Stains; Oils(1)

Grease; Fat; Oil(1)

Dirt; Grease; Mildew Stains; Soap Scum; Wax(1)

Baked-on Foods; Carbon; Grease(1)

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

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

Grease; Fats; Carbonized Soil(1)

Caked-On Foods; Grease; Other Cooking Soils(1)

Food Stains; Grease; Oil(1)

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

 
Physical Form

Liquid(89)

Foam(5)

Spray(1)

 
Volume Capacity

1 gal(20)

32 oz(15)

24 oz(10)

20 oz(7)

14.5 oz(5)

22 oz(5)

128 oz(5)

19 oz(4)

5 gal(3)

55 gal(3)

28 oz(3)

1 qt(2)

8 oz(2)

18 oz(2)

3 L(2)

5 L(1)

16 oz(1)

2 oz(1)

3.78 L(1)

3.2 oz(1)

64 oz(1)

1500 mL(1)

 
Cleaner Type

Ready-To-Use(1)

 
Chemical Compound

Water based non-ionic surfactant(10)

Diethylene Glycol Monobutyl Ether(7)

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

Water Based Non-Ionic Surfactant(4)

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

Diethylene Glycol Monobutyl Ether; Potassium Carbonate(2)

Monoethanolamine ICF Grade, Sodium Hydorixde, Laurldimethamine Oxide(1)

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

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

Alcohols; C9-11; Ethoxylated(1)

Tetrasodium Ethylenediaminetetraacetate(1)

Glycollic Acid; Oxalic Acid; Phosphoric Acid(1)

Ethoxylated Alcohol(1)

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

Alcohols, C9-11 Ethoxylated(1)

Monoethanolamine ICF Grade; Sodium Hydorixde; Laurldimethamine Oxide(1)

C9-11 Alcohols Ethoxylate; Sodium Carbonate(1)

Sodium Hydroxide; Butane; Diethylene Glycol Monobutyl Ether; Propane(1)

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

Surfactants; Tetrapotassium Pyrophosphate; Sodium Citrate; Fragrance; Green Dye(1)

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

Sodium Hydroxide(1)

Cocamidopropyl Betaine; Amine; Coco Alkyldimethyl; N-Oxide; Alkyl Poly Glycoside; Sodium Chloride(1)

Sodium Xylene Sulfonate; Sodium Silicate; Sodium Hydroxide; Alanine, N,N-bis(Carboxymethyl); Trisodium Salt(1)

Benzyl Alcohol; Diethylene Glycol Monoethyl Ether(1)

Diethylene Glycol Monobutyl Ether; Sodium Hydroxide; Propate; Butane(1)

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

 
Cleaner Volume

169.1 fl oz (5.3 quart)(1)

 
Cleaner Form

Spray(1)

Liquid(1)

 
Country of Origin

US(88)

CA(6)

GB(1)

Canada(1)

 
Scent

Unscented(43)

Citrus(13)

Lemon(7)

Sassafras(6)

Fresh(4)

Original(2)

Apple(2)

Fresh Pine(1)

Surfactant(1)

Pine(1)

Apple Orchard(1)

Acidic(1)

Floral(1)

Slight(1)

Pleasant(1)

 
Container Type

Bottle(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander