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

Ink Cartridges & Printheads(850)

Label Tapes(125)

Laser Printer Drums(45)

Copier Toners(38)

Printer Ribbons(36)

Multifunction/All-in-One Machines(26)

Multipurpose Labels(21)

Inks & Toners(20)

Fax Toner Cartridges(17)

Staples(16)

Air Fresheners/Sanitizers(13)

Laminating Supplies(11)

Laser Printers(8)

Imaging Units(8)

Waste Toner Bottles(7)

Color Laser Printers(6)

Pen Refills(6)

Label Printer Labels(5)

Air Respirator Accessories(5)

Stamp Pad Ink(4)

Electric/Battery Operated Staplers(4)

Vacuum Bags & Filters(4)

Personal Soaps(4)

Dry Erase Markers(4)

Safety Masks(2)

Laser Printer Maintenance/Usage Kits(2)

Felt-tip/Porous Point Pens(2)

LTO Data Cartridges(2)

Thermal Transfer Films & Refills(2)

Eye Wash Solutions(2)

Impact Printers(2)

Air Fresheners/Odor Eliminators(2)

Inks & Paper Combinations(2)

Electric Pencil Sharpeners(2)

Rollerball Pens(1)

Utility Knife Replacement Blades(1)

Utility Knives & Cutters(1)

Staplers(1)

Heavy-Duty Staplers(1)

Paper Trimmer Replacement Blades(1)

Computer Cloths/Wipes & Dusters(1)

Cleaning Equipment Parts & Accessories(1)

Disinfectants(1)

Dry-Erase Kits/Holders(1)

Time Clock Ribbons & Cartridges(1)

Soap Dispensers(1)

Respirator Cartridges & Filters(1)

Correction Tapes(1)

Napkin Dispensers(1)

Safety Center Kit(1)

Air Purifier/Humidifier Filters(1)

Page Wide Printers(1)

Inkjet Printers(1)

Data Cartridges Tapes(1)

Hand Soaps/Cleaners(1)

Fuel and Fuel Additives(1)

Photo Paper(1)

Self-Inking Stamps(1)

Typewriter Ribbons(1)

Typewriter Correction Ribbons(1)

Laminating Machines(1)

 
Brand

Elite Image(732)

HP(678)

Xerox(321)

Canon(301)

Brother(284)

Lexmark(274)

Epson(176)

Kyocera(117)

IBM(93)

Dell(93)

Oki(91)

Ricoh(85)

Media Sciences(81)

Konica Minolta(77)

Dymo(62)

microMICR(53)

Sharp(42)

Toshiba(27)

Verbatim(22)

Panasonic(22)

Samsung(19)

Innovera(10)

Rapid(9)

Swingline(7)

3M(5)

Genuine Joe(5)

Pilot(5)

ActiveAire(5)

MAX(5)

Xyron(4)

MICR Tech(4)

Scotch(4)

SICURIX(4)

Casio(4)

Shop-Vac(4)

GBC(4)

Muratec(3)

Xstamper(3)

Sheaffer(3)

InfoPrint(3)

Turbon(3)

Rubbermaid Commercial(3)

Honeywell(3)

Troy(3)

SKILCRAFT(3)

Parker(2)

Sparco(2)

Waterman(2)

Kimberly-Clark(2)

Bobrick(2)

Bostitch(2)

Febreze(2)

Business Source(2)

NORTH(2)

HPE(2)

Copystar(2)

Kodak(2)

North Safety(1)

Cross(1)

Wizard Wall(1)

Consolidated Stamp(1)

COSCO(1)

Softsoap(1)

FancyHeat(1)

DEC(1)

Dial Professional(1)

Gojo®(1)

GOJO(1)

Savin(1)

Georgia-Pacific(1)

Read Right(1)

Scott(1)

Acroprint(1)

 
Color

White(90)

Clear(38)

Black(32)

Yellow(19)

Blue(15)

Silver(9)

Gray(7)

Red(6)

Green(3)

Pink(3)

Stainless Steel(2)

Gold(2)

Orange(2)

Assorted(1)

Aqua(1)

Salmon(1)

Fluorescent Orange(1)

Sunscape(1)

Purple(1)

Brown(1)

Matte Silver(1)

Golden(1)

Chrome(1)

 
Recycled

No(240)

Yes(4)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved