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

Towels & Wipes(20)

Sprayers, Hoses and Nozzles(17)

Safety Headgear Accessories(17)

Lawn and Garden Tools(16)

Fuel and Fuel Additives(16)

Screwdrivers and Nut Drivers(15)

Label Maker Supplies(14)

Air Compressor Attachments and Accessories(12)

Batteries(11)

Hand Tool Organizers and Belts(11)

Ropes, Harnesses and Climbing Tools(10)

Scouring Pads/Sticks(10)

Markers(9)

Water/Solvent/Fuel Pumps(9)

First Aid Kits(8)

Mounting Brackets(8)

Clamps and Spreaders(7)

Scrub Pad Holders(7)

Sheet Protectors(7)

Paint Supplies(7)

Hook & Loop Fasteners(7)

Vacuum Cleaner Accessories(5)

Cleaners & Detergents(5)

Elbow/Knee Pads(4)

Water Coolers(4)

Atmospheric/Surface Condition Meters(4)

Rodent Control Products(4)

Carpet/Floor Blowers(4)

Levels(4)

Carpet Extractors(3)

Label Makers(3)

Scissors(3)

Safety Glasses(3)

Safety Cans and Accessories(3)

Labels(3)

Electrical Accessories(2)

Coffee Brewers(2)

Multi-Purpose Tools(2)

Power Strips(2)

Flashlights(2)

Tricycles & Ride-ons(1)

Towel Dispensers(1)

Paints(1)

Blood Cleanup Kits(1)

Surge Protectors(1)

Books W/cd(1)

Desktop File Folder Sorters(1)

Herbicides(1)

Stud Finders(1)

Extension Cords(1)

Label Holders(1)

First Aid Kit Refills(1)

Saws(1)

Mounting Tape(1)

Packing Tape(1)

Vacuum Cleaners(1)

History(1)

Paint Brushes(1)

 
Brand

Klein Tools(19)

RIDGID(18)

DYMO(16)

Sterno(14)

Boardwalk(12)

Tork(12)

Guardair(12)

3M(10)

GMT(10)

Georgia Pacific Professional(9)

C-Line(8)

Fiskars(8)

First Aid Only(7)

Jackson(7)

H.K. Porter(7)

Rayovac(7)

VELCRO Brand(7)

Sharpie(6)

Hoover Commercial(6)

Oetiker(5)

Energizer(5)

Sanitaire(5)

Weiler(5)

Stanley Tools(5)

Rubbermaid Commercial(5)

Igloo(4)

Gilmour(4)

Simple Green(4)

Honeywell Uvex(4)

d-CON(4)

UnionTools(3)

ergodyne(3)

Stanley(3)

WORLD DRYER(3)

DBI-SALA(3)

Eklind(3)

Imperial(3)

DYKEM(3)

MSA(3)

CHANNELLOCK(3)

Tripp Lite(3)

Mercury Floor Machines(3)

PM Company(3)

JUSTRITE(3)

Pac-Kit(2)

Coffee Pro(2)

Magnolia Brush(2)

Keeper(2)

KNIPEX(2)

Kidde(2)

TOLCO(2)

ALTA(2)

Anchor Brand(2)

Fill-Rite(2)

Flange Wizard Tools(2)

Great Neck(2)

Universal(2)

CCI(2)

Fibre-Metal by Honeywell(2)

Crews(2)

hudson(2)

IRWIN(1)

Unger(1)

Warp's(1)

Rust-Oleum(1)

Wiss(1)

Tempil(1)

Wiha(1)

Rubbermaid(1)

Ingersoll Rand(1)

Chapin(1)

Brother P-Touch(1)

deflecto(1)

Diversey(1)

Elmer's(1)

Binks(1)

Bright Star(1)

Allegro(1)

Misty(1)

Enforcer(1)

Armstrong Tools(1)

Ericson(1)

Sheffield(1)

