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

Currently Filtered by

Category

ID Cards

Refine Search

  GO
 
Brand

HP(18)

Brother(6)

Epson(3)

Lexmark(3)

 
Color

Black(1)

 
Packaged Quantity

1(3)

 
Assembly Required

No(1)

 
Compatibility

Brother HL-S7000DN Printer(2)

 
Dimensions

16.7 x 18.3 x 5.8(2)

24"(1)

26.9 x 26.3 x 43(1)

23 x 8 x 22.63(1)

11.18 x 19.57 x 22.95(1)

7.16 x 4.6 x 4.6(1)

57 9/10" x 22" x 27 1/5"(1)

45 9/10" x 6 9/10" x 6 9/10"(1)

63.8 x 6.9 x 6.9(1)

15 x 14.06 x 5.1(1)

26 x 25.9 x 18.8(1)

20.08 x 18.03 x 5.12(1)

25.87 x 25.87 x 17.72(1)

3.7 x 15.7 x 14.7(1)

15.7 x 14.7 x 5(1)

4.33 x 16.57 x 20.08(1)

 
For Use With

HP LaserJet Enterprise M607n, M607dn, M608n, M608dn, M608x, M609dn, M609dh, M609x; LaserJet Managed E60055dn, E60065dn, E60065x, E60075dn, E60075x(2)

Brother HL-L3295CDW, L8245CDW; MFC-L3780CDW, L8395CDW(1)

HP Designjet Z6200(1)

Lexmark B2338dw, B2442dw, B2546dn, B2546dw, B2650dn, B2650dw, MB2338adw, MB2442adwe, MB2546adwe, MB2650adwe, MS321dn, MS421dn, MS421dw, MS521dn, MS621dn, MS622de, MX321adn, MX321adw, MX421ade, MX521ade, MX521de, MX522adhe, MX622adhe, MX622ade(1)

Lexmark B2338dw, B2442dw, B2546dw, B2650dw, MB2338adw, MB2442adwe, MB2546adwe, MB2650adwe, MS321dn, MS421dn, MS421dw, MS521dw, MS621dn, MS622de, MX321adn, MX321adw, MX421ade, MX521ade, MX521de, MX522adhe, MX622ade, MX622adhe(1)

HP Color LaserJet Enterprise flow MFP M577c, M577z; Color LaserJet Enterprise MFP M577dn, M577f; Color LaserJet Managed flow MFP M577cm; Color LaserJet Managed MFP M577dnm; LaserJet Enterprise flow MFP M527c, M527z; LaserJet Enterprise MFP M527dn, M527f; LaserJet Managed flow MFP M527cm; LaserJet Managed MFP M527dnm; PageWide Enterprise Color MFP 586dn, 586f; PageWide Enterprise Color flow MFP 586z; PageWde Managed Color MFP E58650dn; PageWide Managed Color Flow MFP E58650z(1)

HP Color LaserJet Enterprise M652n, M652dn, M653dn, M653dh; Color LaserJet Enterprise MFP M681dh; Color LaserJet Enterprise flow MFP M681f; Color LaserJet Managed E65050dn, E65060dn; Color LaserJet Managed MFP E67550dh; Color LaserJet Managed flow MFP E67560z(1)

HP Color LaserJet Enterprise M652n, M652dn, M653dn, M653x, M653dh; Color LaserJet Enterprise MFP M681dh, M681f; Color LaserJet Managed E65050dn, E65060dn; Color LaserJet Managed MFP E67550dh; Color LaserJet Managed flow MFP E67560z(1)

HP LaserJet Enterprise MFP M631dn, M631z, M632h, M632fht, M633fh, M633z; LaserJet Enterprise flow MFP M631h, M632z; LaserJet Managed MFP E62555dn, E62565hs; LaserJet Managed flow MFP E62565h, E62565z, E62575z(1)

HP LaserJet Pro M402 Series(1)

HP Designjet T920, T1500(1)

Brother HL-L8260CDW, HL-L8360CDW, HL-L8360CDWT, HL-L9310CDW, MFC-L8610CDW, MFC-L8900CDW, MFC-L9570CDW(1)

HP Color LaserJet Pro M452 Series(1)

HP LaserJet Enterprise M553dn, M553n, M553x(1)

HP Color LaserJet Enterprise flow M880z MFP, M880z+ MFP; Color LaserJet Enterprise M855dn, M855x+, M855xh(1)

HP DesignJet Z6, Z9(1)

HP Designjet T200/T600 Series Printers(1)

Epson EcoTank Photo ET-8500, ET-8550, EcoTank Pro ET-16600, WorkForce EC-C7000, ST-C8000, ST-C8090, WorkForce Pro WF-7310, WF-7820, WF-7840(1)

Epson Stylus Pro 7900, 9900(1)

Epson Stylus Pro 4000 Series Printers(1)

Brother HL-L8360CDW, HL-L8360CDWT, HL-L9310CDW, MFC-L8900CDW, MFC-L9570CDW(1)

Lexmark B2865dw, MB2770adwhe, MS725dvn, MS821dn, MS821n, MS822de, MS823dn, MS823n, MS825dn, MS826de, MX721ade, MX721adhe, MX722ade, MX722adhe(1)

 
Media Type

Plain Paper(2)

 
Accepts Paper Size

Legal; Letter(3)

3.9 x 5.83 to 8.5 x 14(3)

Up to 42" Sheet Rolls(2)

A4; A5; Executive; Folio; JIS B5; Legal; Letter; Oficio; Statement(2)

8.5 x 13; 11 x 17; 12 x 18; Executive; Legal; Letter; Letter-R(1)

4 x 6 to 8.5 x 14(1)

Up to 60" Sheet Rolls(1)

3.5 x 6.3 to 7 x 10(1)

A6 to Legal(1)

A4; A5; A6; Executive; Folio; JIS B5; Legal; Letter; Oficio; Statement(1)

 
Media Capacity

500 Sheet(2)

 
Total Media Capacity

500(2)

 
Country of Origin

CN(16)

MY(4)

VN(2)

China(2)

PH(2)

Japan(1)

JP(1)

ID(1)

SG(1)

 
Color(s)

Silver/Black(1)

 
Quantity

1 each(4)

 
Sheet Capacity

550(10)

500(2)

250(2)

250-Sheet(1)

75(1)

 
Accessory Type

Paper Tray(6)

Media Spindle(4)

Lower Paper Tray(2)

Media Tray(2)

Feeder Tray(2)

Replacement Cutter Blade(1)

Ink Maintenance Box(1)

Printer Stand(1)

Multifunction Roll(1)

Stapler/Stacker(1)

Core Adapter(1)

Spindle(1)

Paper Feeder and Cabinet(1)

Envelope Feeder(1)

Paper Tray and Stand(1)

ADF Roller Replacement Kit(1)

 
Number of Trays

1(15)

 
Spindle Diameter

2"; 3"(4)

3"(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved