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

Currently Filtered by

Category

Specialty Cleaners Lubricants

Refine Search

  GO
 
Brand

Easy-Off(8)

Spray Nine(5)

Genuine Joe(4)

WD-40(4)

Diversey(3)

HSM(3)

Green Earth(2)

Dymon(2)

Lime-A-Way(2)

KIWI(2)

Zep Commercial(2)

Palmolive(1)

3M(1)

Martin Yale(1)

Simple Green(1)

Zep(1)

 
Color

Clear(12)

White(4)

Blue(3)

Yellow(3)

Dark Green(2)

Brown(2)

Multi(2)

Light Green(2)

Black(2)

Light Brown(1)

Amber(1)

Gray(1)

Off White(1)

Light Amber(1)

 
Recycled

No(31)

Yes(11)

 
Packaged Quantity

1 Each(17)

12 / Carton(10)

4 / Carton(5)

6 / Carton(5)

9 / Carton(1)

100 / Carton(1)

1 / Each(1)

8 / Carton(1)

48 / Carton(1)

 
Assembly Required

No(42)

 
Limited Warranty

Lifetime(3)

 
Weight (Approximate)

1 lb(1)

16 oz(1)

12 oz(1)

2 lb(1)

 
Compatibility

Shreders:

  • HSM 70.2, HSM 70.2cc
  • HSM 80.2, HSM 80.2cc
  • HSM 90.2, HSM 90.2cc
  • HSM 102.2, HSM 102.2cc
  • HSM 104.2, HSM 104.2cc
  • HSM 105.2, HSM 105.2cc, HSM 105.2 HS5
  • HSM 108.2, HSM 108.2cc
  • HSM 125.2, HSM 125.2cc, HSM 125.2 HS5, HSM 125.2 HS6
  • HSM 225.2, HSM 225.2cc, HSM 225.2 HS5, HSM 225.2 HS6
  • HSM B22s, HSM B22c
  • HSM B24s, HSM B24c
  • HSM B32s, HSM B32c
  • HSM B34s, HSM B34c
(1)

 
Recommended Use

Grease Remover(21)

Oil Remover(8)

Soil Remover(6)

Baked-on Food Remover(6)

Fat Remover(4)

Spill Remover(4)

Food Remover(4)

Stain Remover(4)

Dirt Remover(4)

Water Mark Remover(4)

Spot Remover(3)

Grime Remover(3)

Fingerprint Remover(3)

Film Remover(3)

Carbon Remover(3)

Limescale Remover(2)

Scuff Mark Remover(2)

Adhesive Remover(2)

Smoke Film Remover(2)

Calcium Deposit Remover(2)

Ink Remover(2)

Heel Mark Remover(1)

Moisture Remover(1)

Scratch Remover(1)

Debris Remover(1)

Soot Remover(1)

Graffiti Remover(1)

Odor Remover(1)

Streak Remover(1)

Lipstick Remover(1)

Crayon Mark Remover(1)

Rust Remover(1)

 
Volume Capacity

12 fl oz(1)

11.83 fl oz(1)

14 fl oz(1)

 
Cleaner Type

Liquid(12)

Aerosol(8)

Spray(6)

Powder(2)

Sponge(1)

 
Composition

Surfactant(4)

Water(3)

Alkaline(2)

Sodium Benzoate(1)

Sorbitan Sesquioctanoate(1)

Propane(1)

Isoparaffin(1)

Isobutane(1)

Mineral Oil(1)

Sodium Bisulfite(1)

Methylchloroisothiazolinone(1)

Benzisothiazolinone(1)

Methylisothiazolone(1)

Dye(1)

Pentasodium Pentetate(1)

Fragrance(1)

Magnesium Sulfate(1)

Sodium Chloride(1)

Poloxamer 124(1)

Isodeceth-6(1)

Lauramidopropylamine Oxide(1)

Ammonium Laureth Sulfate(1)

Ammonium Lauryl Sulfate(1)

Lemon(1)

 
Cleaner Volume

1 gal (128 fl oz)(5)

0.25 gal (32 fl oz)(4)

0.19 gal (24 fl oz)(4)

0.12 gal (15 fl oz)(2)

7 fl oz(2)

0.50 gal (64 fl oz)(2)

0.53 gal (67.63 fl oz)(1)

0.25 gal (32.50 fl oz)(1)

0.16 gal (20 fl oz)(1)

10 fl oz(1)

0.10 gal (13 fl oz)(1)

0.13 gal (17 fl oz)(1)

2.40 fl oz(1)

0.23 fl oz(1)

5 gal (640 fl oz)(1)

0.11 gal (14.40 fl oz)(1)

 
Cleaner Weight

0.99 oz (0.06 lb)(1)

24 oz (1.50 lb)(1)

 
Cleaner Form

Ready-To-Use(8)

Concentrate(5)

 
Non-Acidic

Yes(2)

 
Manufacturer Part Number

2170400CT(1)

99624(1)

36320(1)

36320CT(1)

74017(1)

74017CT(1)

76461(1)

80689(1)

80689CT(1)

633483CT(1)

04250(1)

643982CT(1)

19005(1)

490057(1)

490057CT(1)

49019(1)

49019CT(1)

1047565(1)

1047565CT(1)

04250CT(1)

88805(1)

2174700CT(1)

HSM314P(1)

04273CT(1)

90234(1)

957265280(1)

957265280CT(1)

02114(1)

02114CT(1)

10481CT(1)

99673(1)

HSM315P(1)

27901CT(1)

HSM316P(1)

20920(1)

20920CT(1)

59158(1)

200(1)

22732(1)

22732CT(1)

27901(1)

374301CT(1)

 
Country of Origin

United States(41)

Honduras(1)

 
Scent

Lemon(2)

Fresh Lemon(2)

Chlorine(1)

Neutral(1)

Lime(1)

Citrus(1)

 
Container Type

Can(3)

Bottle(2)

 
 
 

© 2020-2021 Rapid Supply, All Rights Reserved