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 ((`desc_short` like 'industrial supplies' OR `desc_long` like 'industrial supplies' OR `desc_title` like 'industrial supplies' OR `keywords` like 'industrial supplies' OR `category_1` like 'industrial supplies' OR `category_2` like 'industrial supplies' OR `category_3` like 'industrial supplies' OR `category_4` like 'industrial supplies' OR `manufacturer_name` like 'industrial supplies' OR `color` like 'industrial supplies') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>industrial>industrials)+(>supplies>supplies)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"industrial supplies"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%industrial supplies%' OR `pinfo`.`sku` like '%industrialsupplies%' OR (FIND_IN_SET('industrial supplies', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('industrial supplies', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('industrial supplies', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('industrial supplies', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('industrial supplies', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'industrial supplies' ELSE `pinfo`.`desc_title` like 'industrial supplies' END))) 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 '%industrial supplies' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('industrial +supplies' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+industrial +supplies' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"industrial supplies"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"industrial supplies"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"industrial supplies"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"industrial supplies"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+industrial +supplies' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='supplies',`category_4` ='supplies') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'supplies,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('supplies', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Industrial Supplies

Refine Search

  GO
 
Category Filter

Pliers and Cutters(37)

Sprayers, Hoses and Nozzles(19)

Towels & Wipes(18)

Label Maker Supplies(16)

Fuel and Fuel Additives(15)

Screwdrivers and Nut Drivers(14)

Air Compressor Attachments and Accessories(12)

Batteries(12)

Safety Headgear Accessories(11)

Markers(11)

Hand Tool Organizers and Belts(11)

Scouring Pads/Sticks(10)

Water/Solvent/Fuel Pumps(9)

Hook & Loop Fasteners(7)

Ropes, Harnesses and Climbing Tools(7)

First Aid Kits(7)

Sheet Protectors(7)

Mounting Brackets(7)

Scrub Pad Holders(7)

Clamps and Spreaders(7)

Cleaners & Detergents(5)

Paint Supplies(4)

Rodent Control Products(4)

Label Makers(4)

Carpet/Floor Blowers(4)

Atmospheric/Surface Condition Meters(4)

Elbow/Knee Pads(3)

Labels(3)

Safety Glasses(3)

Carpet Extractors(3)

Water Coolers(3)

Levels(3)

Lawn and Garden Tools(3)

Electrical Accessories(2)

Scissors(2)

Power Strips(2)

Coffee Brewers(2)

Flashlights(2)

Safety Cans and Accessories(2)

Vacuum Cleaner Accessories(2)

Multi-Purpose Tools(2)

Extension Cords(1)

Herbicides(1)

Vacuum Cleaners(1)

Surge Protectors(1)

Towel Dispensers(1)

Paints(1)

Desktop File Folder Sorters(1)

Packing Tape(1)

Blood Cleanup Kits(1)

First Aid Kit Refills(1)

Books W/cd(1)

Label Holders(1)

Paint Brushes(1)

Stud Finders(1)

Mounting Tape(1)

Tricycles & Ride-ons(1)

 
Brand

DYMO(19)

Klein Tools(19)

RIDGID(15)

Guardair(12)

Boardwalk(12)

Sterno(12)

Tork(10)

GMT(10)

Georgia Pacific Professional(9)

Rayovac(8)

Sharpie(8)

C-Line(8)

3M(7)

H.K. Porter(7)

VELCRO Brand(7)

First Aid Only(6)

Energizer(5)

TOLCO(5)

Stanley Tools(5)

Hoover Commercial(5)

Oetiker(5)

Rubbermaid Commercial(4)

Simple Green(4)

Gilmour(4)

d-CON(4)

Sanitaire(3)

Tripp Lite(3)

Igloo(3)

WORLD DRYER(3)

PM Company(3)

Weiler(3)

Stanley(3)

Honeywell Uvex(3)

CHANNELLOCK(3)

ergodyne(3)

Mercury Floor Machines(3)

Eklind(3)

Imperial(3)

DYKEM(3)

Jackson(2)

Keeper(2)

KNIPEX(2)

Scotch(2)

JUSTRITE(2)

Iwatani(2)

Pac-Kit(2)

Coffee Pro(2)

DBI-SALA(2)

CCI(2)

Anchor Brand(2)

Fill-Rite(2)

Flange Wizard Tools(2)

Universal(2)

ALTA(2)

Crews(2)

Wiha(1)

Plews & Edelmann(1)

Rubbermaid(1)

IRWIN(1)

Rust-Oleum(1)

UnionTools(1)

Unger(1)

Tempil(1)

PhysiciansCare by First Aid Only(1)

Ingersoll Rand(1)

Dynamo(1)

Fibre-Metal by Honeywell(1)

Enforcer(1)

Armstrong Tools(1)

Bright Star(1)

Binks(1)

Brother P-Touch(1)

Chapin(1)

deflecto(1)

Diversey(1)

Elmer's(1)

Ericson(1)

Fiskars(1)

Sani Professional(1)

Sheffield(1)

Great Neck(1)

Greenlee(1)

hudson(1)

Hooven Allison(1)

IDEAL(1)

Misty(1)

KleenGuard(1)

Jackson Safety*(1)

Magnolia Brush(1)

MSA(1)

Warp's(1)

 
Height

8"(3)

12"(3)

25"(2)

17"(2)

9"(2)

5 1/2"(2)

15"(2)

18.8"(2)

10"(2)

46"(2)

42 1/2"(2)

14"(2)

1 3/5"(1)

3"(1)

14 1/2"(1)

13.5"(1)

19"(1)

15 1/4"(1)

4 1/2"(1)

10 1/5"(1)

1 1/4"(1)

16 1/2"(1)

5.4"(1)

7.280"(1)

18 9/10"(1)

9.25"(1)

16 1/8"(1)

15 1/2"(1)

22 1/2"(1)

9 1/4"(1)

1 3/4"(1)

3.5"(1)

11 1/2"(1)

16"(1)

22 1/4"(1)

26"(1)

9 1/2"(1)

15 3/10"(1)

23.5"(1)

14.13"(1)

20.25"(1)

16.875"(1)

7"(1)

16 7/8"(1)

 
Color(s)

White(26)

Black(13)

Clear(12)

Aluminum(12)

Steel Gray(10)

Gray(6)

Silver(6)

Blue(6)

Yellow/Black(5)

Yellow(4)

Red(4)

Yellow/Red(3)

Brown(3)

Stainless Steel/White(3)

Stainless Steel(3)

Natural White(2)

Clear/Green(2)

Gray/Brass(2)

Orange(2)

Light Gray(1)

Clear/White(1)

Tan(1)

White/Black(1)

Gray/Natural(1)

Black/Red(1)

Black/Silver/Brass(1)

Green(1)

Translucent Blue/Black(1)

Red/Black(1)

Green/Black(1)

Black/Brass(1)

Black/Orange(1)

Black/Yellow(1)

White/Gold(1)

Yellow/Navy(1)

Blue/Brass/Black(1)

Brass(1)

Black/Clear(1)

 
Depth

5 3/4"(2)

9"(2)

10"(2)

4 1/4"(2)

8"(2)

5"(2)

16 1/2"(2)

18.7"(2)

1"(2)

6"(2)

5.75"(1)

2 3/4"(1)

2"(1)

14 3/4"(1)

0.08"(1)

17 1/10"(1)

5 5/8"(1)

14"(1)

1/8"(1)

42"(1)

7"(1)

15"(1)

10 7/8"(1)

11.13"(1)

1 5/8"(1)

 
Quantity

1 each(2)

100 per carton(1)

 
Size

4" x 9"(3)

4 5/8" x 10"(2)

4" x 7/8"(1)

3 1/2" W x 4 3/4" L x 2 1/2" H(1)

48 mm x 50 m(1)

10" x 4 5/8"(1)

 
Packing Type

Can(7)

PET Bottle(6)

Bottle(4)

Box(4)

Spray Bottle(2)

Wall-Mountable Plastic Storage Rack(1)

Storage Case(1)

Carded Pack(1)

Pack(1)

Plastic Kit(1)

Plastic Case(1)

Pail(1)

 
Diameter

12"(3)

1 1/4"(2)

8"(2)

5"(2)

4.6"(2)

0.42"(1)

1"(1)

3/8"(1)

4 3/4"(1)

16"(1)

13.75"(1)

14.5"(1)

11.75"(1)

11 3/4"(1)

2 1/2"(1)

7.8"(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved