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_38` 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(33)

Oki(2)

 
Color(s)

Black(3)

Cyan(3)

Magenta(3)

Yellow(3)

Light Cyan(3)

Light Magenta(3)

Cyan; Matte Black(2)

Light Cyan; Light Magenta(2)

Magenta; Yellow(2)

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

Black; Red(1)

Light Gray; Photo Black(1)

Gloss Enhancer; Gray(1)

Matte Black; Cyan(1)

Blue; Green(1)

Black; Light Gray(1)

Black; Cyan; Magenta; Yellow(1)

Chromatic Red; Matte Black(1)

 
Manufacturer Part Number

B3P06A(1)

C9423A(1)

C9408A(1)

C9409A(1)

C9410A(1)

C9420A(1)

C9421A(1)

C9422A(1)

C9424A(1)

C9406A(1)

C9460A(1)

C9461A(1)

C9462A(1)

C9463A(1)

CD949A(1)

50063802(1)

C9407A(1)

C9405A(1)

C1Q10A(1)

C4955A(1)

C1Q20A(1)

C4950A(1)

C4951A(1)

C4952A(1)

C4953A(1)

C4954A(1)

C4960A(1)

C9404A(1)

C4961A(1)

C4962A(1)

C4963A(1)

C4964A(1)

C4965A(1)

C5019A(1)

50114601(1)

 
Country of Origin

SG(32)

JP(2)

CN(1)

 
For Use With

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

HP DesignJet Z2100 Series(5)

HP DesignJet 30, 90, 130 Series(5)

HP DesignJet Z6100 Series(4)

HP DesignJet Z3100 Series(2)

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

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

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

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

HP DesignJet Z3200 Series(1)

 
Device Types

Inkjet Printer(29)

Wide Format Inkjet Printer(4)

 
Supply Type

Printhead(23)

Printhead and Cleaner(12)

 
Ink Base

Dye-Based(6)

Pigment-Based(1)

 
Liquid Volume

69 mL(1)

 
Remanufactured

No(33)

 
 
 

© 2020-2021 NBJ Form & Function Inc. , All Rights Reserved