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

Diversey(18)

Method(13)

PAK-IT(13)

Fabuloso(11)

Comet(7)

Bar Keepers Friend(7)

Boardwalk(6)

Pine-Sol(6)

Better Life(6)

Soft Scrub(6)

Clorox(6)

Seventh Generation Professional(5)

Green Works(5)

Windex(5)

Seventh Generation(4)

Fantastik(4)

Mr. Clean(4)

Pledge(4)

Ajax(3)

Mrs. Meyer's(3)

Tide Professional(3)

Murphy Oil Soap(3)

LYSOL Brand(2)

CLR PRO(2)

3M(2)

Kess(2)

Hope's(2)

Simple Green(2)

Theochem Laboratories(2)

EASY-OFF(2)

Misty(1)

PositivEffects(1)

Fresquito(1)

Armor All(1)

Fresh Products(1)

Easy Paks(1)

Lestoil(1)

Formula 409(1)

Zep Commercial(1)

 
Packing Type

Bottle(76)

Spray Bottle(29)

Trigger Bottle(10)

Water-Soluble Liquid Packet(10)

Aerosol(7)

Canister(5)

Packet(4)

Plastic Bottle(3)

Refill(3)

Squeeze Bottle(3)

Can(3)

Tub(3)

Smart Tube Spray Bottle(2)

Snap N Dose(2)

Box(2)

Trigger Spray Bottle(2)

Squirt Bottle(1)

RTD Bottle(1)

Dispenser(1)

 
Manufacturer Part Number

1001583(1)

01454EA(1)

00010(1)

00010CT(1)

01239(1)

01239EA(1)

01452(1)

01452EA(1)

01454(1)

01468CT(1)

00005(1)

01468EA(1)

01743EA(1)

02287CT(1)

02291(1)

02291CT(1)

02363(1)

02364(1)

02370(1)

00005CT(1)

573CT(1)

23124CT(1)

CBD540731(1)

CBD540038(1)

CBD540038EA(1)

CBD540526(1)

CBD540564(1)

CBD540571(1)

CBD540571EA(1)

CBD540670(1)

CBD540731EA(1)

573(1)

12-32-TNCT(1)

32MS6(1)

32PK6(1)

KITCHEN-32EA(1)

KITCHEN32PRO(1)

FORESTFRSH(1)

FRESQUITO-L(1)

PINE-L(1)

23124(1)

32987CT(1)

95891789(1)

682274EA(1)

644973EA(1)

663011(1)

663011EA(1)

663026(1)

682269(1)

682269EA(1)

682274(1)

696502(1)

300275EA(1)

697259(1)

697261(1)

697261EA(1)

697262(1)

11001(1)

11001CT(1)

505917(1)

505919(1)

644973(1)

300275(1)

32987EA(1)

97024(1)

73163(1)

73163EA(1)

91112(1)

97337(1)

97337EA(1)

85017(1)

85017CT(1)

97024EA(1)

44730EA(1)

44713CT(1)

44713EA(1)

44714CT(1)

44714EA(1)

44720CT(1)

44723CT(1)

44723EA(1)

44730CT(1)

990651(1)

95019510(1)

25464(1)

4802(1)

895454002003(1)

895454002034(1)

895454002041(1)

895454002072(1)

895454002102(1)

342ACT(1)

342AEA(1)

4811(1)

12724(1)

4824(1)

4824EA(1)

00456(1)

00456CT(1)

00457(1)

00457CT(1)

03107EA(1)

30613(1)

819524010750(1)

11727(1)

31524EA(1)

5744202240CT(1)

545820003200(1)

547820003200(1)

5478203200CT(1)

555520002240(1)

555520003400(1)

574420002240(1)

574420003400(1)

5744203400CT(1)

11665(1)

578420002240(1)

578420003400(1)

5784202240CT(1)

5784203400CT(1)

11510(1)

11514(1)

11514CT(1)

11624(1)

31524(1)

31525(1)

94995295(1)

15020CT(1)

53058(1)

53063(1)

53063CT(1)

53105(1)

53122(1)

00865(1)

01602(1)

15020EA(1)

53041CT(1)

15519CT(1)

15519EA(1)

04554(1)

100828349(1)

100828353(1)

5549271(1)

94368259(1)

94496138(1)

53043(1)

45944(1)

31525EA(1)

41772CT(1)

31754(1)

31831(1)

33910(1)

35419EA(1)

40187(1)

40238(1)

40272(1)

41772EA(1)

14278EA(1)

01103CT(1)

01103EA(1)

05252(1)

05252EA(1)

05253(1)

05253EA(1)

05374(1)

14278CT(1)

ZUMPP128EA(1)

 
Country of Origin

US(157)

MX(6)

CA(4)

 
Capacity (Volume)

32 oz(39)

1 gal(21)

28 oz(14)

16 oz(11)

175 oz(4)

36 oz(4)

23 oz(4)

22 oz(4)

19 oz(3)

144 oz(3)

64 oz(3)

128 oz(3)

47.3 oz(2)

15 oz(2)

68 oz(2)

20 mL(2)

9.7 oz(2)

24 oz(2)

1.000 gal(2)

56 oz(2)

26 oz(2)

21 oz(2)

16.9 oz(1)

169 oz(1)

48 oz(1)

60 oz(1)

5000 mL(1)

1.4 L(1)

0.500 oz(1)

101 oz(1)

3 L(1)

32 oz; 16 oz; 64 oz(1)

1.66 gal(1)

1.5 oz(1)

25.4 oz(1)

5 gal(1)

 
Scent

Unscented(20)

Lavender(15)

Citrus(14)

Pleasant(14)

Fresh(10)

Lemon(8)

Pine(7)

Free & Clear/Unscented(6)

Original(5)

Fragrance-Free(3)

Light Lavender(2)

French Lavender(2)

Pink Grapefruit(2)

Lime & Sea Salt(2)

Bamboo(2)

Lightly Scented(2)

Wildflower(2)

Grapefruit(2)

Febreze Meadows & Rain(2)

Fresh Pine(2)

Citrus Sparkle Zest(2)

Morning Meadow(2)

Rainshower(2)

Fresh Crisp Pine(2)

Bleach(2)

Clean Citrus Scent(2)

Ocean Cool(2)

Spring(2)

Forest Dew(2)

Orange Energy(2)

Lemon Fresh(2)

Breezy(2)

Fresh Scent(1)

Passion Fruit(1)

Neutral(1)

Sparkling Wave(1)

Hydrocarbon(1)

Fresh Brazilian Blossoms(1)

Citron(1)

Fresh & Clean(1)

Pomegranate Grapefruit(1)

Lavender Chamomile(1)

Clary Sage & Citrus(1)

Free & Clear(1)

Lavender & Chamomile; Unscented(1)

Odorless(1)

 
Dirt Types

Grease; Grime(12)

Dust; Grease; Grime; Soil(9)

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

Lime; Mineral Scale; Rust; Soil; Stains; Grease; Tarnish; Oxidation; Calcium(7)

Dust; Grease; Grime; Oil; Organic Matter; Soil(6)

Grease;Soil(6)

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

Dirt; Grease(5)

Grease; Grime; Germs(4)

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

Dirt; Grease; Oils(4)

Dirt; Grease; Grime(4)

Dust; Grime; Stains; Water Spots(4)

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

Dust; Soil; Tar; Oil; Insect Residue; Bird Feces(3)

Salmonella;Soap Scum;Staph;Germicidal(3)

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

Dust(3)

Dirt; Grime(2)

Organic Waste; Urinary Salts(2)

Grease(2)

Germicidal; Salmonella; Soap Scum; Staph(2)

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

Grease; Germs; Viruses; Soap Scum(2)

Bird Feces; Dust; Insects; Oil; Soil; Tar(2)

Dirt;Grease(2)

Grime;Fingerprint(2)

Dirt; Fingerprints; Grease(2)

Grime;Mildew;Soap Scum;Stain(2)

Dust; Dirt; Smudge; Fingerprint(2)

Fingerprint;Food Stain;Grease;Grime;Soap Scum;Soil(2)

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

Dust;Soil(2)

Dust; Grease; Grime; Oil; Organic Matter; Soil; Protein Stains(2)

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

Food; Grease; Soils(2)

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

Adhesive; Crayon; Daily Soil Build-Up; Food; Grease; Gum; Ink; Marker; Oil; Scuff Marks(2)

Dust; Soil(1)

Dirt; Food; Grease; Grime; Soil; Soap Scum(1)

Dirt; Grease; Grime; Oil(1)

Salmonella; Soap Scum; Staph; Germicidal(1)

Dust; Grime; Odor(1)

Grease;Grime;Soap Scum;Stain(1)

Grease;Fingerprint(1)

Dust; Dirt; Grime; Grease(1)

Oil-Based Soil(1)

Dirt; Dust; Grime(1)

Grime; Dust; Dirt; Fingerprints; Smudges(1)

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

Bacteria; Body Fluids; Fungus; Germs; Grease; Grime; Mildew; Mold; Organic Matter; Soil; Stains(1)

Grease; Soap Scum(1)

Organic Matter; Stains; Grease; Grime(1)

Grease; Soil(1)

Grime; Mildew; Soap Scum; Stain(1)

Dirt; Grease; Grime; Soap Scum(1)

Grease; Scuff Marks; Soap Scum; Spots(1)

Dirt; Grime; Lime; Calcium(1)

Dirt; Grease; Grime; Mineral Scale; Scuff Mark; Soap Scum(1)

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

Soil(1)

Dust, Grime, Soil(1)

Food Stains; Grease; Ink; Oils; Spray Paint(1)

Coffee Stains; Crayon; Dirt; Floor Finish/Sealant; Food; Grease; Hard Water Stains; Lipstick; Pencil Marks; Scuff Marks; Smoke Film; Soap Scum; Tobacco Stains(1)

Soil;Stain(1)

Dust; Dirt; Waterspots; Grime; Grease(1)

Dust; Grease; Grime; Organic Matter; Soil(1)

Dust; Grease; Grime; Organic Materials; Soil(1)

Dirt; Dust; Grime; Mud(1)

 
Capacity (Weight)

5 lbs(3)

21 oz(2)

21 oz.(2)

12 oz(1)

12.57 lbs(1)

3.14 lbs(1)

6.3 lb(1)

3.15 lb(1)

18 lbs.(1)

36 lbs.(1)

 
Chemical Compound

Oxalic Acid(7)

Benzyl Alcohol(7)

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

Ammonia(5)

Water, C-10 Alcohol Ethoxylates; C.I. Acid Yellow 23 (19140); Citric Acid; Dodecylbenzene Sulfonic Acid; Glutaraldehyde; Liquitint Patent Blue Dye; Sodium Bicarbonate Sodium Chloride; Sodium Hydroxide; Sodium Hypochlorite(4)

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

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

Natural Ingredients; Plant-Derived Surfactants(4)

Chlorinol(4)

Citric Acid(4)

Bleach(3)

Alcohol ethoxylates(2)

Phenoxyisopropanal; Lauramine Oxide(2)

Water Based Non-Ionic Surfactant(2)

Alkyl Polyglycoside(2)

Corn-Based Cleaning Salt; Soda Ash(2)

Calcite Base(2)

Sodium Chloride(2)

Hydrogen Peroxide; Citric Acid(2)

Alkyl (C12 40%, C14 50%, C16 10%); Dimethyl Benzyl Ammonium Chloride .3%; Other Ingredients 99.7%(1)

Calcium Carbonate; Sodium Dodecyl Benzene Sulfonate(1)

Sodium Hypochlorite(1)

Citric Acid Solution; Sodium Alphasulfo Methyl C12-18 ester; Sodium Lauryl Sulfate(1)

Alkyl Polyglucoside; Citric Acid; Corn-Based Ethanol; Glycerin(1)

Dipropylene Glycol; Isoparaffinic Solvent; Propylene Glycol(1)

Isopropyl Alcohol, Isobutane(1)

Alkaline(1)

Alcohols; C12-16; Ethoxylated; Ethanol; Ethyl Alcohol; Pine Oil(1)

 
Number of Tabs (Single-Use Packs)

90(2)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved