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 ('40030')) 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 '%StainlessSteelCleaners' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('StainlessSteelCleaners' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+StainlessSteelCleaners' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"StainlessSteelCleaners"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"StainlessSteelCleaners"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"StainlessSteelCleaners"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"StainlessSteelCleaners"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+StainlessSteelCleaners' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='StainlessSteelCleaners',`category_4` ='StainlessSteelCleaners') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'StainlessSteelCleaners,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('StainlessSteelCleaners', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Stainless Steel Cleaners

Refine Search

  GO
 
Brand

Sheila Shine(8)

Misty(5)

WEIMAN(4)

3M(3)

Boardwalk(2)

Simple Green(2)

Professional EASY-OFF(2)

Tarn-X PRO(2)

CLR PRO(2)

Twinkle(2)

CLR(1)

Dymon(1)

Hope's(1)

BRASSO(1)

Diversey(1)

Chase Products(1)

Zep Professional(1)

Zep Commercial(1)

 
Packing Type

Aerosol(20)

Bottle(7)

Can(7)

Trigger Bottle(2)

Drum(1)

Spray Bottle(1)

Trigger Spray Bottle(1)

Pail(1)

 
Manufacturer Part Number

1001541(1)

4CT(1)

89334(1)

18300(1)

18300CT(1)

1CT(1)

1EA(1)

2CT(1)

2EA(1)

4EA(1)

76461(1)

SSCA10(1)

SSCA128(1)

108(1)

108EA(1)

49(1)

49CT(1)

1047673(1)

76461CT(1)

85901(1)

1001541EA(1)

991224(1)

1001557(1)

1002008(1)

1038047(1)

347-ACT(1)

347AEA(1)

5197(1)

94970590(1)

991224EA(1)

59158(1)

22PS6(1)

20920(1)

CLRMC-4PRO(1)

CLRMC-4PROEA(1)

CSS-12(1)

TX4PROCT(1)

TX4PROEA(1)

14002(1)

ZUSSTL14EA(1)

 
Country of Origin

US(40)

 
Capacity (Volume)

17 oz(6)

1 gal(5)

10 oz(4)

32 oz(3)

16 oz(3)

22 oz(3)

18 oz(3)

15 oz(2)

1 qt(2)

128 oz(2)

5 gal(1)

8 oz(1)

12 oz(1)

21 oz(1)

16.000 oz(1)

55.000 gal(1)

14 oz(1)

 
Scent

Unscented(11)

Lemon(8)

Wintergreen(8)

Citrus(4)

Neutral(2)

Floral(2)

 
Dirt Types

Dust; Grease; Water Marks; Grime; Rust; Stains.(8)

Smudge;Water Mark;Fingerprint(2)

Patina; Tarnish(2)

Fingerprints; Grease; Residue; Smudges(2)

Smudge; Fingerprint; Light Soils(2)

Dust; Fingerprints; Grease; Smudges; Soil; Water Marks(2)

Dirt; Fingerprint; Grease; Water Mark(2)

Dirt;Dust;Fingerprints;Smudges;Water Spot(2)

Grease;Smudge;Water Mark;Fingerprint(2)

Grease; Oil(2)

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

Dust; Fingerprints; Grease; Grime; Soil(1)

Fingerprints; Dirt; Grime(1)

Grease;Grime(1)

Marker; Ink; Grease; Oil, Food(1)

Dust; Fingerprints; Grease; Grime; Water-Based Soil(1)

Tarnish(1)

Rust(1)

Fingerprints; Water spots; Dust; Dirt(1)

Fingerprints; Water Spots; Dust; Dirt(1)

Bug Residue; Exhaust Deposits; Road Film(1)

Dirt; Dust; Smudges; Fingerprints(1)

 
Capacity (Weight)

0.8 lbs(1)

 
Chemical Compound

Acetone(8)

Ammonia(2)

Disodium Cocoamphodiproprionate; Methanol; Sulfamic Acid; Thiourea(2)

Mineral Oil; Distillates (Petroleum), Hydrotreated Light(2)

Calcium Carbonate; Pumice; Tall Oil Acid; Isopropyl Alcohol(1)

Sodium Xylenesulphonate; Alcohols C10 14, Ethoxylated; Sodium Metasilicate(1)

Paraffin Oil; Blend of Heavy and Light Naphthenic Petroleum Distillate; Hydrotreated Light Petroleum Distillates; Paraffinic; Naphthenic Solvent; Petroleum Spirits; vm&p Naphtha; Refined Solvent Naphtha; Isopropyl Alcohol; IPA; Dimethylcarbinol; 2-propanol; Carbon Dioxide(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved