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

Ink/Toner Cartridges(3447)

Labels(132)

Printing Drums(58)

Multifunction Printers(23)

Laser & Inkjet Printers(15)

Staples(15)

Air Fresheners & Sanitizers(13)

Inks & Toners(12)

Lamination Sheets & Cartridges(11)

Printer Ink/Toner Refills & Waste Collectors(11)

Pen/Pencil Refills(10)

Staplers(5)

Air Respirator Accessories(5)

Vacuum Filters(4)

Printing Kits(4)

Stamp Pads & Inks(4)

Tape Media(3)

Personal Soaps(3)

Eye Wash Solutions(2)

Air Fresheners/Odor Eliminators(2)

Safety Gears(2)

Blades(2)

Dot Matrix Printers(2)

Pencil Sharpener Accessories(2)

Erase Boards/Films(1)

Paper Cutters(1)

Cleaning Kits(1)

Cleaning Equipment Parts & Components(1)

Household Cleaners(1)

Stamps(1)

Respirator Cartridges & Filters(1)

Correction Tapes(1)

Soaps & Sanitizers(1)

Napkin Dispensers(1)

Miscellaneous Devices(1)

Fuel and Fuel Additives(1)

Soap Dispensers(1)

Laminators(1)

 
Brand

Elite Image(743)

HP(711)

Xerox(319)

Canon(298)

Lexmark(276)

Brother(269)

Epson(169)

Kyocera(116)

IBM(92)

Oki(91)

Dell(91)

Ricoh(85)

Konica Minolta(76)

Media Sciences(75)

Dymo(60)

microMICR(58)

Sharp(40)

Toshiba(27)

Panasonic(22)

Verbatim(21)

Samsung(17)

Innovera(11)

MICR Tech(7)

Rapid(7)

Swingline(7)

Genuine Joe(5)

Pilot(5)

3M(5)

ActiveAire(5)

MAX(5)

Xyron(4)

Troy(4)

Scotch(4)

Casio(4)

SICURIX(4)

Shop-Vac(4)

GBC(4)

Muratec(3)

SKILCRAFT(3)

Rubbermaid Commercial(3)

Xstamper(3)

HPE(3)

Scott(3)

InfoPrint(3)

Turbon(3)

Honeywell(2)

Copystar(2)

Sheaffer(2)

Bobrick(2)

Acroprint(2)

Sparco(2)

Business Source(2)

NORTH(2)

Febreze(2)

Bostitch(2)

Wizard Wall(1)

Waterman(1)

Consolidated Stamp(1)

COSCO(1)

Cross(1)

Kodak(1)

DEC(1)

Dial Professional(1)

FancyHeat(1)

Gojo®(1)

GOJO(1)

Read Right(1)

Georgia-Pacific(1)

Parker(1)

North Safety(1)

Savin(1)

 
Color

White(79)

Clear(35)

Black(30)

Yellow(16)

Blue(15)

Silver(9)

Gray(7)

Red(5)

Green(3)

Pink(3)

Stainless Steel(2)

Orange(2)

Assorted(1)

Aqua(1)

Salmon(1)

Sunscape(1)

Fluorescent Orange(1)

Purple(1)

Brown(1)

Matte Silver(1)

Gold(1)

Golden(1)

Chrome(1)

 
Recycled

No(217)

Yes(4)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved