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

Currently Filtered by

Category

Maintenance Kits Supplies

Refine Search

  GO
 
Brand

HP(16)

Xerox(5)

Epson(4)

Innovera(3)

Lexmark(3)

 
Color(s)

Black(3)

 
Manufacturer Part Number

CB388A(2)

C9152A(2)

Q5421A(2)

C12C890191(1)

F2G76A(1)

109R00783(1)

108R00989(1)

108R00676(1)

108R00675(1)

78C0ZV0(1)

78C0ZK0(1)

40X8425(1)

L0H24A(1)

J8J87A(1)

CH644A(1)

CH649A(1)

C12C890501(1)

CF249A(1)

CF064A(1)

CE514A(1)

CB459A(1)

CB457A(1)

C9518A(1)

C2H67A(1)

C1N54A(1)

T619000(1)

T582000(1)

109R00784(1)

 
Country of Origin

CN(12)

JP(5)

MY(5)

US(3)

SG(3)

MX(3)

 
For Use With

Xerox ColorQube 8570, 8870(2)

Xerox Phaser 8500, 8550, 8560, 8560MFP(2)

Lexmark C2425dw; Lexmark C2535dw; Lexmark MC2425adw; Lexmark MC2535adwe; Lexmark MC2640adwe(2)

HP Color LaserJet 6015, CM6040MFP(2)

HP DesignJet T7100(1)

Lexmark MS81X, MX71X, MX81X, MS810DN, MS810DTN, MS810DE, MS811DN, MS811DTN, MX710DHE, MX711DHE, MX711DTHE(1)

HP LaserJet 4240, 4240N, 4250, 4350 Series(1)

HP LaserJet P4014 Series, P4015 Series, P4515 Series(1)

HP LaserJet 9000 Series, 9040 Series, 9050 Series(1)

HP LaserJet 4250 Series, 4350 Series(1)

HP LaserJet M607dn, M607n, M608dn, M608n, M608x, M609dh(1)

HP LaserJet Enterprise Flow MFP M631h, M631z, M633fh, M633z; LaserJet Enterprise MFP M623h, M632fht, M632z(1)

HP LaserJet Enterprise M604dn, M604n, M605dn, M605n, M605x, M606dn, M606x(1)

Epson Stylus Pro 4000, 4800, 7400, 7600, 7800, 9400, Pro 9600, 9800(1)

Epson Stylus Pro 7700, 9700(1)

HP Color LaserJet Enterprise CM4540 MFP Series, CP4025, CP4525(1)

HP LaserJet Enterprise 600 Series(1)

HP LaserJet Enterprise 700 Color MFP M775 Series(1)

HP LaserJet P4014n(1)

HP DesignJet Z6100 Series(1)

HP LaserJet 9000 Series, 9040 Series, 9050 Series, M9040 mfp, M9050 mfp(1)

HP Color LaserJet Enterprise flow M830 Multifunction Series(1)

HP Color LaserJet Enterprise flow M880 Multifunction Series(1)

Epson Stylus Pro 4900; SureColor P5000(1)

Epson Stylus Pro 3800, 3880(1)

HP DesignJet Z6200 Series, Z6600, Z6800 Series(1)

 
Device Types

Laser Printer(20)

Wide Format Inkjet Printer(8)

Multifunction Laser Printer(2)

Inkjet Printer(1)

 
Supply Type

Maintenance Kit(17)

Maintenance Tank(4)

Maintenance Cartridge(4)

Toner(2)

Maintenance Kit; Fuser(1)

Fuser Kit(1)

Roller Kit(1)

Extended Capacity Maintenance Kit(1)

 
Replacement For

C9152-67907(1)

CB388-67903(1)

Q5421-67903(1)

 
Yield Type

Extended-Yield(1)

 
Print Supply Technology

UltraChrome K3(1)

 
Ink Base

Pigment-Based(1)

 
Liquid Volume

80 mL(1)

 
Page-Yield

225,000(5)

350,000(2)

150,000(2)

125,000(2)

10,000(2)

30,000(2)

100,000(1)

200,000(1)

330000(1)

 
Remanufactured

No(28)

Yes(3)