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

Currently Filtered by

Category

Catalog Reference Racks

Refine Search
  GO
Brand

Durable(17)

Durable Sherpa(2)

Safco(1)

Fellowes(1)

Height

18 5/8"(1)

20 1/4"(1)

5.1"(1)

13"(1)

17.3"(1)

12 3/4"(1)

16 1/2"(1)

Color(s)

Gray(9)

Blue/Gray;Clear(2)

Black(2)

Platinum(1)

Gray/Black(1)

Black;Clear(1)

Graphite(1)

Assorted(1)

Width

21 1/8"(2)

18 1/4"(2)

11 3/8"(2)

20 7/8"(2)

9 3/4"(2)

10 1/2"(2)

21 1/4"(2)

Depth

14 1/2"(2)

7 1/8"(1)

6"(1)

11"(1)

11 3/4"(1)

15 1/8"(1)

Country of Origin

DE(16)

PL(2)

DK(1)

CN(1)

TW(1)

Material(s)

Polypropylene(8)

Metal(4)

Polypropylene;PVC(2)

Polypropylene pockets, Steel(1)

Plastic(1)

Heavy-Gauge Steel(1)

PVC;Polypropylene(1)

For Use With

InstaView Unit(2)

DBL-5542-00;DBL-5542-10(1)

Flat surfaces up to 3 1/2" thick(1)

Sheet Capacity

20(15)

10(3)

24(1)

48(1)

40(1)

Mounting

Desktop(10)

Wall(5)

Desk(3)

Free Standing(1)

Wall Or Desk(1)

Desk Clamp(1)

Number of Compartments

10(16)

5(2)

12(1)

40(1)

20(1)

Rack Style

Reference(9)

Desktop(2)

Wall System(1)

Desktop;Starter Set(1)

Starter Set;Desktop(1)

Rotary; Literature Display(1)

Rotary;Literature Display(1)

Rack Features

Expandable;Snap-On Index Tabs;Weighted Base(2)

10 Snap-On Tabs;Extension Connectors;Non-Glare Panels(2)

Snap-On Index Tabs(2)

Antimicrobial Surface--Protected Sleeves(1)

Antimicrobial Surface-Protected Sleeves(1)

Magnetic(1)

Can also be used as expansion set to Durable 536000 and Durable 536100(1)

Border Color(s)

Black; Blue; Green; Red; Yellow(4)

Black;Blue;Green;Red;Yellow(4)

Assorted(2)

Blue/Gray(2)

Black(2)

Gray(1)

Black; Blue; Red; Green; Yellow(1)

Tilt (Degrees)

30 degrees or 60 degrees(2)

45 degrees(1)

25 degrees to 70 degrees(1)

Compartment Size

Letter(17)

1"(1)

Index

Snap-On Index Tabs(1)

Compartment Types

Double-Sided Letter(6)

Double-Sided Letter;Panels(3)

Pockets(1)

Sleeves(1)

Compartment Capacity

20 Sheets(15)

10 Sheets(3)

Catalogs up to 1" Thick(1)

48 Sheets(1)

40 Sheets(1)

Catalog Reference Rack Accessories Type

Panels(1)

Rack Part

Extension Module(1)

Special Features

Assorted Borders-Two each black, blue, green, red and yellow.(2)

Assorted Panels-Two each: black, blue, green, red and yellow; includes snap-on tabs.(2)

Black Borders(2)

Desk Mounted(2)

Magnetic System-Affixes to metal surfaces with strong, sturdy magnet on back of bracket, yet removes easily to protect confidential information. Assorted borders-one each: red, black, yellow, green and dark blue(1)

Wall Mounted(1)

Assorted Borders-Two each of black, blue, green, red and yellow.(1)

Assorted Borders-Two each: black, blue, green, red and yellow; includes snap-on tabs. Extension set: DBL-569800.(1)

Assorted Panels-Four each: black, blue, green, red and yellow. Includes snap-on tabs.(1)

Gray Borders(1)

Gray Borders-Includes snap-on tabs. Extension set: DBL-569810.(1)

Assorted Borders-One each black, dark blue, green, red and yellow.(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor

© 2019-2020 United Supply Corp, All Rights Reserved

Powered by SITS Erp