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

Currently Filtered by

Category

Card Holders

Refine Search
  GO
 
Brand

Rolodex(5)

deflecto(5)

Samsill(5)

Snap-N-Store(3)

SteelMaster(3)

Oxford(2)

C-Line(1)

Durable(1)

Vaultz(1)

Kantek(1)

 
Warranty

Manufacturer's warranty against defects.(1)

Manufacturer's one-year limited warranty.(1)

 
Special Features

Double Drawer(2)

Assorted Colors-Keep your index cards neat and organized in attractive pink, blue, purple and teal card cases.(1)

Six-Pocket Wall Mount-Holds approximately 80 cards per pocket.(1)

Eight-Pocket Countertop-Holds approximately 50 cards per pocket.(1)

Four-Pocket Countertop-Holds approximately 50 cards per pocket.(1)

Eight-Pocket Countertop(1)

 
For Use With

Index Cards(2)

TELINDEX Cards (DBL241902)(1)

Business Card Sleeve Refill ROL67691(1)

5 3/4" x 7 3/4" Refill Pages(1)

 
Manufacturer Part Number

58435(1)

263F5816DBLA(1)

81240(1)

81220(1)

81080(1)

80850(1)

67236(1)

66704(1)

66700(1)

62522(1)

23330(1)

01581(1)

01461(1)

263F4616DBLA(1)

241301(1)

263855BLA(1)

AD-30(1)

VZ01171(1)

SNS01647(1)

SNS01577(1)

SNS01573(1)

90804(1)

70841(1)

70801(1)

70601(1)

70101(1)

81270(1)

 
Country of Origin

CN(23)

US(3)

PL(1)

 
Height

5 1/4"(3)

2"(3)

3 3/8"(2)

6"(1)

10"(1)

3"(1)

11 1/8"(1)

10 1/8"(1)

5 5/64"(1)

5 3/8"(1)

4 3/8"(1)

6 1/2"(1)

7 1/2"(1)

3 9/16"(1)

5 7/8"(1)

5"(1)

4 1/4"(1)

3 1/4"(1)

3 3/4"(1)

9 3/4"(1)

1 13/16"(1)

7 3/4"(1)

 
Width

4"(3)

8 5/8"(2)

7 7/8"(2)

4 3/4"(2)

6 1/2"(2)

7"(2)

4 1/4"(1)

10 1/4"(1)

5 1/2"(1)

18 3/8"(1)

14 7/8"(1)

3 1/2"(1)

5"(1)

8 3/8"(1)

6 3/8"(1)

5 3/8"(1)

3 15/16"(1)

8 1/2"(1)

3 7/8"(1)

5 3/4"(1)

 
Depth

9"(3)

3 1/2"(2)

16"(2)

4 7/8"(2)

2"(2)

4 1/2"(1)

9 5/16"(1)

1 3/8"(1)

1 5/8"(1)

3 7/8"(1)

5"(1)

1 7/8"(1)

5 3/16"(1)

6 3/8"(1)

6 3/4"(1)

5 39/64"(1)

 
Color(s)

Black(18)

Clear(5)

Assorted(1)

Black/Graphite(1)

Mahogany(1)

Ebony(1)

 
Material(s)

Plastic(8)

Fiberboard(3)

Steel(3)

Metal(3)

Leather(3)

Solid Wood(2)

Polypropylene(1)

Aluminum/Chrome/Laminate/Plywood(1)

Acrylic(1)

Vinyl(1)

Vinyl/Brass(1)

 
Card Capacity

400(4)

200(3)

50(3)

1,100(3)

3,000(2)

500(2)

100(1)

480(1)

450(1)

80(1)

625(1)

250(1)

160(1)

25(1)

96(1)

120(1)

 
For Card Size

Business Card(7)

2" x 3 1/2"(5)

4" x 6"(4)

5" x 8"(4)

2 1/4" x 4"(3)

3 x 5(1)

3" x 5"(1)

1 3/4 x 3 1/4(1)

2 5/8" x 4"(1)

 
Card Holder Type

Business Card Holder(8)

Card File Box With Hinged Lid(4)

Card File Box With Lift-Off Lid(3)

Card File With Pull Drawer(2)

Open Rotary Business Card File(2)

Business Card Book(2)

Business Card Binder(2)

Index Card(1)

Open Tray Business Card File(1)

Open Rotary Card File(1)

Business Card Wallet(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved

Powered by SITS Erp