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

Oki(1)

 
Color(s)

Yellow(7)

Black(7)

Cyan(6)

Magenta(6)

Magenta; Yellow(5)

Cyan; Magenta(4)

Light Cyan(3)

Chromatic Red; Matte Black(3)

Light Cyan; Light Magenta(3)

Light Magenta(3)

Black; Cyan; Magenta; Yellow(2)

Black; Red(2)

Light Gray; Photo Black(2)

Black; Yellow(2)

Cyan; Matte Black(2)

Matte Black(1)

Dark Gray(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)

Photo Black; Cyan(1)

 
Manufacturer Part Number

B3P06A(1)

C9463A(1)

C9405A(1)

C9406A(1)

C9407A(1)

C9408A(1)

C9409A(1)

C9410A(1)

C9420A(1)

C9421A(1)

C9422A(1)

C9423A(1)

C9424A(1)

C9460A(1)

C9461A(1)

C9462A(1)

CD949A(1)

C9384A(1)

CN074A(1)

P2V48A(1)

P2V47A(1)

F9J88A(1)

F9J87A(1)

F9J86A(1)

F9J81A(1)

CH648A(1)

CE017A(1)

CH647A(1)

CH646A(1)

CH645A(1)

CE020A(1)

CE019A(1)

CE018A(1)

C9404A(1)

C9383A(1)

C1Q10A(1)

C4953A(1)

C1Q20A(1)

C4810A(1)

C4811A(1)

C4812A(1)

C4813A(1)

C4820A(1)

C4821A(1)

C4822A(1)

C4823A(1)

C4900A(1)

C4901A(1)

C4950A(1)

C4951A(1)

C4952A(1)

C4954A(1)

C9382A(1)

C5054A(1)

C9381A(1)

C9380A(1)

C5096A(1)

C5057A(1)

C5056A(1)

C5055A(1)

C5019A(1)

C4955A(1)

C4965A(1)

C4964A(1)

C4963A(1)

C4962A(1)

C4961A(1)

C4960A(1)

50114601(1)

 
Country of Origin

SG(66)

CN(1)

MY(1)

JP(1)

 
For Use With

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

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

HP DesignJet Z2100 Series(5)

HP DesignJet 30, 90, 130 Series(5)

HP DesignJet Z6100 Series(4)

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 4000 Series, 4020 Series, 4500 Series, 4520 Series(4)

HP DesignJet T7100(4)

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

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

HP Officejet Pro 8000 Series, 8500 Series(2)

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

HP DesignJet Z3100 Series(2)

HP DesignJet T830 MFP(1)

HP DesignJet Z3200 Series(1)

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

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 5000UV, 5000PS-UV, 5500UV, 5500PS-UV(1)

HP DesignJet Z6200 Series, Z6800 Series(1)

 
Device Types

Inkjet Printer(50)

Wide Format Inkjet Printer(16)

DesignJet Printer(2)

 
Supply Type

Printhead(48)

Printhead and Cleaner(20)

Printhead Cleaner(1)

 
Ink Base

Pigment-Based(8)

Dye-Based(6)

 
Liquid Volume

8 mL(4)

69 mL(1)

 
Remanufactured

No(68)

 
 
 

© 2020-2021 Service Office Supplies, All Rights Reserved

Powered by SITS Erp