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

Currently Filtered by

Category

Lubricant

Refine Search
  GO
Brand

WD-40(20)

Misty(9)

Tap Magic(4)

LPS(3)

Zep Professional(2)

Relton(1)

Super Lube(1)

Markal(1)

Sprayon(1)

Kolor Kut(1)

CRC(1)

i-Chem(1)

Diversey(1)

Suma(1)

Jet-Lube(1)

Asbury Carbons(1)

Loctite(1)

Packing Type

Aerosol Can(13)

Aerosol(12)

Can(9)

Bottle(8)

Tube(4)

Brush-in-Cap(1)

Pail(1)

Cartridge(1)

Spray Bottle(1)

Country of Origin

US(47)

United States(2)

CN(1)

Material(s)

Fluid(2)

Grease(1)

Capacity (Volume)

4 oz(9)

10 oz(6)

11 oz(5)

16 oz(5)

11.000 oz(3)

3 oz(2)

1 gal(2)

14.4 oz(2)

1 lb(2)

12.000 oz(2)

14 oz(2)

24 oz(1)

20 oz(1)

12 oz(1)

19.000 oz(1)

5 gal(1)

15 oz(1)

32 oz(1)

8 oz(1)

Chemical Compound

Petroleum Distillates(4)

Silicone(4)

Aliphatic Hydrocarbon;Petroleum Base Oil(3)

PTFE(2)

Aliphatic Hydrocarbon; Carbon Dioxide; Petroleum Base Oil; Surfactant(1)

Lithium(1)

Aliphatic Hydrocarbon;Carbon Dioxide;Petroleum Base Oil;Surfactan(1)

Butane; Distillates (Petroleum), Hydrotreated Light; Heptane; Naphtha (Petroleum), Hydrotreated Light; Petroleum Distillates; Propane(1)

Aliphatic Hydrocarbon; Petroleum Base Oil(1)

Aliphatic Petroleum Distillates;Liquefied Petroleum Gas(1)

Distillates Petroleum Hydrotreated Light; 1-butoxy-2-propano; Acetone; Distillates Petroleum Hydrotreated Heavy; 9Carbon Dioxide; Calcium Carbonate; Hydrodesulferized Heavy Petroleum Naptha; Petrolatum(1)

Perchloroethylene, Trichloroethylene, Carbon Dioxide, Petroleum Distillate(1)

Molybdenum Disulfide;PTFE(1)

Acetone; Propane; Butane; Naphtha(1)

Graphite; Molybdenum(1)

Graphite(1)

Isopropryl Alcohol(1)

Petroleum Based; Graphite; Copper Flakes(1)

Type

Aerosol(2)

High Pressure Lubricant(1)

Applicable Material

Metal(11)

Glass; Metal; Plastic; Rubber; Wood(8)

Metal; Plastic; Rubber(6)

Metal; Plastic; Rubber; Wood(2)

Metal; Steel(2)

Metal; Plastic(1)

Metal; Stainless Steel(1)

Leather; Metal; Plastic; Rubber; Wood(1)

Most Metals(1)

Aluminum; Plastic; Stainless Steel; Steel; Rubber(1)

Metal; Plastics; Steel(1)

Fabric;Glass;Metal;Plastic;Rubber;Vinyl;Wood(1)

Metal;Steel(1)

Fabric;Foam;Glass;Metal;Plastic;Rubber;Vinyl;Wood(1)

Conveyor(1)

Metal; Steel; Wood(1)

Fabric;Metal;Plastic;Rubber;Vinyl(1)

Application

Machinery; Moving Parts(12)

Gears;Hinges;Moving Parts;Sliding Doors;Tools(5)

Chains;Fittings;Locks;Lug Nuts;Nuts;Pipes;Tools(4)

Gears; Hinges; Moving Parts; Sliding Doors; Tools(4)

Appliances;Automotive Maintenance; Bolts; Electronic Equipment; Gears; Locks; Machinery; Moving Parts; Tools(2)

Glass; Hinges; Moving Parts(2)

Garage Doors(1)

Tools; Metal; Machinery(1)

Appliances; Bolts; Cutting Tables; Foodservice; Machinery; Moving Parts; Windows(1)

High-Load Applications(1)

Lawn/Garden Equipment; Engine Components; Marine Equipment(1)

Appliances; Automotive Maintenance; Heavy Equipment; Machinery(1)

Glass; Hinges; Moving Parts; Metal Surfaces; Sliding Doors(1)

Petroleum Based(1)

Nuts; Bolts; Gears; Moving Parts; Tools; Metal; Machinery; Appliances(1)

Electrical Equipment; Guns; Machinery Parts(1)

Automotive Maintenance;Machinery;Moving Parts(1)

Nuts;Bolts;Moving Parts(1)

Chains;Machinery;Moving Parts;Sprockets;Wire Cables(1)

Bolts;Cutting Tables;Doors;Electronics;Locks;Machinery;Moving Parts;Windows(1)

Machinery;Moving Parts(1)

Appliances;Auto;Doors;Drawers;Fixtures;Tables;Windows(1)

Casters; Chains; Channels; Conveyors; Filling Equipment; Food Racks; Food Service Carts; Slicers(1)

Tools; Cutlery; Food Preparation Equipment(1)

Belts; Chains; Chutes; Conveyors; Couplings; Cutting Tables; Drills; Extrusions; Glides; Hinges; Needles; Pulleys; Rails; Slides; Lock Assemblies; Saws; Sewing Parts; Slot/Vending Machines; Tracks; Trunk Hinges; Window/Door Parts(1)

Appliances;Bolts;Cutting Tables;Foodservice;Ice Machines;Machinery;Moving Parts(1)

Cutting Tables;Moving Parts(1)

Special Features

Drip Spout for Easy Application(6)

EZ-REACHT Flexible Straw-Flexible straw keeps its shape and allows easy access to hard-to-reach spaces.(2)

Temperature Range [Max]

1800 F(3)

500 F(2)

500F(2)

300 F(2)

600 F(1)

572 F(1)

130 F(1)

400F(1)

385 F(1)

550.00 F(1)

450 F(1)

Temperature Range [Min]

-100 F(2)

0 F(2)

- 100 F(2)

-18 F(1)

-40 F(1)

-45 F(1)

-65 F(1)

-40F(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved

Powered by SITS Erp