Banner1 Banner1
 
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_36` 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

Tarifold, Inc.(17)

Durable(14)

Durable Sherpa(2)

Fellowes(1)

Safco(1)

 
Height

13"(3)

12"(1)

20 1/4"(1)

5.1"(1)

16 1/2"(1)

18 5/8"(1)

 
Color(s)

Gray(7)

Black(5)

Clear(3)

Black;Green(1)

Assorted(1)

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

Blue/Gray;Clear(1)

Graphite(1)

Platinum(1)

 
Depth

8"(2)

14 1/2"(2)

20"(1)

6"(1)

7 1/8"(1)

15 1/8"(1)

 
Manufacturer Part Number

D291F(1)

D292(1)

DA271(1)

D291(1)

CD272(1)

50411(1)

CD271(1)

DBL291(1)

P090(1)

W290(1)

W291(1)

WA271(1)

TW271(1)

TE271(1)

TD271(1)

TDBL291(1)

50410(1)

6175BL(1)

5539-37(1)

5541-00(1)

5542-00(1)

5539-01(1)

5515-00(1)

5360-00(1)

5361-00(1)

5542-10(1)

5552-00(1)

5944-06(1)

5951-10(1)

22300(1)

576200(1)

5698-00(1)

5612-00(1)

5612-01(1)

5359-00(1)

 
Country of Origin

DE(13)

US(8)

FR(7)

CN(3)

PL(2)

TW(1)

DK(1)

 
Width

14"(1)

23"(1)

16"(1)

18 1/4"(1)

21 1/8"(1)

20 7/8"(1)

11 3/8"(1)

21 1/4"(1)

 
Material(s)

Metal(11)

Polypropylene(7)

Poly(3)

Steel(2)

Acrylic(2)

Metal;Plastic(1)

Polypropylene pockets, Steel(1)

Polypropylene;PVC(1)

Plastic(1)

 
For Use With

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

Desktop Starter Set Desk Base(3)

InstaView Unit(2)

Desktop Reference Organizer (TFITD271)(1)

Desktop Starter Set;Wall Unit Set(1)

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

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

 
Sheet Capacity

20(22)

10(4)

40(3)

125(2)

100(1)

24(1)

 
Mounting

Desktop(21)

Wall(7)

Wall Or Desk(2)

Desk(2)

Free Standing(1)

 
Number of Compartments

10(26)

5(3)

20(3)

12(2)

6(1)

 
Rack Style

Reference(12)

Starter Set;Reference(3)

Starter Set;Catalog Display(2)

Reference;Starter Set(1)

Starter Set; Reference(1)

Desktop; Reference(1)

Extension Unit; Starter Set; Reference(1)

Stand;Desktop(1)

Rotary; Literature Display(1)

Desktop; Starter Set(1)

Desktop(1)

Rotary;Literature Display(1)

Desktop;Starter Set(1)

 
Rack Features

Snap-On Index Tabs(9)

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

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

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

Expandable; Non-Glare Panels(1)

Expandable;Snap-On Index Tabs(1)

 
Compartment Width

9"(1)

 
Border Color(s)

Color-Coded(7)

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

Assorted(4)

Black(3)

Green; Black(1)

Gray(1)

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

Blue/Gray(1)

 
Tilt (Degrees)

45(2)

5(1)

 
Compartment Height

12"(1)

 
Compartment Size

Letter(20)

 
Index

Snap-On Index Tabs(2)

 
Compartment Types

Wire-Reinforced Pocket(9)

Double-Sided Letter(6)

Double-Sided Letter;Panels(3)

Antimicrobial Pockets;Wire-Reinforced Pocket(2)

Pockets(1)

Wire-Reinforced Pocket;Foldout Sleeve(1)

 
Compartment Capacity

20 Sheets(24)

10 Sheets(4)

40 Sheets(3)

125 Sheets(2)

100 Sheets(1)

24 Sheets(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved