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 (`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_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 '%CatalogReferenceRacks' THEN 1 ELSE 0 END DESC, 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(18)

Safco(1)

Durable Sherpa(1)

Fellowes(1)

 
Height

18 5/8"(1)

20 1/4"(1)

5.1"(1)

13"(1)

12 3/4"(1)

16 1/2"(1)

 
Color(s)

Gray(9)

Black(3)

Blue/Gray;Clear(1)

Platinum(1)

Gray/Black(1)

Assorted(1)

Graphite(1)

Clear(1)

 
Depth

14 1/2"(2)

7 1/8"(1)

6"(1)

11"(1)

15 1/8"(1)

 
Manufacturer Part Number

576200(1)

5698-00(1)

566600(1)

5612-01(1)

5944-06(1)

5951-10(1)

6175BL(1)

22300(1)

595601(1)

5612-00(1)

556900(1)

5539-01(1)

5515-00(1)

5361-00(1)

5360-00(1)

5539-37(1)

5541-00(1)

5552-00(1)

5542-10(1)

5542-00(1)

5359-00(1)

 
Country of Origin

DE(15)

CN(2)

PL(2)

DK(1)

TW(1)

 
Width

21 1/8"(1)

18 1/4"(1)

11 3/8"(1)

20 7/8"(1)

10 1/2"(1)

8.5"(1)

21 1/4"(1)

 
Material(s)

Polypropylene(9)

Metal(4)

Polypropylene pockets, Steel(1)

Plastic(1)

Heavy-Gauge Steel(1)

Polypropylene;PVC(1)

Fiber(1)

 
For Use With

InstaView Unit(2)

DBL595010; DBL595110(1)

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

Durable SHERPA Vario Reference Systems(1)

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

 
Sheet Capacity

20(14)

10(3)

24(1)

2(1)

40(1)

 
Mounting

Desktop(10)

Wall(4)

Desk(2)

Free Standing(1)

Wall Or Desk(1)

Desk Clamp(1)

 
Number of Compartments

10(15)

5(3)

12(1)

1(1)

20(1)

 
Rack Style

Reference(9)

Desktop(2)

Desktop;Starter Set(1)

Rotary;Literature Display(1)

Rotary; Literature Display(1)

 
Rack Features

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

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

Snap-On Index Tabs(2)

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

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

Black(2)

Assorted(2)

Blue/Gray(1)

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

1"(1)

 
Index

1/5th Cut Catalog Rack Index(1)

Snap-On Index Tabs(1)

 
Compartment Types

Double-Sided Letter(7)

Double-Sided Letter;Panels(3)

Pockets(1)

Sleeves(1)

 
Compartment Capacity

20 Sheets(14)

10 Sheets(3)

Catalogs up to 1" Thick(1)

40 Sheets(1)

 
 
 
 
 

© 2019-2020 Office 8, All Rights Reserved

Powered by SITS Erp