Jackson Safety*(1)

Scotch(1)

Sani Professional(1)

Dynamo(1)

KleenGuard(1)

Iwatani(1)

Greenlee(1)

Hooven Allison(1)

IDEAL(1)

PhysiciansCare by First Aid Only(1)

Plews & Edelmann(1)

 
Height

12"(5)

8"(3)

10"(2)

18.8"(2)

17"(2)

15"(2)

22 1/2"(2)

46"(2)

14"(2)

9"(2)

42 1/2"(2)

25"(2)

5 1/2"(2)

3"(1)

15 1/4"(1)

4 1/4"(1)

14 1/2"(1)

4 1/2"(1)

19"(1)

9.25"(1)

1 3/5"(1)

10 1/5"(1)

13.5"(1)

1 1/4"(1)

18 9/10"(1)

1.25"(1)

5.4"(1)

7.280"(1)

16 1/2"(1)

17 1/2"(1)

16"(1)

22 1/4"(1)

26"(1)

11 1/2"(1)

3.5"(1)

9 1/4"(1)

1 3/4"(1)

15 3/10"(1)

23.5"(1)

16 1/8"(1)

7"(1)

9 1/2"(1)

16 7/8"(1)

16.875"(1)

14.13"(1)

20.25"(1)

15 1/2"(1)

 
Color(s)

White(26)

Black(18)

Clear(15)

Aluminum(12)

Steel Gray(10)

Gray(7)

Silver(6)

Blue(6)

Red(5)

Yellow/Black(5)

Black/Orange(4)

Yellow(4)

Yellow/Red(4)

Stainless Steel(3)

Brown(3)

Stainless Steel/White(3)

Translucent Blue/Black(2)

White/Black(2)

Orange(2)

Natural White(2)

Clear/Green(2)

Black/Clear(2)

Black/Natural(2)

Yellow/Navy(2)

Red/Black(2)

Gray/Brass(2)

Tan(1)

Black/Red(1)

Clear/White(1)

Smoke(1)

Light Gray(1)

Green/Black(1)

White/Gold(1)

Blue/Brass/Black(1)

Brass(1)

Black/Yellow(1)

Black; Orange; Silver(1)

Black/Silver/Brass(1)

Navy(1)

Black/Brass(1)

Green(1)

 
Depth

5 3/4"(3)

6"(2)

18.7"(2)

7 1/2"(2)

9"(2)

1"(2)

16 1/2"(2)

1/8"(2)

5"(2)

10"(2)

4 1/4"(2)

8"(2)

14 3/4"(1)

2"(1)

2 3/4"(1)

1 5/8"(1)

5.75"(1)

0.08"(1)

14"(1)

15"(1)

10 7/8"(1)

5 5/8"(1)

7"(1)

11.13"(1)

42"(1)

17 1/10"(1)

 
Quantity

1 each(13)

1 roll(13)

12 per box(3)

8/Pack(2)

12/Pack(2)

1 kit(2)

24 per box(2)

1 per carton(1)

100 per carton(1)

24/Pack(1)

18/Pack(1)

 
Size

4" x 9"(3)

4 5/8" x 10"(2)

10" x 4 5/8"(1)

48 mm x 50 m(1)

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

4 x 7/8(1)

 
Packing Type

Can(8)

PET Bottle(7)

Box(5)

Bottle(4)

Spray Bottle(2)

Wall-Mountable Plastic Storage Rack(1)

Pail(1)

Plastic Kit(1)

Carded Pack(1)

Storage Case(1)

Plastic Case(1)

 
Diameter

12"(3)

4.6"(2)

1 1/4"(2)

11.75"(2)

1"(2)

8"(2)

5"(2)

11 3/4"(1)

2 1/2"(1)

7.8"(1)

16"(1)

0.42"(1)

3/8"(1)

4 3/4"(1)

13.75"(1)

14.5"(1)

 
 
 

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