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 ((`desc_short` like 'hp cartridge' OR `desc_long` like 'hp cartridge' OR `desc_title` like 'hp cartridge' OR `keywords` like 'hp cartridge' OR `category_1` like 'hp cartridge' OR `category_2` like 'hp cartridge' OR `category_3` like 'hp cartridge' OR `category_4` like 'hp cartridge' OR `manufacturer_name` like 'hp cartridge' OR `color` like 'hp cartridge') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>hp>hps)+(>cartridge>cartridges)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"hp cartridge"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%hp cartridge%' OR `pinfo`.`sku` like '%hpcartridge%' OR (FIND_IN_SET('hp cartridge', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('hp cartridge', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('hp cartridge', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('hp cartridge', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('hp cartridge', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'hp cartridge' ELSE `pinfo`.`desc_title` like 'hp cartridge' END))) 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 '%hp cartridge' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('hp +cartridge' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+hp +cartridge' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"hp cartridge"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"hp cartridge"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"hp cartridge"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"hp cartridge"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+hp +cartridge' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='cartridge',`category_4` ='cartridge') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'cartridge,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('cartridge', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Hp Cartridge

Refine Search

  GO
 
Category

Laser Toner Cartridges(2691)

Ink Cartridges & Printheads(826)

Label Tapes(122)

Laser Printer Drums(46)

Printer Ribbons(37)

Copier Toners(37)

Multifunction/All-in-One Machines(23)

Multipurpose Labels(21)

Fax Toner Cartridges(17)

Staples(15)

Air Fresheners/Sanitizers(13)

Inks & Toners(13)

Laminating Supplies(11)

Imaging Units(8)

Laser Printers(7)

Waste Toner Bottles(7)

Color Laser Printers(6)

Pen Refills(5)

Air Respirator Accessories(5)

Label Printer Labels(5)

Electric/Battery Operated Staplers(4)

Stamp Pad Ink(4)

Vacuum Bags & Filters(4)

Dry Erase Markers(4)

Personal Soaps(3)

Safety Masks(2)

Laser Printer Maintenance/Usage Kits(2)

LTO Data Cartridges(2)

Felt-tip/Porous Point Pens(2)

Eye Wash Solutions(2)

Electric Pencil Sharpeners(2)

Air Fresheners/Odor Eliminators(2)

Impact Printers(2)

Thermal Transfer Films & Refills(2)

Respirator Cartridges & Filters(1)

Utility Knife Replacement Blades(1)

Dry-Erase Kits/Holders(1)

Disinfectants(1)

Cleaning Equipment Parts & Accessories(1)

Computer Cloths/Wipes & Dusters(1)

Heavy-Duty Staplers(1)

Paper Trimmer Replacement Blades(1)

Rollerball Pens(1)

Utility Knives & Cutters(1)

Ink/Toner Cartridges(1)

Soap Dispensers(1)

Correction Tapes(1)

Paper Napkin Dispensers(1)

Napkin Dispensers(1)

Air Purifier/Humidifier Filters(1)

DLT Data Cartridges(1)

Page Wide Printers(1)

Inkjet Printers(1)

Time Clock Ribbons & Cartridges(1)

Hand Soaps/Cleaners(1)

Fuel and Fuel Additives(1)

Photo Paper(1)

Self-Inking Stamps(1)

Inks & Paper Combinations(1)

Typewriter Ribbons(1)

Typewriter Correction Ribbons(1)

Laminating Machines(1)

 
Brand

Elite Image(744)

HP(706)

Xerox(320)

Canon(302)

Lexmark(298)

Brother(292)

Epson(173)

Kyocera(130)

Ricoh(98)

IBM(92)

Dell(91)

Oki(91)

Konica Minolta(77)

Media Sciences(75)

SKILCRAFT(71)

Dymo(61)

microMICR(58)

Sharp(40)

Toshiba(36)

Samsung(35)

Panasonic(22)

Verbatim(21)

Innovera(12)

Rapid(7)

Swingline(7)

MICR Tech(7)

Genuine Joe(5)

ActiveAire(5)

Pilot(5)

3M(5)

MAX(5)

SICURIX(4)

Xyron(4)

Scotch(4)

GBC(4)

Scott(4)

Troy(4)

Shop-Vac(4)

Casio(4)

Muratec(3)

Sheaffer(3)

Rubbermaid Commercial(3)

Xstamper(3)

InfoPrint(3)

Turbon(3)

HPE(3)

Acroprint(2)

Bobrick(2)

Bostitch(2)

Febreze(2)

NORTH(2)

Business Source(2)

Sparco(2)

Waterman(2)

Honeywell(2)

Copystar(2)

Cross(1)

Wizard Wall(1)

COSCO(1)

Consolidated Stamp(1)

DEC(1)

Kodak(1)

Dial Professional(1)

FancyHeat(1)

Riso(1)

Gojo®(1)

GOJO(1)

Read Right(1)

Georgia-Pacific(1)

Parker(1)

North Safety(1)

Savin(1)

 
Color

White(84)

Clear(38)

Black(32)

Yellow(19)

Blue(15)

Silver(9)

Gray(7)

Red(6)

Pink(3)

Green(3)

Gold(2)

Orange(2)

Stainless Steel(2)

Assorted(1)

Sunscape(1)

Aqua(1)

Salmon(1)

Matte Silver(1)

Red On White(1)

Blue on White(1)

Purple(1)

Brown(1)

Fluorescent Orange(1)

Golden(1)

Chrome(1)

 
Recycled

No(235)

Yes(5)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved