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)

Imaging Units(8)

Laser Printers(8)

Waste Toner Bottles(7)

Color Laser Printers(6)

Pen Refills(6)

Air Respirator Accessories(5)

Label Printer Labels(5)

Vacuum Bags & Filters(4)

Stamp Pad Ink(4)

Personal Soaps(4)

Dry Erase Markers(4)

Electric/Battery Operated Staplers(4)

Felt-tip/Porous Point Pens(2)

Laser Printer Maintenance/Usage Kits(2)

LTO Data Cartridges(2)

Safety Masks(2)

Air Fresheners/Odor Eliminators(2)

Electric Pencil Sharpeners(2)

Inks & Paper Combinations(2)

Thermal Transfer Films & Refills(2)

Impact Printers(2)

Eye Wash Solutions(2)

Cleaning Equipment Parts & Accessories(1)

Disinfectants(1)

Computer Cloths/Wipes & Dusters(1)

Utility Knife Replacement Blades(1)

Laminating Machines(1)

Dry-Erase Kits/Holders(1)

Paper Trimmer Replacement Blades(1)

Utility Knives & Cutters(1)

Staplers(1)

Rollerball Pens(1)

Heavy-Duty Staplers(1)

Hand Soaps/Cleaners(1)

Fuel and Fuel Additives(1)

Time Clock Ribbons & Cartridges(1)

Photo Paper(1)

Self-Inking Stamps(1)

Typewriter Correction Ribbons(1)

Typewriter Ribbons(1)

Soap Dispensers(1)

Data Cartridges Tapes(1)

Napkin Dispensers(1)

Correction Tapes(1)

Safety Center Kit(1)

Air Purifier/Humidifier Filters(1)

Inkjet Printers(1)

Page Wide Printers(1)

Respirator Cartridges & Filters(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)

Panasonic(22)

Verbatim(22)

Samsung(19)

Innovera(10)

Rapid(9)

Swingline(7)

MAX(5)

Pilot(5)

ActiveAire(5)

3M(5)

Genuine Joe(5)

MICR Tech(4)

Scotch(4)

Shop-Vac(4)

GBC(4)

SICURIX(4)

Xyron(4)

Casio(4)

Troy(3)

Xstamper(3)

Turbon(3)

Honeywell(3)

InfoPrint(3)

Rubbermaid Commercial(3)

Sheaffer(3)

SKILCRAFT(3)

Muratec(3)

Sparco(2)

Parker(2)

Waterman(2)

Kimberly-Clark(2)

Business Source(2)

HPE(2)

Copystar(2)

Febreze(2)

NORTH(2)

Bostitch(2)

Kodak(2)

Bobrick(2)

Cross(1)

Softsoap(1)

Consolidated Stamp(1)

DEC(1)

Wizard Wall(1)

COSCO(1)

Gojo®(1)

Read Right(1)

Scott(1)

Acroprint(1)

Georgia-Pacific(1)

Savin(1)

FancyHeat(1)

North Safety(1)

GOJO(1)

Dial Professional(1)

 
Color

White(90)

Clear(38)

Black(32)

Yellow(19)

Blue(15)

Silver(9)

Gray(7)

Red(6)

Pink(3)

Green(3)

Orange(2)

Gold(2)

Stainless Steel(2)

Chrome(1)

Aqua(1)

Salmon(1)

Assorted(1)

Fluorescent Orange(1)

Golden(1)

Matte Silver(1)

Brown(1)

Purple(1)

Sunscape(1)

 
Recycled

No(240)

Yes(4)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved