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

Currently Filtered by

Category

Imaging Units

Refine Search

  GO
 
Brand

Xerox(10)

Oki(3)

Lexmark(2)

Canon(1)

Dell(1)

HP(1)

 
Packaged Quantity

1 Each(16)

1(1)

 
Limited Warranty

90 Day(4)

2 Year(2)

 
Compatibility

Xerox Printers:

  • Phaser 6510
  • WorkCentre 6515
(4)

Xerox Phaser 7400 Printer(2)

Canon imageClass LBP160 Series Printer(1)

Dell Printers:

  • 815dw
  • H815dw
  • S2810
  • S2810dn
(1)

HP Color LaserJet Printers:

  • 4700
  • 4700dn
  • 4700dtn
  • 4700n
  • 4730
  • 4730x
  • 4730xm
  • 4730xs
  • CM4730
  • CM4730f
  • CM4730fm
  • CM4730fsk
  • CP4005dn
  • CP4005n
(1)

Lexmark Printers:

  • T65x
  • X654e
  • X656e
  • X658e
(1)

Lexmark Printers:

  • MB2770adhwe
  • MS821dn
  • MX822adxe
  • MX826ade
  • B2865dw
  • MS821n
  • MX822ade
  • MX826adxe
  • MS823dn
  • MX721ade
  • MS825dn
  • MS822de
  • MS826de
  • MS823n
  • MX722adhe
  • MS725dvn
  • MX721adhe
  • MX722ade

(1)

  • OKI B4400 Printer
  • OKI B4600 Printer
(1)

Okidata Printers:

  • C712Dn
  • 712N
(1)

Okidata Printers:

  • C712dn
  • C712n
(1)

Xerox Phaser Printers:

  • 7750
  • EX7750
(1)

Xerox Phaser Printers:

  • 6360
  • 6300
  • 6350
(1)

Xerox Phaser 7760 Color Printer

(1)

 
Print Technology

Laser(16)

LED(2)

 
Print Color

Black(6)

Magenta(3)

Cyan(2)

Yellow(2)

Color(1)

 
Typical Print Yield

48000(4)

30000(4)

35000(2)

23000 Pages(1)

85000(1)

300000(1)

150000 Pages(1)

25000(1)

20000Black(1)

 
Package Type

OEM(1)

 
Device Supported

Printer(6)

 
Input Voltage

110 V AC(1)

120 V AC(1)

 
Manufacturer Part Number

CRTDG051DRUM(1)

108R00648(1)

108R01419(1)

108R01418(1)

108R01417(1)

108R00713(1)

108R00691(1)

108R00649(1)

108R00645(1)

35C7V(1)

108R00581(1)

46507403(1)

46507402(1)

43501901(1)

40X4724(1)

Q7504A(1)

108R01420(1)

 
Country of Origin

China(8)

Vietnam(5)

Thailand(3)

Japan(2)

 
 
 

© 2020-2021 LOP Office Supply, All Rights Reserved