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

Currently Filtered by

Category

Printheads

Refine Search
  GO
 
Brand

HP(73)

 
Color(s)

Yellow(7)

Black(7)

Magenta; Yellow(6)

Cyan(6)

Magenta(6)

Chromatic Red; Matte Black(4)

Cyan; Magenta(4)

Light Cyan; Light Magenta(3)

Light Magenta(3)

Light Cyan(3)

Light Gray; Photo Black(2)

Black; Cyan; Magenta; Yellow(2)

Black; Yellow(2)

Cyan; Matte Black(2)

Black; Red(2)

Photo Black; Cyan(1)

Dark Gray(1)

Matte Black(1)

Dark Gray; Gray(1)

Cyan; Gray; Magenta; Matte Black; Photo Black; Yellow(1)

Matte Black; Cyan(1)

Gloss Enhancer; Gray(1)

Blue; Green(1)

Black; Light Gray(1)

Matte Black; Yellow(1)

Gray; Photo Black(1)

Cyan; Light Magenta(1)

 
Manufacturer Part Number

B3P06A(1)

C9423A(1)

CD949A(1)

C9463A(1)

C9462A(1)

C9461A(1)

C9460A(1)

C9424A(1)

C9422A(1)

CE018A(1)

C9421A(1)

C9420A(1)

C9410A(1)

C9409A(1)

C9408A(1)

C9407A(1)

CE017A(1)

CE019A(1)

C9405A(1)

F9J88A(1)

P2V98A(1)

P2V97A(1)

P2V48A(1)

P2V47A(1)

P2V27A(1)

P2V25A(1)

F9J87A(1)

CE020A(1)

F9J86A(1)

F9J81A(1)

CN074A(1)

CH648A(1)

CH647A(1)

CH646A(1)

CH645A(1)

C9406A(1)

C9404A(1)

C1Q10A(1)

C4822A(1)

C4952A(1)

C4951A(1)

C4950A(1)

C4901A(1)

C4900A(1)

C4823A(1)

C4821A(1)

C4954A(1)

C4820A(1)

C4813A(1)

C4812A(1)

C4811A(1)

C4810A(1)

C1Q20A(1)

C4953A(1)

C4955A(1)

C9384A(1)

C5056A(1)

C9383A(1)

C9382A(1)

C9381A(1)

C9380A(1)

C5096A(1)

C5057A(1)

C5055A(1)

C4960A(1)

C5054A(1)

C5019A(1)

C4965A(1)

C4964A(1)

C4963A(1)

C4962A(1)

C4961A(1)

P2V99A(1)

 
Country of Origin

SG(71)

CN(1)

MY(1)

 
For Use With

HP DesignJet 5000, 5000PS, 5500, 5500PS(6)

HP DesignJet Z2100 Series(5)

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

HP DesignJet 30, 90, 130 Series(5)

HP Business Inkjet 1000, 1100 Series, 1200 Series, 2200 Series, 2230, 2250 Series, 2280 Series, 2300 Series, 2600 Series, 2800 Series; Color Inkjet CP1700 Series; DesignJet 70, 100 Series, 110 Series, 111; Officejet 9110, 9120, 9130, OfficeJet Pro K850 Series(4)

HP DesignJet 1050c Plus, 1055cm Plus, 1050c, 1055cm(4)

HP DesignJet T7100(4)

HP DesignJet Z6100 Series(4)

HP DesignJet 4000 Series, 4020 Series, 4500 Series, 4520 Series(4)

HP DesignJet Z6610 Series, Z6810 Series(3)

HP DesignJet Z2600 24" PostScript, Z5600 44" PostScript(3)

HP DesignJet T610 Series, T620, T770 Series, T790 Series, T795, T1100 Series, T1120 Series, T1200 Series, T1300 Series, T2300 Series(3)

HP DesignJet Z3100 Series(2)

HP Officejet Pro K550 Series, K5400 Series, K8600 Series, L7480, L7550, L7580, L7590, L7650, L7680, 7750, 7780(2)

HP Officejet Pro 8000 Series, 8500 Series(2)

HP DesignJet T120 24", T520 24", T520 36"(1)

HP DesignJet 4000 Series, 4500 Series(1)

HP DesignJet 10ps, 20ps, 50ps, 120 Series(1)

HP DesignJet Z3200 Series(1)

HP DesignJet 5000UV, 5000PS-UV, 5500UV, 5500PS-UV(1)

HP DesignJet T830 MFP(1)

HP DesignJet HD Pro 44-in MFP Series, Z6 Series, Z9+ Series(1)

HP DesignJet SD Pro 44" MFP, T1700 Series(1)

HP DesignJet Z6200 Series, Z6800 Series(1)

HP DesignJet T920 36", T1500 36"(1)

 
Device Types

Inkjet Printer(50)

Wide Format Inkjet Printer(21)

DesignJet Printer(2)

 
Supply Type

Printhead(52)

Printhead and Cleaner(20)

Printhead Cleaner(1)

 
Ink Base

Pigment-Based(12)

Dye-Based(7)

 
Liquid Volume

8 mL(4)

69 mL(1)

 
Remanufactured

No(73)

 
 
 

© 2020-2021 Capital Services & Supplies Inc., All Rights Reserved

Powered by SITS Erp