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

Currently Filtered by

Keyword

Industrial Shelves

Refine Search

  GO
Category Filter

Shelving Units/Bookcases(14)

File Shelves/Components(9)

Shelving Parts(8)

Carts(8)

Industrial & Commercial Shelving(6)

Wire Shelving(5)

Storage Cabinets(3)

Replacement Shelves(2)

Furniture(2)

Armoires & Cabinets(1)

Brand

Safco(25)

Alera(16)

LUXOR(8)

Tennsco(3)

Color

Black(14)

Silver(8)

Dark Gray|808080(7)

Metallic(7)

Black|000000(6)

Silver|C0C0C0(2)

Gray|808080(2)

Sand(2)

(1)

Medium Gray(1)

Recycled

No(11)

Height

72"(4)

85"(4)

1.5"(3)

Width

36"(6)

48"(5)

Depth

18"(7)

24"(3)

12"(1)

Size

48" x 18" x 1.5"(2)

48" x 18" x 85"(1)

36" x 18" x 85"(1)

36" x 24" x 85"(1)

48" x 24" x 85"(1)

48" x 12" x 85"(1)

36" x 12" x 85"(1)

36 x 24"(1)

48" x 18" x 72"(1)

48" x 24" x 72"(1)

36 x 18"(1)

Overall Width

48"(12)

36"(12)

Overall Depth

24"(13)

18"(11)

Assembled Dimension

19x36x14(2)

35x7x19(1)

22x7x34(1)

19X36X9(1)

19X36X13(1)

49x32x5(1)

Country

US(4)

CN(4)

Environmental Certification

GREENGUARD(11)

Environmentally Friendly

Yes(11)

Features

Durable(5)

Leveling Glide(5)

Dust Proof(3)

Adjustable Feet(2)

Adjustable Leveler(2)

Adjustable Shelf(1)

Adjustable Glide(1)

Product Name

Industrial Wire Shelving Add-On Unit(4)

Industrial Shelf(4)

Industrial Wire Extra Shelve(2)

Extra Shelf Pack(1)

Special Features

Up to 1,250 lbs. per shelf (evenly distributed).(8)

Up to 1,000 lbs. per shelf (evenly distributed).(8)

Snap-Together Clips(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved