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') 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)

Fuel and Fuel Additives(15)

Label Maker Supplies(15)

Screwdrivers and Nut Drivers(14)

Safety Headgear Accessories(12)

Air Compressor Attachments and Accessories(12)

Batteries(12)

Hand Tool Organizers and Belts(11)

Scouring Pads/Sticks(10)

Markers(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)

Atmospheric/Surface Condition Meters(4)

Carpet/Floor Blowers(4)

Elbow/Knee Pads(3)

Labels(3)

Safety Glasses(3)

Carpet Extractors(3)

Water Coolers(3)

Lawn and Garden Tools(3)

Label Makers(3)

Levels(3)

Multi-Purpose Tools(2)

Electrical Accessories(2)

Scissors(2)

Power Strips(2)

Flashlights(2)

Coffee Brewers(2)

Vacuum Cleaner Accessories(2)

Safety Cans and Accessories(2)

Extension Cords(1)

Stud Finders(1)

Herbicides(1)

Books W/cd(1)

Surge Protectors(1)

Towel Dispensers(1)

Paints(1)

Desktop File Folder Sorters(1)

Packing Tape(1)

Blood Cleanup Kits(1)

Vacuum Cleaners(1)

First Aid Kit Refills(1)

History(1)

Paint Brushes(1)

Label Holders(1)

Mounting Tape(1)

Tricycles & Ride-ons(1)

 
Brand

Klein Tools(19)

DYMO(17)

RIDGID(15)

Guardair(12)

Boardwalk(12)

Sterno(12)

Tork(10)

GMT(10)

3M(9)

Georgia Pacific Professional(9)

Rayovac(8)

C-Line(8)

Sharpie(7)

H.K. Porter(7)

VELCRO Brand(7)

First Aid Only(6)

Oetiker(5)

Hoover Commercial(5)

Energizer(5)

TOLCO(5)

Stanley Tools(5)

Gilmour(4)

Rubbermaid Commercial(4)

d-CON(4)

Simple Green(4)

DYKEM(3)

Weiler(3)

ergodyne(3)

Imperial(3)

Mercury Floor Machines(3)

Honeywell Uvex(3)

CHANNELLOCK(3)

Stanley(3)

Igloo(3)

WORLD DRYER(3)

Sanitaire(3)

Tripp Lite(3)

Eklind(3)

PM Company(3)

Iwatani(2)

Jackson(2)

JUSTRITE(2)

Anchor Brand(2)

KNIPEX(2)

Keeper(2)

ALTA(2)

Pac-Kit(2)

CCI(2)

Coffee Pro(2)

Fill-Rite(2)

Flange Wizard Tools(2)

Crews(2)

DBI-SALA(2)

Universal(2)

Plews & Edelmann(1)

UnionTools(1)

Rust-Oleum(1)

Wiha(1)

Rubbermaid(1)

IRWIN(1)

Tempil(1)

Unger(1)

PhysiciansCare by First Aid Only(1)

Ingersoll Rand(1)

Dynamo(1)

Fiskars(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)

Fibre-Metal by Honeywell(1)

Sheffield(1)

Sani Professional(1)

Great Neck(1)

Greenlee(1)

hudson(1)

Hooven Allison(1)

IDEAL(1)

Misty(1)

KleenGuard(1)

Jackson Safety*(1)

Scotch(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)

Clear(13)

Black(13)

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 roll(14)

1 each(12)

12 per box(3)

1 kit(2)

24 per box(2)

8/Pack(2)

12/Pack(2)

100 per carton(1)

6/Pack(1)

24/Pack(1)

18/Pack(1)

1 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