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_2` 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 (`category_id` IN ('154')) 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 '%StapleCartridgesforPrinterFaxCopier' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('StapleCartridgesforPrinterFaxCopier' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+StapleCartridgesforPrinterFaxCopier' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"StapleCartridgesforPrinterFaxCopier"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"StapleCartridgesforPrinterFaxCopier"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"StapleCartridgesforPrinterFaxCopier"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"StapleCartridgesforPrinterFaxCopier"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+StapleCartridgesforPrinterFaxCopier' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='StapleCartridgesforPrinterFaxCopier',`category_4` ='StapleCartridgesforPrinterFaxCopier') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'StapleCartridgesforPrinterFaxCopier,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('StapleCartridgesforPrinterFaxCopier', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Staple Cartridges For Printer Fax Copier

Refine Search
GO
 
Brand

Xerox(7)

Canon(1)

HP(1)

Lexmark(1)

 
Manufacturer Part Number

6707A001AA(1)

C8091A(1)

25A0013(1)

008R12898(1)

008R12915(1)

008R12925(1)

008R12941(1)

008R12964(1)

008R13041(1)

108R00493(1)

 
Country of Origin

JP(8)

CN(1)

SE(1)

 
For Use With

Canon IR2200, 2800, 3300 (J1)(1)

HP LaserJet 9055, 9065mfp(1)

Lexmark X850; Lexmark X852; Lexmark X860de 4; Lexmark X860de 3; Lexmark X862dte 4; Lexmark X862dte 3; Lexmark X864dhe 4; Lexmark X864dhe 3.(1)

Xerox ColorQube 9200, 9300(1)

For Xerox Phaser 7760(1)

Xerox 7760/4150(1)

Workcentre 5030, 5050, 7525, 7530, 7535, 7545, 7556, 5225, 5230, 5665, 5675, 5687, 7755, 7765, 7775, 5645, 5655, 7755, 7765, 7775, 5645, 5655, 7425, 7428, 7435, 7328, 7355, 7345, 7346, 7132, 7232, 7242, 7120, 7125, Docucolor 240, 250, 242, 252, 260, Workcentre Pro C2128, C2636, C3545, Phaser 7800(1)

Xerox WorkCentre 5765, 5775, 5790(1)

Workcentre PRO245, 255, 165, 175, 55, 35, 265, 275, 232, 238 Workcentre M45, M35, M55, M165, M175, 265, 275, 245, 255, 232, 238 Copycentre 265, 275, 232, 238, C55, C35, C45, C165, C175, 245, 255(1)

 
Staple Cartridge Type

Standard(6)

Standard Staples(3)

 
Quantity Per Box/Pack/Carton

15,000(2)

15,000 Staples Per Pack(1)

One Cartridge Per Pack;5,000 Staples Per Cartridge(1)

Three Cartridges Per Box;5,000 Staples Per Cartridge;15,000 Staples Per Box(1)

15000 Staples Per Pack;3 Cartridges Per Pack(1)

20,000 Staples Per Box;4 Cartridges Per Box(1)

5,000 Staples Per Cartridge;One Cartridge Per Box(1)

20,000(1)

Three Cartridges Per Pack; 5,000 Staples Per Cartridge; 15,000 Staples Per Pack(1)

 
 
 

© 2020-2021 ISEOP, All Rights Reserved

Powered by SITS Erp