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

Green Works(6)

Method(5)

Soft Scrub(3)

Ajax(3)

Windex(3)

Simple Green(2)

Pledge(2)

Fantastik(2)

LYSOL Brand(2)

Comet(2)

Formula 409(2)

Diversey(2)

3M(2)

Murphy Oil Soap(1)

Tide Professional(1)

EASY-OFF(1)

Mrs. Meyer's(1)

Mr. Clean(1)

Seventh Generation Professional(1)

 
Special Features

Value Pack-Stock up and save!(8)

Spray every drop with Smart Tube technology.(5)

Powder(1)

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

 
Application

Multipurpose Cleaner(14)

All-Purpose(9)

All-Purpose; Bathrooms; Kitchen(7)

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

All-Purpose Cleaner(3)

General Purpose(2)

Ceramic Tiles; All-Purpose(2)

All Surfaces(2)

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

Nonporous Surfaces(1)

Multiple Surfaces; Electronic Equipment(1)

Degreaser/Cleaner(1)

Glass Counters; Mirrors; Windows; Windshields(1)

All-Purpose; Bathrooms; Kitchens(1)

Floors; Furniture(1)

Scrub Cleanser(1)

Ceramic Tiles; Countertops; Sinks; Toilets(1)

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

Kitchens(1)

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

 
Applicable Material

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

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

Non-Porous Surfaces(3)

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

Ceramic;Chrome;Porcelain(2)

Hard Non-Porous Surfaces(2)

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

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

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

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

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

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

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

Glass;Hard Surfaces(1)

Glass; Plastic; Stainless Steel; Wood(1)

Wood; Glass; Metal(1)

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

Glass; Chrome; Stainless Steel, Laminate(1)

Counters; Floors; Toilets; Walls(1)

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

Wood;Hard Surfaces(1)

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

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

Ceramic; Fiberglass; Plastic; Porcelain(1)

Plastic;Vinyl(1)

Aluminum; Brass; Copper; Stainless Steel(1)

Ceramic;Fiberglass;Plastic;Porcelain(1)

Plastic; Vinyl(1)

 
Dirt Types

Grease; Grime(6)

Dust; Grease; Grime; Soil(6)

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

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

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

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

Grease; Germs; Viruses; Soap Scum(2)

Dust(2)

Dirt; Grease; Oils(2)

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

Grease;Soil(2)

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

Dirt;Grease(1)

Dust;Soil(1)

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

Food; Grease; Soils(1)

Dust; Soil(1)

Dust; Dirt; Smudge; Fingerprint(1)

Dust; Dirt; Grime; Grease(1)

Grime; Mildew; Soap Scum; Stain(1)

Grease; Soil(1)

Organic Matter; Stains; Grease; Grime(1)

Grease;Grime(1)

Grime;Mildew;Soap Scum;Stain(1)

Oil-Based Soil(1)

Grease(1)

Grease;Grime;Soap Scum;Stain(1)

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

Salmonella;Soap Scum;Staph;Germicidal(1)

 
Physical Form

Liquid(45)

Spray(5)

Powder(5)

 
Chemical Compound

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

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

Water Based Non-Ionic Surfactant(2)

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

Hydrogen Peroxide; Citric Acid(2)

Calcite Base(2)

Isopropyl Alcohol, Isobutane(1)

Ammonia(1)

Dipropylene Glycol; Isoparaffinic Solvent; Propylene Glycol(1)

Alkyl Polyglycoside(1)

Natural Ingredients; Plant-Derived Surfactants(1)

Chlorinol(1)

Calcium Carbonate; Sodium Dodecyl Benzene Sulfonate(1)

Phenoxyisopropanal; Lauramine Oxide(1)

Bleach(1)

 
Manufacturer Part Number

01239(1)

00010CT(1)

02287CT(1)

02370(1)

97337(1)

32987CT(1)

00010(1)

00005CT(1)

95019510(1)

94368259(1)

573(1)

573CT(1)

00005(1)

85017(1)

85017CT(1)

697261(1)

696502(1)

697262(1)

11001(1)

11001CT(1)

682274(1)

682269(1)

44723CT(1)

97024(1)

300275(1)

644973(1)

663026(1)

15519CT(1)

15020CT(1)

35419EA(1)

35419CT(1)

40272(1)

41772CT(1)

41772EA(1)

35293EA(1)

35293CT(1)

00457(1)

00456CT(1)

00457CT(1)

00459(1)

00459CT(1)

97301EA(1)

01031(1)

53063(1)

53058(1)

53063CT(1)

53105(1)

01602(1)

53041CT(1)

53041(1)

05253(1)

05252(1)

05374(1)

14278CT(1)

14278EA(1)

00456(1)

 
Country of Origin

US(50)

MX(4)

CA(2)

 
Packing Type

Bottle(29)

Smart Tube Spray Bottle(6)

Spray Bottle(6)

Canister(4)

Aerosol(3)

Trigger Bottle(2)

Trigger Spray Bottle(2)

Refill(2)

Dispenser(1)

Packet(1)

 
Capacity (Volume)

32 oz(12)

1 gal(6)

28 oz(6)

22 oz(5)

144 oz(5)

16 oz(3)

36 oz(2)

15 oz(2)

64 oz(2)

56 oz(2)

21 oz(2)

9.7 oz(1)

128 oz(1)

5 gal(1)

16.9 oz(1)

48 oz(1)

24 oz(1)

1.4 L(1)

1.5 oz(1)

 
Scent

Unscented(10)

Lavender(8)

Original(6)

Lemon(4)

Pleasant(4)

Orange Energy(2)

Lemon Fresh(2)

French Lavender(2)

Pink Grapefruit(2)

Citrus Sparkle Zest(2)

Pine(1)

Rainshower(1)

Clean Citrus Scent(1)

Fresh(1)

Free & Clear/Unscented(1)

Bleach(1)

Citrus(1)

Lavender Clean(1)

Ocean Cool(1)

Fragrance-Free(1)

Hydrocarbon(1)

Lime & Sea Salt(1)

 
Capacity (Weight)

21 oz.(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved