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

Label Maker Supplies(17)

Towels & Wipes(16)

Sprayers, Hoses and Nozzles(14)

Fuel and Fuel Additives(13)

Batteries(12)

Markers(11)

Scouring Pads/Sticks(10)

Screwdrivers and Nut Drivers(8)

Sheet Protectors(7)

Hook & Loop Fasteners(7)

Safety Headgear Accessories(6)

First Aid Kits(6)

Water/Solvent/Fuel Pumps(6)

Mounting Brackets(5)

Scrub Pad Holders(5)

Ropes, Harnesses and Climbing Tools(4)

Label Makers(4)

Cleaners & Detergents(4)

Rodent Control Products(4)

Water Coolers(3)

Carpet Extractors(3)

Carpet/Floor Blowers(3)

Atmospheric/Surface Condition Meters(3)

Pliers and Cutters(3)

Paint Supplies(3)

Lawn and Garden Tools(2)

Elbow/Knee Pads(2)

Power Strips(2)

Vacuum Cleaner Accessories(2)

Scissors(2)

Safety Glasses(2)

Flashlights(2)

Surge Protectors(1)

Towel Dispensers(1)

Paints(1)

Herbicides(1)

Multi-Purpose Tools(1)

Blood Cleanup Kits(1)

Mounting Tape(1)

Packing Tape(1)

Hand Tool Organizers and Belts(1)

Vacuum Cleaners(1)

Books W/cd(1)

First Aid Kit Refills(1)

Electrical Accessories(1)

Desktop File Folder Sorters(1)

Label Holders(1)

Stud Finders(1)

Tricycles & Ride-ons(1)

 
Brand

DYMO(20)

Sterno(12)

Boardwalk(12)

GMT(10)

Tork(9)

C-Line(8)

Sharpie(8)

Rayovac(8)

Georgia Pacific Professional(8)

VELCRO Brand(7)

First Aid Only(6)

Energizer(5)

Stanley Tools(5)

Hoover Commercial(5)

Rubbermaid Commercial(4)

Gilmour(4)

d-CON(4)

3M(4)

Simple Green(4)

TOLCO(4)

Mercury Floor Machines(3)

Tripp Lite(3)

Honeywell Uvex(3)

Stanley(3)

Weiler(3)

Igloo(3)

DYKEM(3)

Pac-Kit(2)

Universal(2)

Scotch(2)

WORLD DRYER(2)

DBI-SALA(2)

Sanitaire(2)

ergodyne(2)

Jackson(1)

Elmer's(1)

Bright Star(1)

IRWIN(1)

Brother P-Touch(1)

CHANNELLOCK(1)

MCR Safety(1)

Unger(1)

deflecto(1)

Diversey(1)

Rust-Oleum(1)

Ericson(1)

KleenGuard(1)

RIDGID(1)

Fibre-Metal by Honeywell(1)

Fiskars(1)

Sheffield(1)

MSA(1)

Great Neck(1)

ALTA(1)

Iwatani(1)

Keeper(1)

Klein Tools(1)

Enforcer(1)

 
Height

12"(3)

42.5"(2)

46"(2)

8"(2)

18.8"(2)

5 1/2"(2)

1 3/4"(1)

5.4"(1)

4 1/2"(1)

16 1/2"(1)

1 3/5"(1)

9.25"(1)

1.25"(1)

14"(1)

10 1/5"(1)

13.5"(1)

3"(1)

14.13"(1)

18.9"(1)

7"(1)

20.25"(1)

23.5"(1)

15 3/10"(1)

4"(1)

26"(1)

22.5"(1)

22.25"(1)

16"(1)

15"(1)

3.5"(1)

25"(1)

 
Color(s)

White(22)

Black(11)

Clear(11)

Steel Gray(10)

Gray(5)

Blue(4)

Yellow/Black(4)

Stainless Steel/White(3)

Red(3)

Yellow/Red(3)

Natural White(2)

Clear/Green(2)

Orange(2)

Clear/White(1)

Gray/Natural(1)

Light Gray(1)

Gray/Brass(1)

Green/Black(1)

Brown(1)

Black/Silver/Brass(1)

Red/Black(1)

Black/Brass(1)

Black/Orange(1)

Black/Yellow(1)

White/Gold(1)

Yellow(1)

Yellow/Navy(1)

Black/Clear(1)

 
Depth

5.75"(3)

6"(2)

8"(2)

5"(2)

18.7"(2)

1"(2)

4.25"(2)

17.1"(1)

2 3/4"(1)

2"(1)

10"(1)

42"(1)

0.88"(1)

15"(1)

10.88"(1)

11.13"(1)

1 5/8"(1)

 
Size

4" x 9"(2)

4 x 0.78(1)

4 5/8" x 10"(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)

Box(4)

Bottle(3)

Spray Bottle(2)

Wall-Mountable Plastic Storage Rack(1)

Storage Case(1)

Carded Pack(1)

 
Diameter

1.25"(2)

8"(2)

5"(2)

4.6"(2)

1"(1)

4 3/4"(1)

16"(1)

13.75"(1)

14.5"(1)

7.8"(1)

 
 
 

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