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 (`category_id` IN ('803')) 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 ('ShelvingParts' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ShelvingParts' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ShelvingParts"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ShelvingParts"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ShelvingParts"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ShelvingParts"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ShelvingParts' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ShelvingParts',`category_4` ='ShelvingParts') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ShelvingParts,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ShelvingParts', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Shelving Parts

Refine Search

  GO
Brand

Alera(24)

Tennsco(9)

San Jamar(2)

HamiltonBuhl(1)

Safco(1)

Color

Silver(9)

Black(9)

Clear(5)

Medium Gray(2)

Sand(2)

Light Gray(2)

Putty(2)

Mahogany(1)

Espresso(1)

Cherry(1)

Modern Walnut(1)

Pebble Gray(1)

Overall Width

36"(8)

48"(6)

15.75"(4)

12"(3)

56"(1)

18"(1)

24"(1)

1"(1)

Overall Depth

24"(11)

18"(10)

9.88"(4)

12"(2)

25.5"(1)

1"(1)

14"(1)

Country of Origin

CN(24)

US(12)

Material(s)

Steel Wire(8)

Plastic(7)

Wire(4)

Laminated(2)

Metal(2)

Steel(1)

Woodgrain Laminate(1)

Textured Woodgrain Laminate(1)

Metal Mesh(1)

For Use With

ALE-SW Series(8)

ALE-SW50;SW58(8)

24" Deep Deluxe Storage Cabinet(5)

18" Deep Deluxe Storage Cabinet(4)

Alera Wire Shelving Units(3)

Capacity (Weight)

20 lbs.(1)

Shelf Count

2(8)

Shelf Capacity (Weight)

1,000 lbs.(4)

1,250 lbs.(4)

Overall Height

10.88"(4)

1/4"(1)

0.25"(1)

7.75"(1)

1.5"(1)

Series Name

Alera Valencia Series(4)

Versa-Mat(2)

Mayline Kwik-File Mailflow-To-Go Mailroom System(1)

Alera Wire Shelving(1)

Special Features

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

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

Allows you to easily add on shelves or half-height shelf units. Levelers for uneven floor. Combine two posts for 72" high shelving.(2)

Per Bar Attaches to 18" Deep Shelf(1)

Per Bar Attaches to 24" Deep Shelf.(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved