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

Soft Scrub(3)

Mr. Clean(3)

Comet(3)

Ajax(3)

Diversey(2)

3M(2)

Murphy Oil Soap(2)

Formula 409(2)

LYSOL Brand(2)

Seventh Generation Professional(2)

Pledge(2)

Fantastik(2)

Windex(2)

Simple Green(2)

Lestoil(1)

Tide Professional(1)

EASY-OFF(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(6)

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

Ceramic Tiles; All-Purpose(2)

General Purpose(2)

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)

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

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

Floors; Furniture(1)

All Surfaces(1)

 
Applicable Material

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

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

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

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

Hard Non-Porous Surfaces(3)

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

Non-Porous Surfaces(3)

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

Ceramic;Chrome;Porcelain(2)

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

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

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

Wood; Glass; Metal(1)

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

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

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

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

Glass;Hard Surfaces(1)

Glass; Plastic; Stainless Steel; Wood(1)

Glass; Chrome; Stainless Steel, Laminate(1)

Plastic; Vinyl(1)

Plastic;Vinyl(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)

Dust; Grease; Grime; Soil(6)

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

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

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

Grease;Soil(3)

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

Dirt; Grease; Grime(2)

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

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

Dust(2)

Grease; Germs; Viruses; Soap Scum(2)

Dirt; Grease; Oils(1)

Dust;Soil(1)

Food; Grease; Soils(1)

Dust; Soil(1)

Dust; Dirt; Smudge; Fingerprint(1)

Dirt; Fingerprints; Grease(1)

Dirt;Grease(1)

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

Grease;Grime(1)

Salmonella;Soap Scum;Staph;Germicidal(1)

Salmonella; Soap Scum; Staph; Germicidal(1)

Grease;Grime;Soap Scum;Stain(1)

Dirt; Grease; Grime; Oil; Organic Matter; Smoke Film; Soap Scum(1)

Dust; Dirt; Grime; Grease(1)

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

Oil-Based Soil(1)

Grime;Mildew;Soap Scum;Stain(1)

Grime; Mildew; Soap Scum; Stain(1)

Grease; Soil(1)

Organic Matter; Stains; Grease; Grime(1)

Grease(1)

 
Physical Form

Liquid(51)

Powder(5)

Spray(5)

 
Chemical Compound

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

Calcite Base(2)

Bleach(2)

Hydrogen Peroxide; Citric Acid(2)

Natural Ingredients; Plant-Derived Surfactants(2)

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

Water Based Non-Ionic Surfactant(2)

Calcium Carbonate; Sodium Dodecyl Benzene Sulfonate(1)

Dipropylene Glycol; Isoparaffinic Solvent; Propylene Glycol(1)

Isopropyl Alcohol, Isobutane(1)

Chlorinol(1)

Phenoxyisopropanal; Lauramine Oxide(1)

Alkyl Polyglycoside(1)

Ammonia(1)

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

 
Manufacturer Part Number

00456(1)

32987CT(1)

573(1)

573CT(1)

00005(1)

00005CT(1)

00010(1)

00010CT(1)

01239(1)

02287CT(1)

02291CT(1)

02370(1)

23124(1)

23124CT(1)

97337(1)

94368259(1)

85017(1)

85017CT(1)

97024(1)

44723CT(1)

44730CT(1)

300275(1)

644973(1)

663026(1)

682269(1)

682274(1)

696502(1)

697261(1)

11001(1)

95019510(1)

15519CT(1)

00456CT(1)

97301EA(1)

00457(1)

00457CT(1)

00459(1)

00459CT(1)

33910(1)

35293CT(1)

35293EA(1)

35419CT(1)

35419EA(1)

40238(1)

40272(1)

41772CT(1)

41772EA(1)

01031(1)

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

11001CT(1)

 
Country of Origin

US(56)

MX(4)

CA(2)

 
Packing Type

Bottle(34)

Smart Tube Spray Bottle(6)

Spray Bottle(6)

Canister(4)

Aerosol(3)

Trigger Bottle(3)

Refill(2)

Trigger Spray Bottle(2)

Packet(1)

Dispenser(1)

 
Capacity (Volume)

32 oz(13)

1 gal(10)

28 oz(7)

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

Lavender(8)

Original(6)

Lemon(4)

Pleasant(3)

Fresh(3)

Pink Grapefruit(2)

Orange Energy(2)

Free & Clear/Unscented(2)

Citrus Sparkle Zest(2)

Pine(2)

Febreze Meadows & Rain(2)

Lemon Fresh(2)

French Lavender(2)

Clean Citrus Scent(1)

Rainshower(1)

Sparkling Wave(1)

Lime & Sea Salt(1)

Bleach(1)

Fragrance-Free(1)

Ocean Cool(1)

Citrus(1)

Lavender Clean(1)

Hydrocarbon(1)

 
Capacity (Weight)

21 oz.(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved