Banner1 Banner1
 
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(7)

Oki(6)

HP(5)

Xerox(5)

Sharp(4)

Samsung(4)

Panasonic(3)

Innovera(3)

Toshiba(2)

MSE(2)

TallyGenicom(2)

InfoPrint Solutions Company(1)

Dataproducts(1)

Brother(1)

Ricoh(1)

Muratec(1)

 
Color(s)

Black(34)

Magenta(3)

Yellow(3)

Cyan(2)

Cyan; Magenta; Yellow(1)

 
Manufacturer Part Number

411113(1)

UG5520(1)

CLT-R407(1)

CLT-R409(1)

MLT-R309(1)

UG5510(1)

KX-FAD93(1)

43913804(1)

43979001(1)

44574309(1)

56120801(1)

SCX4720D3(1)

AL200TDU(1)

113R00667(1)

113R00670(1)

113R317(1)

113R482(1)

013R00603(1)

T1900(1)

AR455NT(1)

FO45ND(1)

FO50ND(1)

OD170F(1)

43913802(1)

43913801(1)

53P9397(1)

732026504(1)

AL100DR(1)

ML2010(1)

CE314A(1)

CB387A(1)

DPCDR510(1)

CB384A(1)

CB385A(1)

CB386A(1)

C540X31G(1)

C540X32G(1)

084550(1)

58033614(1)

58034014(1)

DK120(1)

083286(1)

E250X42G(1)

C540X33G(1)

C540X34G(1)

C930X82G(1)

C930X83G(1)

DR620(1)

 
Country of Origin

CN(19)

JP(11)

US(6)

MX(4)

TH(4)

KR(2)

MY(1)

VN(1)

 
Device Types

Laser Printer(25)

Fax(8)

Copier(6)

Multifunction Laser Printer(5)

Printer(4)

 
Supply Type

Drum(15)

Drum Unit(8)

Toner(7)

Developer Unit(4)

Toner/Drum(4)

Photoconductor(3)

Toner/Developer(2)

Toner/Drum/Developer(1)

Drum/Photodeveloper(1)

Imaging Unit(1)

 
Replacement For

DR360(1)

DR400(1)

ML-2010(1)

AL100DR(1)

UG5510(1)

DR510(1)

 
Page-Yield

30000(8)

23000(6)

6000(5)

20000(4)

9000(3)

25000(2)

60000(2)

12000(2)

3000(2)

6500(1)

35000(1)

10000(1)

90000(1)

3500(1)

80000(1)

24000(1)

47000(1)

14000B/7000C(1)

18000(1)

45000(1)

53000(1)

 
Coverage Percent

5%(30)

3%(2)

6%(2)

 
Remanufactured

No(41)

Yes(6)

 
 
 

© 2018-2019 Onestop, Inc., All Rights Reserved