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 ('90125')) 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(10)

Xerox(6)

Lexmark(1)

 
Warranty

Manufacturer's limited one-year warranty.(5)

Manufacturer's limited 90-day warranty (parts only).(3)

Manufacturer's 90-day warranty.(3)

Manufacturer's limited lifetime warranty.(2)

Manufacturer's throughput warranty.(2)

 
For Use With

Xerox ColorQube 8570, 8870(2)

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

HP Color LaserJet Enterprise flow M880 Multifunction Series(1)

HP Color LaserJet Enterprise flow M830 Multifunction Series(1)

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

HP LaserJet P4014n(1)

HP LaserJet Enterprise 700 Color MFP M775 Series(1)

HP LaserJet Enterprise 600 Series(1)

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

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

HP LaserJet 4250 Series, 4350 Series(1)

Lexmark T650, T652, T654(1)

Xerox VersaLink C500, C505, C600, C605(1)

 
Manufacturer Part Number

C1N54A(1)

Q5421A(1)

109R00783(1)

108R01492(1)

108R01267(1)

108R00676(1)

108R00675(1)

40X4724(1)

Q2429A(1)

C2H67A(1)

F2G76A(1)

CF249A(1)

CF064A(1)

CE514A(1)

CB388A(1)

C9152A(1)

109R00784(1)

 
Country of Origin

CN(10)

MY(4)

JP(2)

VN(1)

 
OEM/Compatible

OEM(17)

 
Device Types

Laser Printer(14)

Wide Format Inkjet Printer(2)

Multifunction Laser Printer(1)

 
Supply Type

Maintenance Kit(14)

Maintenance Kit; Fuser(1)

Maintenance Kit (Type 1)(1)

Extended Capacity Maintenance Kit(1)

 
Remanufactured

No(17)

 
Page-Yield

225,000(2)

10,000(2)

30,000(2)

350,000(1)

300,000(1)

100,000(1)

 
Market Indicator (Cartridge Number)

108R01267(1)

108R01492(1)

 
Yield Type

Extended-Yield(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved