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

Currently Filtered by

Category

Catalog Reference Racks

Refine Search

  GO
Brand

Durable(22)

Tarifold, Inc.(20)

Durable Sherpa(2)

Fellowes(1)

Safco(1)

Height

13"(3)

16"(1)

12"(1)

20 1/4"(1)

5.1"(1)

12 3/4"(1)

16 1/2"(1)

18 5/8"(1)

Color(s)

Gray(9)

Black(5)

Clear(4)

Blue/Gray;Clear(2)

Assorted(2)

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

Silver(1)

Black;Green(1)

Black;Clear(1)

Graphite(1)

Platinum(1)

Depth

8"(2)

14 1/2"(2)

16"(1)

20"(1)

11"(1)

7 1/8"(1)

15 1/8"(1)

6"(1)

Manufacturer Part Number

D291(1)

D291F(1)

D292(1)

D3D71(1)

CD272(1)

CD271(1)

22300(1)

6175BL(1)

50410(1)

50411(1)

DA271(1)

DBL291(1)

TW271(1)

W290(1)

W291(1)

WA271(1)

TE271(1)

TDBL291(1)

P090(1)

PWB91(1)

R281(1)

TD271(1)

5951-10(1)

5950-10(1)

5534-00(1)

5539-01(1)

5539-37(1)

5541-00(1)

5515-00(1)

5362-00(1)

5358-10(1)

5359-00(1)

5360-00(1)

5361-00(1)

5542-00(1)

5542-10(1)

5698-10(1)

576200(1)

5943-06(1)

5944-06(1)

5698-00(1)

5612-01(1)

5552-00(1)

556900(1)

5612-00(1)

5357-10(1)

Country of Origin

DE(18)

US(10)

FR(9)

CN(4)

PL(3)

DK(1)

TW(1)

Width

23"(1)

8 1/2"(1)

19"(1)

16"(1)

14"(1)

18 1/4"(1)

10 1/2"(1)

20 7/8"(1)

11 3/8"(1)

21 1/8"(1)

21 1/4"(1)

Material(s)

Metal(15)

Polypropylene(10)

Poly(3)

Steel(2)

Acrylic(2)

Plastic(2)

Polypropylene;PVC(2)

Steel;Polypropylene(1)

Polypropylene pockets, Steel(1)

Metal;Plastic(1)

For Use With

Desktop Starter Set Desk Base(3)

Wall Unit Starter Set (TFI-W291);Wall Unit TFI-W291(3)

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

InstaView Unit(2)

Desktop Reference Organizer (TFITD271)(1)

Desktop Starter Set;Wall Unit Set(1)

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

Wall Mounted/Expansion Unit (TFI-TW271);Wall Mounted/Expansion Unit TFI-TW271(1)

Sheet Capacity

20(30)

10(4)

40(3)

125(2)

100(1)

12(1)

24(1)

Mounting

Desktop(24)

Wall(10)

Desk(3)

Partition Wall(2)

Wall Or Desk(2)

Desk;Wall(1)

Free Standing(1)

Desk Clamp(1)

Number of Compartments

10(36)

5(3)

20(3)

12(2)

6(2)

Rack Style

Reference(14)

Starter Set;Reference(3)

Starter Set;Desktop(2)

Desktop; Starter Set(2)

Starter Set;Catalog Display(2)

Desktop;Starter Set(2)

Starter Set; Reference(1)

Desktop; Reference(1)

Extension Unit; Starter Set; Reference(1)

Reference;Starter Set(1)

Stand;Desktop(1)

Desktop(1)

Rotary;Literature Display(1)

Rotary; Literature Display(1)

Reference;Rotary(1)

Rack Features

Snap-On Index Tabs(9)

Expandable; Snap-On Index Tabs; Non-Glare Panels(3)

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

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

Display Rotates 360°; Non-Glare Panels(1)

Expandable;Snap-On Index Tabs(1)

10 Snap-On Tabs;Depth Adjustable Bracket(1)

Compartment Width

9"(1)

8 3/4"(1)

Border Color(s)

Color-Coded(7)

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

Assorted(6)

Gray(5)

Black(3)

Green; Black(1)

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

Tilt (Degrees)

45°(3)

(1)

360°(1)

Compartment Height

12"(1)

11 1/8"(1)

Compartment Size

Letter(24)

A4(1)

Index

Snap-On Index Tabs(3)

Compartment Types

Wire-Reinforced Pocket(9)

Double-Sided Letter(7)

Double-Sided Letter;Panels(4)

Antimicrobial Pockets;Wire-Reinforced Pocket(2)

Wire-Reinforced Pocket;Foldout Sleeve(1)

Top Loading Sleeves(1)

Pockets(1)

Sleeves(1)

Panels(1)

Compartment Capacity

20 Sheets(32)

10 Sheets(5)

40 Sheets(3)

125 Sheets(2)

100 Sheets(1)

12 Sheets(1)

20 sheets(1)

24 Sheets(1)

Price Range

$0-$99.99(27)

$100-$199.99(18)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved