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_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`brand_id` = "10429") 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 '%Hewlett Packard' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Hewlett +Packard' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Hewlett +Packard' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Hewlett Packard"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Hewlett Packard"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Hewlett Packard"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Hewlett Packard"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Hewlett +Packard' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Packard',`category_4` ='Packard') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Packard%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Packard', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Brands

HP

Refine Search

  GO
Category

Laser Toner Cartridges(353)

Ink Cartridges & Printheads(350)

Photo Paper(27)

Multifunction/All-in-One Machines(21)

Laser Printers(14)

Wide Format Paper(13)

Copy & Multi-use White Paper(11)

Brochure Paper(9)

Laser Printer Maintenance/Usage Kits(6)

Color Laser Printers(6)

Laser Printer Fusers(6)

Laser Printer Drums(5)

Sheetfed Scanners(4)

Copier Toners(4)

Inkjet Paper(4)

Laser Papers(3)

Page Wide Printers(3)

Business & Financial Calculators(3)

Flatbed Scanners(2)

Laser Printer Transfer Kits(2)

Transparency Film(1)

Graphing & Scientific Calculators(1)

Media Trays(1)

Inkjet Printers(1)

Staples(1)

Imaging Units(1)

Brand

HP(818)

Samsung(19)

HP Papers(14)

HPE(1)

Color

White(47)

Glossy(4)

Bright White(3)

Platinum(1)

Black(1)

Clear(1)

Matte White(1)

Brightness

92(9)

90(6)

107(6)

96(5)

95(5)

97(5)

100(4)

89(4)

110(3)

98(2)

93(1)

103(1)

Size

Letter(22)

A0(4)

Ledger/Tabloid(3)

A1(3)

Legal(2)

Tabloid(1)

A0++(1)

Recycled

No(69)

Yes(1)

Price Range

$0-$499.99 (813)

$500-$999.99 (31)

$1000-$1499.99 (4)

$1500-$1999.99 (3)

$2000-$2499.99 (1)

To  GO

 
 
1%
Searching for your Best Results.....
loading results
 

© 2020-2021 JD Office Products, All Rights Reserved