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

Currently Filtered by

Category

All Purpose Cleaners And Degreasers

Refine Search

  GO
 
Brand

Fabuloso(8)

Pine-Sol(7)

Green Works(6)

Method(5)

Comet(4)

Ajax(3)

Soft Scrub(3)

Seventh Generation Professional(3)

Mr. Clean(3)

Diversey(3)

3M(2)

Murphy Oil Soap(2)

Formula 409(2)

LYSOL Brand(2)

Pledge(2)

Fantastik(2)

Windex(2)

Simple Green(2)

Tide Professional(1)

EASY-OFF(1)

Suma(1)

Mrs. Meyer's(1)

 
Special Features

Value Pack-Stock up and save!(9)

Spray every drop with Smart Tube technology.(5)

Value Pack-Stock up and save! Spray every drop with Smart Tube technology.(1)

Concentrate-Makes 64 gallons of ready-to-use solution.(1)

Powder(1)

 
Application

Multipurpose Cleaner(15)

All-Purpose(10)

All-Purpose; Bathrooms; Kitchen(7)

All-Purpose Cleaner(7)

Bathrooms; Kitchens; Hard Non-Porous Surfaces; General Purpose(5)

Ceramic Tiles; All-Purpose(2)

General Purpose(2)

Cabinets; Desktops; Painted Surfaces; Vinyl Binders(1)

Nonporous Surfaces(1)

Multiple Surfaces; Electronic Equipment(1)

Kitchens; Bathrooms; Hard Surfaces(1)

Degreaser/Cleaner(1)

Concrete; Quarry Tile; Walls; Pots and Pans; Mop Heads; Exhaust Hoods; Dumpsters; Trash Containers(1)

All Washable Surfaces(1)

Desktops; Bookcases; Painted Surfaces; File Cabinets(1)

Floors; Furniture(1)

Bathrooms; Floors; Hospitals; Kitchens; Walls(1)

Glass Counters; Mirrors; Windows; Windshields(1)

Kitchens(1)

Ceramic Tiles; Countertops; Sinks; Toilets(1)

Scrub Cleanser(1)

All-Purpose; Bathrooms; Kitchens(1)

Floors(1)

All Surfaces(1)

 
Applicable Material

Ceramic; Fiberglass; Glass; Laminates; Metal; Plastic; Sealed Cement; Sealed Stone; Vinyl(6)

Ceramic; Fiberglass; Glass; Metal; Plastic; Vinyl; Hard Surfaces(6)

Glass; Marble; Metal; Tile; Sealed Stone; Wood(5)

Ceramic; Fiberglass; Glass; Laminates; Metal; Plastic; Sealed Cement; Sealed Stone; Vinyl; Wood(4)

Ceramic; Fiberglass; Plastic; Porcelain; Stainless Steel; Tile(3)

Ceramic;Fiberglass;Plastic;Porcelain;Stainless Steel;Tile(3)

Non-Porous Surfaces(3)

Ceramic; Chrome; Fabric; Fiberglass; Metal; Porcelain; Plastic; Stainless Steel; Wood(2)

Ceramic;Chrome;Porcelain(2)

Hard, Non-Porous Surfaces(2)

Fiberglass; Glass; Laminates; Polished Metal; Sealed Stone(2)

Fiberglass; Glass; Laminates; Metal; Plastic; Sealed Stone(2)

Glass; Plastic; Stainless Steel; Wood(1)

Glass;Hard Surfaces(1)

Glass; Stainless Steel; Chrome; Windows; Mirrors; Hard Surfaces(1)

Hard, Non-Porous Surfaces; Painted Surfaces; Plastics; Vinyl(1)

Hard Surfaces(1)

Stoves; Counters; Oven Doors; Microwaves; Backsplashes; Sinks(1)

Ceramics; Enamel; Fiberglass; Glass; Grout; Laminates; Metal; Plaster; Plastic; Vinyl; Porcelain; Stainless Steel; Tile(1)

Wood; Glass; Metal(1)

Chrome; Glass; Stainless Steel(1)

Plastic; Vinyl(1)

Plastic;Vinyl(1)

Hard Non-Porous Surfaces (not for use on glass, aluminum or water-based paint)(1)

Glass; Chrome; Stainless Steel, Laminate(1)

Aluminum; Brass; Copper; Stainless Steel(1)

Ceramic;Fiberglass;Plastic;Porcelain(1)

Ceramic; Fiberglass; Plastic; Porcelain(1)

Carpet; Drywall; Linoleum; Plastic; Acrylic(1)

Counters; Floors; Toilets; Walls(1)

Metal; Plastic; Porcelain; Ceramic; Vinyl(1)

Wood(1)

Wood;Hard Surfaces(1)

Ceramic; Fiberglass; Glass; Laminates; Metal; Plastic; Polished Stone; Vinyl; Wood(1)

Aluminum; Chrome; Glass; Granite; Marble; Mirrors; Plastic; Stainless Steel(1)

 
Dirt Types

Grease; Grime(6)

Bacteria; Dust; Germs; Grease; Grime; Mildew; Oil; Soil(6)

Dust; Grease; Grime; Soil(6)

Dust; Grease; Grime; Oil; Soil(4)

Dust; Grease; Grime; Oil; Smoke Residue; Soil(4)

Grease;Soil(3)

Crayon; Fingerprints; Grease; Grime; Oil; Organic Matter; Pencil; Smoke Film(2)

Grease; Germs; Viruses; Soap Scum(2)

Dirt; Grease; Grime(2)

Dirt; Grime; Dust; Oil-Based Soil(2)

Bactericidal;Mildew;Mold;Fungicidal;Virucidal(2)

Dust(2)

Bacteria; Mildew; Mold; Dust; Germs; Grease; Grime; Water-Based Soil(1)

Dirt; Grease; Oils(1)

Dust;Soil(1)

Grease;Grime(1)

Food; Grease; Soils(1)

Dust; Soil(1)

Dust; Dirt; Smudge; Fingerprint(1)

Dirt; Fingerprints; Grease(1)

Dirt;Grease(1)

Dirt; Grease(1)

Organic Matter; Stains; Grease; Grime(1)

Soap Scum; Stains(1)

Grime;Mildew;Soap Scum;Stain(1)

Grease(1)

Salmonella; Soap Scum; Staph; Germicidal(1)

Salmonella;Soap Scum;Staph;Germicidal(1)

Grease; Soil(1)

Grime; Mildew; Soap Scum; Stain(1)

Dust; Dirt; Grime; Grease(1)

Coffee and Tobacco Stains; Dirt; Floorwax; Food Stains; Grease; Hard Water Stains; Lipstick; Scuff Marks; Smoke Film; Soap Film(1)

Dirt; Grease; Grime; Oil; Organic Matter; Stains(1)

Dust; Fingerprint; Grease; Grime; Water Mark(1)

Oil-Based Soil(1)

Grease;Grime;Soap Scum;Stain(1)

 
Physical Form

Liquid(54)

Powder(5)

Spray(5)

 
Chemical Compound

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

Bleach(3)

Water Based Non-Ionic Surfactant(2)

Natural Ingredients; Plant-Derived Surfactants(2)

D-glucopyranoside, C9-11 alkyl, oligomer(2)

Calcite Base(2)

Hydrogen Peroxide; Citric Acid(2)

2-Hexoxyethanol; Isopropanolamine; Lauramine Oxide; Sodium Dodecylbenzene Sulfonate(1)

Ammonia(1)

Alkyl Polyglycoside(1)

Calcium Carbonate; Sodium Dodecyl Benzene Sulfonate(1)

Phenoxyisopropanal; Lauramine Oxide(1)

Isopropyl Alcohol, Isobutane(1)

Benzyl Alcohol(1)

Alcohol Ethoxylates(1)

Dipropylene Glycol; Isoparaffinic Solvent; Propylene Glycol(1)

Chlorinol(1)

 
Manufacturer Part Number

00456(1)

32987CT(1)

573(1)

573CT(1)

00005(1)

00005CT(1)

00010(1)

00010CT(1)

01239(1)

02287CT(1)

02291(1)

02291CT(1)

02370(1)

23124(1)

23124CT(1)

97337(1)

95891789(1)

85017(1)

85017CT(1)

97024(1)

44720CT(1)

44723CT(1)

44730CT(1)

300275(1)

644973(1)

663026(1)

682269(1)

682274(1)

696502(1)

697261(1)

11001(1)

CBD540571(1)

95019510(1)

00456CT(1)

01031(1)

00457(1)

00457CT(1)

00459(1)

00459CT(1)

35293CT(1)

35293EA(1)

35419CT(1)

35419EA(1)

40238(1)

40272(1)

41772CT(1)

41772EA(1)

97301EA(1)

01103CT(1)

94368259(1)

05252(1)

05253(1)

05374(1)

14278CT(1)

14278EA(1)

53041(1)

53041CT(1)

53058(1)

53063(1)

53063CT(1)

53105(1)

01602(1)

15020CT(1)

15519CT(1)

11001CT(1)

 
Country of Origin

US(58)

MX(4)

CA(3)

 
Packing Type

Bottle(34)

Spray Bottle(8)

Smart Tube Spray Bottle(6)

Canister(4)

Aerosol(3)

Trigger Bottle(3)

Refill(2)

Trigger Spray Bottle(2)

Packet(1)

Dispenser(1)

Capped Bottle with Trigger(1)

 
Capacity (Volume)

32 oz(15)

1 gal(12)

28 oz(6)

144 oz(5)

22 oz(5)

16 oz(3)

36 oz(2)

15 oz(2)

56 oz(2)

64 oz(2)

21 oz(2)

16.9 oz(1)

24 oz(1)

1.4 L(1)

48 oz(1)

1.5 oz(1)

60 oz(1)

9.7 oz(1)

5 gal(1)

 
Scent

Unscented(11)

Lavender(8)

Original(6)

Fresh(4)

Lemon(4)

Pleasant(3)

Pink Grapefruit(2)

Febreze Meadows & Rain(2)

Orange Energy(2)

Free & Clear/Unscented(2)

Lemon Fresh(2)

Citrus Sparkle Zest(2)

French Lavender(2)

Citrus(2)

Clean Citrus Scent(1)

Rainshower(1)

Free & Clear(1)

Pine(1)

Lavender Clean(1)

Lime & Sea Salt(1)

Fresh Pine(1)

Bleach(1)

Sparkling Wave(1)

Fragrance-Free(1)

Ocean Cool(1)

Hydrocarbon(1)

 
Capacity (Weight)

21 oz(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved