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

Currently Filtered by

Category

Laser Printer Maintenance Usage Kits

Refine Search

  GO
 
Brand

HP(19)

Xerox(6)

 
Recycled

No(1)

 
Packaged Quantity

1 Each(14)

1(1)

 
Assembly Required

No(1)

 
Limited Warranty

90 Day(7)

 
Weight (Approximate)

11.46 lb(1)

10.10 lb(1)

42.37 lb(1)

 
Compatibility

Xerox ColorQube Printers:

  • 8870
  • 8570
(2)

HP LaserJet Enterprise Printers:

  • M604dn
  • M604n
  • M605dn
  • M605n
  • M605x
  • M606dn
  • M606x
(1)

Xerox VersaLink Colour Printers:

  • C600
  • C505
  • C605
  • C500
(1)

Xerox Phaser 7500 Printer(1)

Xerox Phaser 7400

(1)

  • Xerox Phaser 8550 Printer
(1)

  • HP Laserjet 4345 MFP Series
(1)

HP LaserJet Printers:

  • 4250
  • 4350
(1)

HP LaserJet Printers::

  • M652
  • M653
(1)

HP Printers::

  • M607
  • M607dn
  • M607n
  • M608
  • M608dn
  • M608n
  • M608x
  • M609
  • M609dh
  • M609dn
  • M609x
  • E60055dn
  • E60065
  • E60075
(1)

HP LaserJet Printers:

  • M631
  • M632
  • M633
(1)

HP LaserJet Printers:

  • M855dn
  • M880z+ NFC
  • M880z
  • M855x+
  • M880z+
  • M855xh
(1)

HP LaserJet Enterprise Printers:

  • M806dn
  • M806x+ NFC/Wireless Direct Printer
  • flow M830z NFC/Wireless Direct Multifunction Printer
  • flow M830z
(1)

HP DesignJet Z6200 Photo Series Printers(1)

HP LaserJet 700 Series Printers:

  • M712dn
  • M712n
  • M712xh
(1)

HP LaserJet Enterprise 600 Printers:

  • M601n
  • M601dn
  • M602n
  • M602dn
  • M602x
  • M603n
  • M603dn
  • M603x
(1)

HP LaserJet Printers:

  • M775dn
  • M775z+
  • M775f
  • M775z
(1)

HP LaserJet Enterprise 700 color MFP Printers:

  • M775dn
  • M775f
  • M775z
  • M775z+
(1)

HP Color LaserJet Enterprise MFP Printers:

  • CM4540
  • CM4540f
  • CM4540fskm

HP LaserJet Enterprise MFP Printers:

  • M4555f
  • M4555fskm
  • M4555h
(1)

  • HP Color LaserJet CM6030f MFP (CE665A)
  • HP Color LaserJet CM6040f MFP (Q3939A)
  • HP Color LaserJet CP6015dn Printer (Q3932A)
  • HP Color LaserJet CP6015x Printer (Q3933A)
  • HP Color LaserJet CP6015xh Printer (Q3934A)
(1)

  • HP LaserJet P4014 Printer series
  • HP LaserJet P4015 Printer series
  • HP LaserJet P4510 Printer series
(1)

  • HP LaserJet 9000 Series
(1)

HP Designjet T7100 Series Printers(1)

 
Print Technology

Laser(20)

Inkjet(2)

Solid Ink(1)

 
Print Color

Black(4)

Color(2)

Cyan(1)

Magenta(1)

Yellow(1)

 
Typical Print Yield

225000 Pages(4)

150000 Pages(4)

200000 Pages(2)

30000 Pages(2)

100000 Pages(1)

350000 Images(1)

90000 Pages(1)

150000(1)

30000(1)

10000 Pages(1)

 
Package Type

Retail(2)

 
Manufacturer Part Number

C1N54A(1)

F2G76A(1)

109R00783(1)

108R01492(1)

108R00865(1)

108R00697(1)

108R00676(1)

Q5998A(1)

Q5421A(1)

P1B91A(1)

L0H24A(1)

J8J87A(1)

D7H14A(1)

C2H67A(1)

CH649A(1)

CH644A(1)

CF249A(1)

CF064A(1)

CE516A(1)

CE514A(1)

CE248A(1)

CB459A(1)

CB388A(1)

C9152A(1)

109R00784(1)

 
Country of Origin

China(7)

Japan(3)

Malaysia(3)

Singapore(2)

Vietnam(1)

 
Height

13.1"(1)

9.6"(1)

26.4"(1)

 
Width

23.2"(1)

19.8"(1)

23.6"(1)

 
Depth

9.6"(1)

11.9"(1)

19.8"(1)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved