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 (`category_id` IN ('90132')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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(6)

Canon(1)

HP(1)

Lexmark(1)

 
For Use With

Canon imageRUNNER 2200, 2800, 3300(1)

HP LaserJet 9055, 9065mfp(1)

Lexmark X850, X852, X860de, X862dte, X864dhe(1)

Xerox ColorQube 9200, 9300(1)

Xerox Phaser 7760(1)

Xerox Phaser 7760; VersaLink B7125, B7130, B7135, C7120, C7125, C7130; Versant VR280; WorkCentre 4150(1)

Xerox DocuColor 240, 242, 250, 252, 260; Phaser 7800; VersaLink B7125, B7130, B7135, C7120, C7125, C7130; Versant VR280; WorkCentre 5030, 5050, 5225, 5230, 5645, 5655, 5675, 5687, 7120, 7125, 7132, 7232, 7242, 7328, 7345, 7346, 7355, 7425, 7428, 7435, 7525, 7530, 7535, 7545, 7556, 7755, 7765, 7775; WorkCentre Pro C2128, C2636, C3545(1)

Xerox Versant VR280, VR4100; WorkCentre 5765, 5775, 5790(1)

Xerox CopyCentre C35, C45, C55, C165, C175; WorkCentre 232, 238, 245, 255, 265, 275, M35, M45, M55, M165, M175; WorkCentre Pro 35, 55, 165, 175, 232, 238, 245, 255, 265, 275(1)

 
Country of Origin

JP(7)

CN(1)

SE(1)

 
Staple Cartridge Type

Standard(8)

Finisher(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander