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

Pine-Sol(8)

Fabuloso(8)

Green Works(6)

Method(5)

Comet(4)

Ajax(3)

Soft Scrub(3)

Windex(3)

Diversey(3)

Seventh Generation Professional(3)

Pledge(2)

LYSOL Brand(2)

Mr. Clean(2)

Formula 409(2)

Murphy Oil Soap(2)

3M(2)

Simple Green(2)

Tide Professional(1)

LYSOL Brand II(1)

EASY-OFF(1)

Mrs. Meyer's(1)

Suma(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)

Value Pack(1)

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

Powder(1)

 
Application

Multipurpose Cleaner(16)

All-Purpose(8)

All-Purpose; Bathrooms; Kitchen(7)

All-Purpose Cleaner(6)

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

Disinfectant/Cleaner(3)

All Surfaces(2)

Ceramic Tiles; All-Purpose(2)

Scrub Cleanser(1)

Nonporous Surfaces(1)

Multiple Surfaces; Electronic Equipment(1)

Kitchens; Bathrooms; Hard Surfaces(1)

Degreaser/Cleaner(1)

Floors(1)

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

All-Purpose; Bathrooms; Kitchens(1)

Ceramic Tiles; Countertops; Sinks; Toilets(1)

Cabinets; Desktops; Painted Surfaces; Vinyl Binders(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)

All Washable Surfaces(1)

 
Applicable Material

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

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;Porcelain(2)

Hard, Non-Porous Surfaces(2)

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

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

Glass;Hard Surfaces(1)

Glass; Plastic; Stainless Steel; Wood(1)

Aluminum; Glass; Granite; Marble; Plastic; Stainless Steel(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; Finished/Sealed Wood; Laminates; Metal; Plastic; Sealed/Engineered Stone; Vinyl(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

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

Grease; Grime(6)

Dust; Grease; Grime; Soil(6)

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

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

Grease;Soil(3)

Dirt; Grease; Grime(2)

Dirt; Grease; Oils(2)

Grease; Germs; Viruses; Soap Scum(2)

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

Dust(2)

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

Soap Scum; Stains(1)

Dust;Soil(1)

Food; Grease; Soils(1)

Dust; Soil(1)

Dust; Dirt; Smudge; Fingerprint(1)

Dirt; Fingerprints; Grease(1)

Dirt;Grease(1)

Dirt; Grease(1)

Grease; Soil(1)

Bacteria; Dust; Germs; Grease; Grime; Oil-Based Soil; Organic Matter; Smoke Film; Soap Scum; Water-Based Soil(1)

Grime; Mildew; Soap Scum; Stain(1)

Grime;Mildew;Soap Scum;Stain(1)

Grease(1)

Organic Matter; Stains; Grease; Grime(1)

Salmonella;Soap Scum;Staph;Germicidal(1)

Grease;Grime;Soap Scum;Stain(1)

Grease;Grime(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)

Salmonella; Soap Scum; Staph; Germicidal(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)

Hydrogen Peroxide; Citric Acid(2)

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

Natural Ingredients; Plant-Derived Surfactants(2)

Calcite Base(2)

Ammonia(1)

Alkyl Polyglycoside(1)

Phenoxyisopropanal; Lauramine Oxide(1)

Calcium Carbonate; Sodium Dodecyl Benzene Sulfonate(1)

Dipropylene Glycol Monobutyl Ether; Alkyl (50%C14, 40%C12, 10%C16) Dimethyl Benzyl Ammonium Chlorides(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)

23124CT(1)

CBD540571(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)

32987CT(1)

95019510(1)

75352(1)

85017(1)

85017CT(1)

97024(1)

44720CT(1)

44723CT(1)

44730CT(1)

300275(1)

644973(1)

663026(1)

696502(1)

697259(1)

697261(1)

11001(1)

95891789(1)

94368259(1)

00456CT(1)

97301EA(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)

97301(1)

01031(1)

15519CT(1)

01103CT(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)

11001CT(1)

 
Country of Origin

US(58)

MX(4)

CA(3)

 
Packing Type

Bottle(35)

Spray Bottle(7)

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(11)

144 oz(6)

28 oz(6)

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(3)

Free & Clear/Unscented(2)

Citrus Sparkle Zest(2)

Febreze Meadows & Rain(2)

Pink Grapefruit(2)

French Lavender(2)

Pleasant(2)

Citrus(2)

Lavender Clean(2)

Orange Energy(2)

Lemon Fresh(2)

Fragrance-Free(1)

Bleach(1)

Ocean Cool(1)

Fresh Pine(1)

Lime & Sea Salt(1)

Pine(1)

Lemon Breeze(1)

Sparkling Wave(1)

Free & Clear(1)

Rainshower(1)

Clean Citrus Scent(1)

Hydrocarbon(1)

 
Capacity (Weight)

21 oz(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved