Banner1 Banner1
 
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

Diversey(19)

PAK-IT(13)

Method(13)

Fabuloso(13)

Pine-Sol(9)

Bar Keepers Friend(7)

Green Works(7)

Comet(7)

Mr. Clean(6)

Soft Scrub(6)

Better Life(6)

Boardwalk(6)

Clorox(6)

Windex(5)

Seventh Generation Professional(5)

Seventh Generation(4)

Formula 409(4)

Fantastik(4)

Mrs. Meyer's(4)

Pledge(4)

Murphy Oil Soap(4)

Tide Professional(3)

Ajax(3)

Simple Green(2)

EASY-OFF(2)

Theochem Laboratories(2)

Misty(2)

Kess(2)

LYSOL Brand(2)

3M(2)

CLR PRO(2)

Hope's(2)

PositivEffects(1)

LYSOL Brand II(1)

Fresquito(1)

Armor All(1)

Fresh Products(1)

Easy Paks(1)

Lestoil(1)

Zep Commercial(1)

 
Height

2 2/5"(2)

 
Color(s)

White/Blue(2)

 
Packing Type

Bottle(81)

Spray Bottle(32)

Trigger Bottle(10)

Water-Soluble Liquid Packet(10)

Aerosol(8)

Smart Tube Spray Bottle(6)

Canister(5)

Packet(4)

Refill(4)

Squeeze Bottle(3)

Can(3)

Plastic Bottle(3)

Tub(3)

Snap N Dose(2)

Box(2)

Trigger Spray Bottle(2)

Squirt Bottle(1)

RTD Bottle(1)

Container(1)

Dispenser(1)

 
Manufacturer Part Number

1001583(1)

01454(1)

00005(1)

00005CT(1)

00010(1)

00010CT(1)

01239(1)

01239EA(1)

01452(1)

01452EA(1)

01454EA(1)

573(1)

01468CT(1)

01468EA(1)

01743EA(1)

02287CT(1)

02291(1)

02291CT(1)

02363(1)

02364(1)

02370(1)

573CT(1)

PINE-L(1)

23124CT(1)

CBD540571(1)

95019510(1)

95891789(1)

990651(1)

CBD539674(1)

CBD540038(1)

CBD540038EA(1)

CBD540526(1)

CBD540564(1)

CBD540571EA(1)

FRESQUITO-L(1)

CBD540670(1)

CBD540731(1)

CBD540731EA(1)

12-32-TNCT(1)

32MS6(1)

32PK6(1)

KITCHEN-32EA(1)

KITCHEN32PRO(1)

FORESTFRSH(1)

23124(1)

32987CT(1)

94496138(1)

682274(1)

644973(1)

644973EA(1)

663011(1)

663011EA(1)

663026(1)

663026EA(1)

682269(1)

682269EA(1)

682274EA(1)

300275(1)

696502(1)

697259(1)

697261(1)

697261EA(1)

697262(1)

11001(1)

11001CT(1)

505917(1)

505919(1)

300275EA(1)

44730EA(1)

32987EA(1)

85017CT(1)

47546(1)

47546CT(1)

73163(1)

73163EA(1)

91112(1)

97337(1)

97337EA(1)

85017(1)

97024(1)

44730CT(1)

97024EA(1)

98769(1)

44713CT(1)

44713EA(1)

44714CT(1)

44714EA(1)

44720CT(1)

44723CT(1)

44723EA(1)

94995295(1)

94368259(1)

1001592(1)

4824(1)

895454002034(1)

895454002041(1)

895454002072(1)

895454002102(1)

342ACT(1)

342AEA(1)

4802(1)

4811(1)

4824EA(1)

819524010750(1)

00456(1)

00456CT(1)

00457(1)

00457CT(1)

00459(1)

00459CT(1)

03107CT(1)

03107EA(1)

30613(1)

895454002003(1)

12724(1)

31524EA(1)

5744202240CT(1)

25464(1)

545820003200(1)

547820003200(1)

5478203200CT(1)

555520002240(1)

555520003400(1)

574420002240(1)

574420003400(1)

5744203400CT(1)

11727(1)

578420002240(1)

578420003400(1)

5784202240CT(1)

5784203400CT(1)

11510(1)

11514(1)

11514CT(1)

11624(1)

11665(1)

31524(1)

31525(1)

5549271(1)

53122(1)

45944(1)

53041(1)

53041CT(1)

53043(1)

53058(1)

53063(1)

53063CT(1)

53105(1)

53122EA(1)

14278CT(1)

00865(1)

01602(1)

15020CT(1)

15020EA(1)

15519CT(1)

15519EA(1)

04554(1)

100828349(1)

100828353(1)

14278EA(1)

05374(1)

31525EA(1)

40272(1)

31754(1)

31831(1)

33910(1)

35293CT(1)

35293EA(1)

35419CT(1)

35419EA(1)

40187(1)

40238(1)

41772CT(1)

05253EA(1)

41772EA(1)

97301(1)

97301EA(1)

01031(1)

01103CT(1)

01103EA(1)

05252(1)

05252EA(1)

05253(1)

ZUMPP128EA(1)

 
Country of Origin

US(173)

MX(7)

CA(4)

 
Width

3 9/10"(2)

 
Material(s)

Foam(2)

 
Shape

Wavy Rectangle(2)

 
Capacity (Volume)

32 oz(45)

1 gal(21)

28 oz(14)

16 oz(12)

144 oz(6)

22 oz(5)

128 oz(4)

23 oz(4)

36 oz(4)

175 oz(4)

56 oz(3)

19 oz(3)

64 oz(3)

26 oz(2)

9.7 oz(2)

68 oz(2)

15 oz(2)

21 oz(2)

1.000 gal(2)

47.3 oz(2)

169 oz(2)

24 oz(2)

20 mL(2)

1.4 L(1)

1.5 oz(1)

0.500 oz(1)

3 L(1)

5000 mL(1)

101 oz(1)

16.9 oz(1)

25.4 oz(1)

19 oz.(1)

48 oz(1)

60 oz(1)

1.66 gal(1)

32 oz; 16 oz; 64 oz(1)

5 gal(1)

 
Scent

Unscented(23)

Lavender(17)

Citrus(15)

Pleasant(14)

Fresh(11)

Lemon(9)

Pine(7)

Original(7)

Free & Clear/Unscented(6)

Fragrance-Free(3)

Lemon Fresh(3)

Clean Citrus Scent(2)

Lightly Scented(2)

Pink Grapefruit(2)

French Lavender(2)

Light Lavender(2)

Wildflower(2)

Grapefruit(2)

Fresh Crisp Pine(2)

Fresh Pine(2)

Febreze Meadows & Rain(2)

Bleach(2)

Ocean Cool(2)

Citrus Sparkle Zest(2)

Bamboo(2)

Lavender Clean(2)

Orange Energy(2)

Morning Meadow(2)

Forest Dew(2)

Spring(2)

Breezy(2)

Rainshower(2)

Lime & Sea Salt(2)

Mango & Hibiscus(1)

Citron(1)

Free & Clear(1)

Clary Sage & Citrus(1)

Neutral(1)

Fresh & Clean(1)

Lavender Chamomile(1)

Hydrocarbon(1)

Mint(1)

Passion Fruit(1)

Fresh Scent(1)

Sparkling Wave(1)

Fresh Brazilian Blossoms(1)

Lavender & Chamomile; Unscented(1)

Pomegranate Grapefruit(1)

Odorless(1)

 
Dirt Types

Grease; Grime(12)

Dust; Grease; Grime; Soil(11)

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

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

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

Grease;Soil(6)

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

Dirt; Grease; Grime(5)

Dirt; Grease(5)

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

Dirt; Grease; Oils(4)

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

Dust; Grime; Stains; Water Spots(4)

Grease; Grime; Germs(4)

Salmonella;Soap Scum;Staph;Germicidal(3)

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

Dust(3)

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

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

Dirt;Grease(2)

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

Grease; Germs; Viruses; Soap Scum(2)

Organic Waste; Urinary Salts(2)

Grease(2)

Germicidal; Salmonella; Soap Scum; Staph(2)

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

Grime;Mildew;Soap Scum;Stain(2)

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

Dirt; Fingerprints; Grease(2)

Food; Grease; Soils(2)

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

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

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

Grime;Fingerprint(2)

Dust; Dirt; Smudge; Fingerprint(2)

Dirt; Grime(2)

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

Dust;Soil(2)

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

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

Dirt; Grease; Grime; Oil(1)

Bacteria; Dust; Germs; Grease; Grime; Viruses(1)

Dust; Soil(1)

Salmonella; Soap Scum; Staph; Germicidal(1)

Grease;Grime;Soap Scum;Stain(1)

Dust; Grime; Odor(1)

Grease;Fingerprint(1)

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

Dust; Dirt; Grime; Grease(1)

Oil-Based Soil(1)

Dust, Grime, Soil(1)

Dirt; Dust; Grime(1)

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

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

Grease; Soap Scum(1)

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

Dirt;Grease;Grime;Oil;Organic Matter;Smoke Film;Soap Scum(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)

 
Thickness

1"(2)

 
Chemical Compound

Oxalic Acid(7)

Benzyl Alcohol(7)

Ammonia(6)

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

Chlorinol(4)

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

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

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)

Natural Ingredients; Plant-Derived Surfactants(4)

Citric Acid(4)

Bleach(3)

Corn-Based Cleaning Salt; Soda Ash(2)

Water Based Non-Ionic Surfactant(2)

Calcite Base(2)

Alcohol ethoxylates(2)

Sodium Chloride(2)

Alkyl Polyglycoside(2)

Phenoxyisopropanal; Lauramine Oxide(2)

Hydrogen Peroxide; Citric Acid(2)

Alkyl (67% C12, 25% C14, 7% C16, 1% C8-C10-C18) Dimethyl Benzyl Ammonium Chlorides; n-Alkyl (C14 50%, C12 40%, C16 10%) Dimethyl Benzyl Ammonium Chloride(1)

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

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

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

Sodium Hypochlorite(1)

Isopropyl Alcohol, Isobutane(1)

Alkaline(1)

Diethylene Glycol Monoethyl Ether(1)

Dipropylene Glycol; Isoparaffinic Solvent; Propylene Glycol(1)

Calcium Carbonate; Sodium Dodecyl Benzene Sulfonate(1)

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

 
Duty Rating

Medium/Heavy(2)

 
Number of Tabs (Single-Use Packs)

90(2)

 
Sponge Type

Scrub Sponge(2)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved