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

Currently Filtered by

Category

Exchange

Refine Search

  GO
 
Brand

Lexmark(212)

Canon(27)

HP(26)

Oki(20)

Ricoh(19)

Xerox(17)

Brother(1)

 
Manufacturer Part Number

E1142EPSP(1)

2355962(1)

2356011(1)

2356010(1)

2356009(1)

2356008(1)

2355965(1)

2355964(1)

2355963(1)

2355921(1)

2356055(1)

2355920(1)

2355919(1)

2355918(1)

2355917(1)

2355916(1)

2355875(1)

2355874(1)

2356054(1)

2356056(1)

2355872(1)

2356076(1)

2356123(1)

2356122(1)

2356121(1)

2356120(1)

2356119(1)

2356118(1)

2356077(1)

2356075(1)

2356057(1)

2356074(1)

2356073(1)

2356072(1)

2356068(1)

2356067(1)

2356059(1)

2356058(1)

2355873(1)

2355871(1)

2356165(1)

2354798(1)

2354921(1)

2354920(1)

2354816(1)

2354815(1)

2354814(1)

2354800(1)

2354799(1)

2354784(1)

2354924(1)

2354783(1)

2354782(1)

2354768(1)

2354767(1)

2354766(1)

2354752(1)

2354751(1)

2354922(1)

2355644(1)

2355870(1)

2355782(1)

2355829(1)

2355828(1)

2355827(1)

2355826(1)

2355825(1)

2355824(1)

2355783(1)

2355737(1)

2355645(1)

2355736(1)

2355735(1)

2355734(1)

2355733(1)

2355732(1)

2355691(1)

2355690(1)

2356164(1)

2356166(1)

2352877(1)

006899MIU(1)

007078MIU(1)

007069MIU(1)

007068MIU(1)

007067MIU(1)

007066MIU(1)

007061MIU(1)

007060MIU(1)

006898MIU(1)

007080MIU(1)

006882MIU(1)

006881MIU(1)

005614MIU(1)

005613MIU(1)

001562MIU(1)

001561MIU(1)

58267802(1)

007079MIU(1)

007085MIU(1)

58267702(1)

E32X5D3(1)

E6015Q5(1)

E6015Q4(1)

E6015Q3(1)

E6010QA(1)

E6010Q4(1)

E6010Q3(1)

E4500SA(1)

E3260QA(1)

007086MIU(1)

E3260Q4(1)

E3260Q3(1)

E3250QA(1)

E3250Q3(1)

E3124QA(1)

E3124Q3(1)

E3124Q2(1)

58267801(1)

58263102(1)

2356167(1)

2356692(1)

2356746(1)

2356745(1)

2356698(1)

2356697(1)

2356696(1)

2356694(1)

2356693(1)

2356645(1)

2356749(1)

2356644(1)

2356643(1)

2356641(1)

2356640(1)

2356639(1)

2356169(1)

2356168(1)

2356747(1)

2356750(1)

38035410(1)

38035204(1)

38035409(1)

38035408(1)

38035405(1)

38035404(1)

38035210(1)

38035209(1)

38035205(1)

38035203(1)

2356751(1)

38005103(1)

38005102(1)

38005003(1)

38005002(1)

38004803(1)

38004802(1)

5688988(1)

355827(1)

2354750(1)

2352876(1)

5252B017(1)

UQ218E(1)

2346462(1)

2346461(1)

2346449(1)

2346448(1)

2346447(1)

UZ380E(1)

UQ221E(1)

UQ217E(1)

2346464(1)

UQ209E(1)

UQ208E(1)

UQ207E(1)

UP875E(1)

UP873E(1)

UP871E(1)

UL641E(1)

2346463(1)

2347581(1)

UH260E(1)

2348027(1)

2348344(1)

2348341(1)

2348340(1)

2348339(1)

2348336(1)

2348335(1)

2348030(1)

2348025(1)

2347582(1)

2348021(1)

2348012(1)

2348011(1)

2347653(1)

2347650(1)

2347644(1)

2347584(1)

UK929E(1)

UE201E(1)

2348368(1)

5707B035(1)

5707B043(1)

5707B042(1)

5707B041(1)

5707B040(1)

5707B039(1)

5707B038(1)

5707B036(1)

5707B025(1)

5707B045(1)

5707B023(1)

5707B021(1)

5707B020(1)

5707B015(1)

5707B014(1)

5707B013(1)

5707B011(1)

5707B044(1)

5707B046(1)

U6Z97E(1)

U6M38E(1)

U6Z58PE(1)

U6Z55PE(1)

U6Z51E(1)

U6Z43E(1)

U6M41E(1)

U6M40E(1)

U6M39E(1)

U6M27E(1)

5707B047(1)

U5Z48E(1)

U1H88E(1)

5707B053(1)

5707B052(1)

5707B051(1)

5707B050(1)

5707B049(1)

5707B048(1)

2348346(1)

2348369(1)

2352875(1)

2350399(1)

2350435(1)

2350434(1)

2350433(1)

2350403(1)

2350402(1)

2350401(1)

2350400(1)

2350398(1)

2350437(1)

2350368(1)

2350367(1)

2350366(1)

2350365(1)

2350364(1)

2350363(1)

2350333(1)

2350436(1)

2350468(1)

2350331(1)

2351456(1)

2352874(1)

2352873(1)

2352872(1)

2352166(1)

2351461(1)

2351460(1)

2351457(1)

2351409(1)

2350469(1)

2351408(1)

2351405(1)

2351404(1)

2350473(1)

2350472(1)

2350471(1)

2350470(1)

2350332(1)

2350330(1)

2349112(1)

2349607(1)

2350169(1)

2350168(1)

2350167(1)

2350166(1)

2349610(1)

2349609(1)

2349608(1)

2349603(1)

2350171(1)

2349602(1)

2349601(1)

2349179(1)

2349162(1)

2349150(1)

2349133(1)

2349121(1)

2350170(1)

2350208(1)

2350329(1)

2350255(1)

2350328(1)

2350298(1)

2350297(1)

2350296(1)

2350295(1)

2350294(1)

2350293(1)

2350254(1)

2350209(1)

2350253(1)

2350252(1)

2350251(1)

2350250(1)

2350213(1)

2350212(1)

2350211(1)

2350210(1)

E6015QA(1)

 
Product Type

Exchange(322)

 
 
 

© 2024-2025 INK, LLC., All Rights Reserved