0

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 ('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(35)

Innovera(27)

Xerox(23)

Lexmark(9)

Epson(4)

InfoPrint Solutions Company(4)

Ricoh(4)

Samsung(1)

 
Color(s)

Black(1)

 
Manufacturer Part Number

CB388A(2)

Q5421A(2)

56P1409(2)

40X4724(2)

40X0100(2)

C9152A(2)

Q542167903RE(1)

402960(1)

40X8425(1)

40X6401(1)

40X5400(1)

40X4033(1)

40X4031(1)

40X1831(1)

Q5421B(1)

C12C890191(1)

Q542167903OE(1)

Q2436A(1)

406642(1)

Q2429B(1)

Q2429(1)

CB388B(1)

CB388AREF(1)

C9152B(1)

C8057(1)

C4118A(1)

402961(1)

ML-PMK65K(1)

406686(1)

108R01266(1)

604K73140(1)

116R00003(1)

115R00086(1)

115R00069(1)

115R00063(1)

113R00736(1)

109R00784(1)

109R00783(1)

109R00731(1)

108R01267(1)

108R01037(1)

C3971B(1)

108R01036(1)

108R00989(1)

108R00841(1)

108R00717(1)

108R00676(1)

108R00675(1)

108R00657(1)

108R00603(1)

108R00600(1)

013R00650(1)

C4118(1)

99A2408(1)

C3914(1)

CB389A(1)

CH644A(1)

CF249A(1)

CF065A(1)

CF064A(1)

CE731A(1)

CE514A(1)

CB459A(1)

CB458A(1)

CB457A(1)

C9518A(1)

CM998A(1)

C3915A(1)

C2H67A(1)

C2H57A(1)

C1P70A(1)

C1N58A(1)

C1N54A(1)

B3M77A(1)

T619000(1)

T582000(1)

CH649A(1)

F2G76A(1)

99A2420(1)

28P2625(1)

99A2411(1)

C12C890501(1)

99A1978(1)

99A1970(1)

5851A(1)

56P1409REO(1)

39V3590(1)

39V2634(1)

39V2598(1)

Q7842A(1)

F2G77A(1)

Q7832A(1)

Q6715A(1)

Q6496A(1)

Q5998A(1)

Q5997A(1)

Q5422A(1)

Q2429A(1)

L2740A(1)

L2718A(1)

675K47673(1)

 
Country of Origin

CN(47)

US(25)

MX(11)

JP(10)

MY(9)

SG(5)

 
For Use With

HP Color LaserJet 6015, CM6040MFP(3)

HP Color LaserJet Enterprise flow M880 Multifunction Series(3)

Xerox ColorQube 8570, 8870(2)

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

HP Color LaserJet Enterprise flow M830 Multifunction Series(2)

HP LaserJet M4345 MFP(2)

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

HP LaserJet 4250 Series, 4350 Series(1)

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

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

Lexmark T650, T652, T654(1)

HP LaserJet 4240, 4240N, 4250, 4250N, 4250TN, 4250DN, 4250DTN, 4250DTNSL, 4350, 4350N, 4350DTN, 4350DTNSL(1)

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

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

Lexmark C734, 736, CS 736; X734, 736, 738; XS 734, 736(1)

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

HP LaserJet Enterprise 500, M575, M575dn; LaserJet Enterprise flow MFP M525c, MFP M575c(1)

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

HP DesignJet T7100(1)

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

Epson Stylus Pro 7700, 9700(1)

HP LaserJet Enterprise M601, M602, M603(1)

HP LaserJet Enterprise 600 Series(1)

HP LaserJet Enterprise M4555 MFP Series(1)

HP LaserJet Enterprise 700 Color MFP M775 Series(1)

HP LaserJet P4014A, P4015, P4510 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 LaserJet Enterprise Flow MFP M630z, HP LaserJet Enterprise MFP M630f, HP MFP M630h(1)

Epson Stylus Pro 4900; SureColor P5000(1)

Epson Stylus Pro 3800, 3880(1)

Xerox WorkCentre 4250, 4260(1)

 
Device Types

Laser Printer(77)

Multifunction Laser Printer(16)

Wide Format Inkjet Printer(10)

Inkjet Printer(1)

Scanner(1)

Copier(1)

 
Supply Type

Maintenance Kit(75)

Maintenance Cartridge(5)

Maintenance Tank(4)

Roller Kit(4)

Extended Capacity Maintenance Kit(3)

Fuser Kit(2)

ADF Maintenance Kit(2)

Usage Kit(2)

Suction Filter(1)

Cleaning Kit(1)

Cleaning Unit(1)

Maintenance Kit (Type 1)(1)

Cleaning Assembly(1)

Image Transfer Unit(1)

Fuser Maintenance Kit(1)

Mylar Sheets(1)

Maintenance Kit; Fuser(1)

Feed Roller Assembly(1)

 
Replacement For

Q5421-67903(4)

C4118-67909(2)

56P1409(2)

Q2429-67904(2)

CB388-67901(2)

C9152-67907(2)

Q2436-69004(1)

CB388-67903(1)

C8057-67901(1)

40X0100(1)

C3971-67903(1)

40X4724(1)

56P9104(1)

99A2411(1)

99A2408(1)

99A1978(1)

99A1970(1)

5851-3996(1)

C3914-67902(1)

 
Yield Type

Extended-Yield(1)

 
Print Supply Technology

UltraChrome K3(1)

 
Ink Base

Pigment-Based(1)

 
Liquid Volume

80 mL(1)

 
Page-Yield

200000(11)

300000(10)

225,000(8)

100000(6)

100,000(3)

30000(3)

350000(3)

200,000(3)

350,000(2)

30,000(2)

10,000(2)

150000(2)

450000(1)

190000(1)

225000(1)

90000(1)

120000(1)

300,000(1)

250000(1)

6000(1)

150,000(1)

330000(1)

 
Remanufactured

No(72)

Yes(26)

 
 
 

© 2020-2021 Service Office Supplies, All Rights Reserved