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)

Markers(32)

Label Maker Supplies(21)

Towels & Wipes(19)

Sprayers, Hoses and Nozzles(16)

Fuel and Fuel Additives(14)

Screwdrivers and Nut Drivers(14)

Batteries(12)

Air Compressor Attachments and Accessories(12)

Hand Tool Organizers and Belts(11)

Scouring Pads/Sticks(10)

Label Holders(9)

Water/Solvent/Fuel Pumps(9)

Hook & Loop Fasteners(8)

Ropes, Harnesses and Climbing Tools(8)

Safety Headgear Accessories(8)

First Aid Kits(8)

Sheet Protectors(7)

Mounting Brackets(7)

Clamps and Spreaders(7)

Scrub Pad Holders(7)

Paint Supplies(6)

Label Makers(5)

Carpet/Floor Blowers(4)

Cleaners & Detergents(4)

Rodent Control Products(4)

Elbow/Knee Pads(3)

Atmospheric/Surface Condition Meters(3)

Safety Glasses(3)

Water Coolers(3)

Carpet Extractors(3)

Lawn and Garden Tools(3)

Labels(3)

Safety Cans and Accessories(3)

Levels(3)

Coffee Brewers(2)

Power Strips(2)

Scissors(2)

Electrical Accessories(2)

Flashlights(2)

Multi-Purpose Tools(2)

Vacuum Cleaner Accessories(2)

Paints(1)

Desktop File Folder Sorters(1)

Stud Finders(1)

Surge Protectors(1)

First Aid Kit Refills(1)

Towel Dispensers(1)

Herbicides(1)

Abrasive-Coated Paper/Cloth(1)

Packing Tape(1)

Saws(1)

Blood Cleanup Kits(1)

Books W/cd(1)

Paint Brushes(1)

Vacuum Cleaners(1)

Extension Cords(1)

Tricycles & Ride-ons(1)

 
Brand

DYMO(25)

uni-Paint(21)

Klein Tools(20)

C-Line(16)

RIDGID(15)

Sterno(13)

Guardair(12)

Boardwalk(12)

Georgia Pacific Professional(10)

GMT(10)

Tork(10)

Sharpie(8)

VELCRO Brand(8)

Rayovac(8)

3M(8)

H.K. Porter(7)

First Aid Only(6)

Rubbermaid Commercial(5)

Hoover Commercial(5)

Oetiker(5)

Energizer(5)

TOLCO(5)

Stanley Tools(5)

Simple Green(4)

d-CON(4)

WORLD DRYER(3)

PM Company(3)

Mercury Floor Machines(3)

JUSTRITE(3)

Weiler(3)

DYKEM(3)

Imperial(3)

Tripp Lite(3)

Stanley(3)

Eklind(3)

Honeywell Uvex(3)

Gilmour(3)

Sanitaire(3)

ergodyne(3)

Pac-Kit(3)

Igloo(3)

DBI-SALA(3)

Universal(2)

Keeper(2)

Coffee Pro(2)

CHANNELLOCK(2)

Magnolia Brush(2)

IRWIN(2)

ALTA(2)

KNIPEX(2)

CCI(2)

Jackson(2)

Fill-Rite(2)

Rust-Oleum(2)

Flange Wizard Tools(2)

Rubbermaid(1)

Wiha(1)

Unger(1)

UnionTools(1)

Plews & Edelmann(1)

PhysiciansCare by First Aid Only(1)

MSA(1)

Elmer's(1)

Armstrong Tools(1)

Bright Star(1)

Binks(1)

Brother P-Touch(1)

Crews(1)

MCR Safety(1)

deflecto(1)

Diversey(1)

Dixon(1)

Ericson(1)

Scotch(1)

Fibre-Metal by Honeywell(1)

Fiskars(1)

Sheffield(1)

Great Neck(1)

Greenlee(1)

Hooven Allison(1)

IDEAL(1)

Enforcer(1)

Iwatani(1)

KleenGuard(1)

Warp's(1)

 
Height

12"(3)

25"(2)

5 1/2"(2)

17"(2)

42.5"(2)

46"(2)

8"(2)

18.8"(2)

15"(2)

10"(2)

1.25"(2)

18.9"(1)

14"(1)

19"(1)

15 1/4"(1)

3"(1)

5.4"(1)

4 1/2"(1)

6 1/2"(1)

16 1/2"(1)

9.25"(1)

1.6"(1)

10.2"(1)

13.5"(1)

15 1/2"(1)

16 1/8"(1)

9 1/2"(1)

26"(1)

1 3/4"(1)

3.5"(1)

11 1/2"(1)

16"(1)

22.25"(1)

22.5"(1)

4"(1)

7"(1)

15 3/10"(1)

23.5"(1)

14.13"(1)

20.25"(1)

16.875"(1)

16 7/8"(1)

9 1/4"(1)

17 1/2"(1)

 
Color(s)

White(29)

Clear(15)

Black(14)

Aluminum(12)

Steel Gray(10)

Silver(6)

Gray(6)

Yellow(6)

Yellow/Black(5)

Blue(5)

Red(5)

Yellow/Red(3)

Brown(3)

Orange(3)

Stainless Steel/White(3)

Gray/Brass(2)

Stainless Steel(2)

Natural White(2)

Clear/Green(2)

Light Gray(1)

White/Black(1)

Clear/White(1)

Gray/Natural(1)

Red/Black(1)

Tan(1)

Black/Silver/Brass(1)

Black/Brass(1)

Black/Orange(1)

Black/Yellow(1)

White/Gold(1)

Yellow/Navy(1)

Brass(1)

Black/Clear(1)

 
Depth

5.75"(3)

6"(2)

9"(2)

10"(2)

4.25"(2)

8"(2)

5"(2)

2 3/4"(2)

16 1/2"(2)

18.7"(2)

1"(2)

2"(1)

14 3/4"(1)

17.1"(1)

5 5/8"(1)

14"(1)

42"(1)

0.88"(1)

7"(1)

15"(1)

10.88"(1)

11.13"(1)

1.63"(1)

 
Quantity

1 each(2)

100 per carton(1)

 
Size

4" x 9"(3)

4.25 x 2.5(3)

4 5/8" x 10"(2)

3.5 x 1.5(1)

4 x 0.78(1)

6 x 0.5(1)

6 x 1(1)

6 x 2(1)

6 x 2.5(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

PET Bottle(7)

Can(7)

Box(4)

Bottle(3)

Spray Bottle(2)

Storage Case(1)

Carded Pack(1)

Plastic Kit(1)

Plastic Case(1)

 
Diameter

12"(3)

1.25"(2)

8"(2)

5"(2)

11.75"(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 3/4"(1)

2 1/2"(1)

7.8"(1)

 
 
 

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