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_27` 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(14)

HP(2)

Canon(1)

Lexmark(1)

InfoPrint Solutions Company(1)

Brother(1)

 
Manufacturer Part Number

008R13033(1)

008R12964(1)

008R12941(1)

008R12925(1)

008R13034(1)

008R13041(1)

108R00682(1)

108R00535(1)

108R00493(1)

008R12920(1)

008R12919(1)

Q7432A(1)

C8091A(1)

6707A001AA(1)

53P6725(1)

25A0013(1)

008R12915(1)

008R12898(1)

008R12897(1)

SR100(1)

 
Country of Origin

JP(14)

SE(3)

US(2)

CN(1)

 
For Use With

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)

For Xerox Phaser 7760(1)

Xerox ColorQube 9200, 9300(1)

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)

SF-4000(1)

 
Replacement For

HP CM3530;HP M3035(1)

 
Staple Cartridge Type

Standard(15)

Standard Staples(3)

Printer/Fax/Copier(1)

 
Quantity Per Box/Pack/Carton

15,000(2)

15,000 Staples per Box(2)

16,000(2)

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

20,000(1)

3,000(1)

9,000(1)

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

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

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

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

15,000 Staples Per Pack(1)

Two Cartridges Per Pack(1)

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

Two Cartridges Per Box; 5,000 Staples Per Cartridge; 10,000 Staples Per Box(1)

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

500 Staples Per Cartridge, 3 Cartridges Per Box(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved

Powered by SITS Erp