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

Currently Filtered by

Category

Drums Photo Developers W Toner

Refine Search

  GO
 
Brand

Lexmark(6)

Xerox(5)

HP(5)

Panasonic(3)

Samsung(3)

Oki(2)

TallyGenicom(2)

Toshiba(2)

Sharp(1)

Muratec(1)

Dataproducts(1)

InfoPrint Solutions Company(1)

Brother(1)

Ricoh(1)

 
Color(s)

Black(22)

Yellow(3)

Cyan(2)

Cyan; Magenta; Yellow(1)

Magenta(1)

 
Manufacturer Part Number

411113(1)

CLT-R407(1)

CLT-R409(1)

UG5520(1)

UG5510(1)

44574309(1)

KX-FAD93(1)

MLT-R309(1)

AR455NT(1)

013R00603(1)

113R00670(1)

113R317(1)

006R00978(1)

006R00975(1)

OD170F(1)

T1900(1)

43979001(1)

DK120(1)

CB387A(1)

CE314A(1)

53P9397(1)

CB386A(1)

CB385A(1)

DPCDR510(1)

CB384A(1)

C540X31G(1)

C540X32G(1)

083286(1)

084550(1)

E250X42G(1)

C930X83G(1)

C540X34G(1)

C930X82G(1)

DR620(1)

 
Country of Origin

CN(18)

JP(5)

MX(3)

NL(2)

US(2)

KR(2)

TH(1)

MY(1)

 
Device Types

Laser Printer(16)

Fax(5)

Multifunction Laser Printer(5)

Printer(3)

Copier(3)

Printer/Copier(2)

 
Supply Type

Drum Unit(18)

Toner(6)

Photoconductor Unit(3)

Developer Unit(3)

Toner and Drum Unit(2)

Toner, Drum and Developer Unit(1)

Photodeveloper(1)

 
Replacement For

DR510(1)

 
Page-Yield

23000(5)

30000(4)

6000(4)

25000(3)

20000(3)

35000(1)

10000(1)

90000(1)

60000(1)

80000(1)

39000(1)

9000(1)

53000(1)

14000B/7000C(1)

47000(1)

12000(1)

45000(1)

24000(1)

 
Remanufactured

No(32)

Yes(1)

 
 
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved