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') 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

Samsill(5)

deflecto(5)

Rolodex(5)

SteelMaster(3)

Snap-N-Store(3)

Oxford(2)

Kantek(1)

Vaultz(1)

Durable(1)

 
Warranty

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

 
Special Features

Double Drawer(2)

Eight-Pocket Countertop(1)

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

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

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

 
For Use With

Index Cards(2)

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

Business Card Sleeve Refill ROL67691(1)

TELINDEX Cards (DBL241902)(1)

 
Manufacturer Part Number

62522(1)

66700(1)

23330(1)

01581(1)

01461(1)

66704(1)

67236(1)

81240(1)

81270(1)

81220(1)

81080(1)

80850(1)

263F5816DBLA(1)

263F4616DBLA(1)

70841(1)

90804(1)

70801(1)

70601(1)

70101(1)

SNS01573(1)

SNS01577(1)

263855BLA(1)

AD-30(1)

VZ01171(1)

SNS01647(1)

241301(1)

 
Country of Origin

CN(22)

US(3)

PL(1)

 
Height

2"(3)

5 1/4"(2)

3 3/8"(2)

5 5/64"(1)

5 3/8"(1)

4 3/8"(1)

11 1/8"(1)

7 3/4"(1)

10"(1)

3"(1)

6"(1)

10 1/8"(1)

5 7/8"(1)

3 3/4"(1)

9 3/4"(1)

1 13/16"(1)

3 1/4"(1)

4 1/4"(1)

6 1/2"(1)

3 9/16"(1)

5"(1)

7 1/2"(1)

 
Width

4"(3)

7"(2)

4 3/4"(2)

6 1/2"(2)

7 7/8"(2)

8 5/8"(2)

5 1/2"(1)

10 1/4"(1)

5 3/4"(1)

4 1/4"(1)

18 3/8"(1)

5"(1)

3 15/16"(1)

8 1/2"(1)

5 3/8"(1)

6 3/8"(1)

3 7/8"(1)

8 3/8"(1)

14 7/8"(1)

 
Depth

9"(3)

4 7/8"(2)

2"(2)

3 1/2"(2)

16"(2)

5 39/64"(1)

6 3/4"(1)

6 3/8"(1)

1 7/8"(1)

1 5/8"(1)

1 3/8"(1)

3 7/8"(1)

5"(1)

9 5/16"(1)

5 3/16"(1)

 
Color(s)

Black(18)

Clear(5)

Ebony(1)

Black/Graphite(1)

Mahogany(1)

 
Material(s)

Plastic(8)

Metal(3)

Leather(3)

Steel(3)

Fiberboard(3)

Solid Wood(2)

Vinyl/Brass(1)

Aluminum/Chrome/Laminate/Plywood(1)

Acrylic(1)

Vinyl(1)

 
Card Capacity

400(4)

200(3)

1,100(3)

50(3)

3,000(2)

500(2)

25(1)

160(1)

96(1)

120(1)

625(1)

480(1)

450(1)

80(1)

250(1)

 
For Card Size

Business Card(7)

2" x 3 1/2"(5)

5" x 8"(4)

4" x 6"(4)

2 1/4" x 4"(3)

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)

Business Card Book(2)

Business Card Binder(2)

Open Rotary Business Card File(2)

Card File With Pull Drawer(2)

Business Card Wallet(1)

Open Tray Business Card File(1)

Open Rotary Card File(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved

Powered by SITS Erp