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

Currently Filtered by

Category

Printer Accessories

Refine Search

  GO
 
Brand

HP(9)

Brother(2)

Lexmark(2)

Epson(1)

Ricoh(1)

 
Color(s)

Black(1)

 
Quantity

1(1)

 
Manufacturer Part Number

LT330CL(1)

LT340CL(1)

C12C815331(1)

A2W80A(1)

A7W99A(1)

B3M73A(1)

CE248A(1)

CE860A(1)

CF404A(1)

D9P29A(1)

F2A72A(1)

P1B10A(1)

36S2910(1)

36S3110(1)

841276(1)

 
Country of Origin

CN(11)

MY(1)

VN(1)

PH(1)

JP(1)

 
For Use With

HLL8260CDW; HLL8360CDW; HLL8360CDWT; HLL9310CDW; MFCL8610CDW; MFCL8900CDW; MFCL9570CDW(1)

HLL8360CDW; HLL8360CDWT; HLL9310CDW; MFCL8900CDW; MFCL9570CDW(1)

Stylus Pro 7900; Stylus Pro 9900(1)

HP Color LaserJet Enterprise flow M880z MFP, HP Color LaserJet Enterprise flow M880z+ NFC/Wireless Direct MFP, HP Color LaserJet Enterprise M855dn Printer, HP Color LaserJet Enterprise M855x+ NFC/Wireless Direct Printer, HP Color LaserJet Enterprise M855xh Printer(1)

HP PageWide Color MFP 774dn, 774dns, 779dn, 779dns; PageWide Enterprise Color Flow MFP 785z+, 785zs; PageWide Enterprise Color MFP 780dn, 780dns; PageWide Pro 777z Multifunction Printer; PageWide Color 755dn; PageWide Enterprise Color 765dn(1)

HP LaserJet Enterprise Flow MFP M630z; HP LaserJet Enterprise MFP M630f; MFP M630h(1)

HP CM 4540/4555(1)

HP LaserJet CP5525/5225 Series(1)

HP Color LaserJet Pro M452 Series(1)

HP LaserJet Pro M402 Series(1)

HP LaserJet Enterprise M506dh, M506dn, M506n, M506x(1)

HP Color LaserJet Enterprise M652n (J7Z98A), M652dn (J7Z99A), M653dn (J8A04A), M653dh (J8A06A); Color LaserJet Enterprise MFP M681dh (J8A10A); Color LaserJet Enterprise Flow MFP M681f (J8A12A); Color LaserJet Managed E65050dn (L3U55A), E65060dn (L3U56A); Color LaserJet Managed MFP E67550dh (L3U66A); Color LaserJet Managed Flow MFP E67560z (L3U70A)(1)

Lexmark B2338 dw,B2442dw, B2546dw, B2650dw, MB2338adw, MB2442adwe, MB2546adwe, MB2650adwe, MS321dn, MS421dn, MS421dw, MS521dw, MS621dn, MS622de, MX321adn, MX321adw, MX421ade, MX521ade, MX521de, MX522adhe, MX622ade, MX622adhe(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)

Ricoh Aficio MP C2800, C3300, C3333, LD533C(1)

 
Device Types

Copier(1)

 
Supply Type

Toner(1)

 
Sheet Capacity

550(6)

500(4)

250(2)

 
Accessory Type

Paper Tray(8)

Feeder Tray(2)

Cutter Blade(1)

Stapler/Stacker(1)

Input Tray(1)

Cleaning Sheets(1)

 
Number of Trays

1(10)

 
Dimensions

26 9/10" x 26 3/10" x 43"(1)

20.24" x 15.59" x 6.3"(1)

11 9/50" x 19 57/100" x 22 95/100"(1)

15" x 14 3/50" x 5 1/10"(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)

 
Page-Yield

20,000(1)

 
Accepts Paper Size

Legal; Letter(2)

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

8 1/2" x 13"; 11" x 17"; 12" x 18"; Executive; Legal; Letter; Letter-R(1)

A4; Letter(1)

A4 to Legal(1)

A6 to Legal(1)

 
Remanufactured

No(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved