ASIN to EAN converter
Since I was needing an EAN to ASIN converter and ASIN to EAN converter (UPC/barcode and Amazon code), but could not find any on the web, I decided to write one myself. It is always fun to learn a new API (here I used Amazon Web Services). And when it works exactly as you expect, you are definitely API!
You can input several codes (batch mode) by separating them with « ; » (semicolon). The output will be one column with the original code and another with the converted code.
So, long story short, here comes the beauty, and the beast (also available here on a dedicated page/window):
<iframe style="border: solid 1px #ccc;" src="https://www3.erwinmayer.com/labs/asin2ean/" width="490" height="630"></iframe>
Latest features:
30/12/2014: Tab in URL and locale persistence.
19/12/2014: Responsive/Mobile-friendly version.
09/12/2014: Much faster batch operations & UI rewritten for easier readability.
09/06/2014: UI improvements for batch operations.
30/04/2014: Added support for BR (Brazil) and IN (India) locales.
02/10/2011: Added support for ES (Spain) locale.
27/08/2011: Added support for IT (Italy) and CN (China) locales.
Please feel free to report any bug you might encounter, or suggest improvements.
I may be available for consulting work on a case by case basis. Just drop me a note if needed.
41 commentaires
Good Day!
This is nice. I’m looking for the other way round 🙂
Any chance to have a look at your code? I’d love to write the counterpart ean2asin / eantoasin …
Thanky You!
Le bonjour to France
Hello Fred J,
I’m reviewing your query. It’s a little more complicated to to the reverse thing (you have to specify a « SearchIndex » parameter in the request).
However I’ll do it soon and release it here.
Cheers
Hi there,
This is a wonderful app.
Would you mind letting me know (or showing me the code) that does this conversion?
I have to do batch conversions, and knowing the process would greatly help me out.
Thanks
Fred J, I have added the feature you requested. You can now also do an EAN to ASIN conversion. For the moment only France, USA, and Germany are supported, but if required I can add others quite easily.
Note that for the EAN to ASIN conversion, you need to specify the Search Index, i.e. the category of the article. But for the USA locale, it is not necessary since the category « All » exists.
Warjat, I’m glad you appreciate. FYI, I will surely include a mass ASIN to EAN conversion feature in the future (within a few months). You will have to input coma separated ASIN codes, and it will give you a correspondance table.
Hi, this converter is awesome! It’s helped me search for and find, some really rare CD’s to add to my collection 🙂
Thank you so much!
p.s. out of the hundreds of ASIN no.’s I have tried only 1 does not work on either US, France or Germany setting. ASIN B0000932E8 – do you know why this could be??
Hello Mori, thanks for your interest.
I have checked that ASIN, which is an Evanescence CD.
It has not the same behaviour in the Germany Store, where it is referenced. The output is blank, while France and USA give an error.
I have tried to get the full result of a request, and the EAN is apparently not available for this product. So there is no need to check further!
Thanks Erwin for your help and quick reply! Much appreciated as I am a big Evanescence fan.
Thankyou, Mori
FYI I added today UK, Japan and Canada support.
Hi, this is indeed a great tool!
Anyhow, as I have a file of >1.000 items to be converted from ASIN to EAN, I wanted to see if there is some progress on the mass ASIN to EAN conversion feature. I entered several ASIN-numbers separated by coma but I did not seem to be already working.
Thanks in advance for your answer and best regards,
Thomas
Hi Thomas,
I’ll do it right now… 🙂
Stay connected.
You can now use semicolumns to process a lot of codes at the same time, as explained in the updated description.
Greetings,
Thanks for releasing this code! I have to convert a large number of ASIN as Amazon canceled my account (since the account is based in Colorado).
–RayJH
Hello!
Very good Tool – but is it possible, to get some other countries in the search? I need poland for example…
Greets
Andreas
Hallo Andreas,
As far as I know, there has been no Polish version of Amazon as yet.
Best,
Erwin
Your ASIN to EAN converter is wonderful!
Please, please, please: could you add for EAN-to-ASIN also the query to the italian site, Amazon.it?
All the italian people will be grateful to you, so we will distinguish between the italian guarantee and the international!
Thank U!
Maxim
Hello Maxim, I have just added support for Italy and China! I have also upgraded to use the latest version of the API (2011-08-01) to be ale to use more up to date search indices, and especially the « All » search index.
i just noticed the upgrade 🙂 very much appreciated!
j’ai creer une page avec votre fonction.
en mode EAN2AQSIN
j’ai une erreur 405 dans l’edit du ASIN
je n’arrive pas bien a comprendre quels sont les cles a mettre
car je pense que c’est du a cela.
je debute sur amazon.
je cherche une fonction qui me donnerait le code ASIN a partir du code EAN13.
voici la page :
http://www.les-chemins-d-hermes.com/asin_to_ean_converter2.htm
par avance Merci Pierre
Hi Erwin,
As you know, to sell on Amazon, an EAN or UPC is needed for creating listings.
I am having great difficulty in sourcing these codes.
There are some products being listed already on the site which are the same as my potential listing.
What is the best way to start a listing?
Should I use existing product ASIN’s which i convert using your
asin-2-ean app?
or should I create a new ASIN? but to do so would require ean/upc info which I do not have…
please help !!!
Hi Sonny, depending on the products you have, you should in priority use existing EAN/ASIN codes if any exists. If you cannot find them on your products (bar codes), then I know some commercial databases may be able to help you.
Hi Erwin
Very useful tool indeed – I have been using it for a while, saved me a lot of hassle – thank you very much!
However I noticed it stopped working today – the products would show in an ad box properly but the EAN box remains empty…
Kind regards
Mick
Hi Mick, this tool is limited by the API quotas; if you hit them it should start working again on the following day.
Hello, I tried your system but does not work. I put the code ASIN: B000VAHC46 (italian Amazon), but does not give me any code AEN. It ‘s my problem, or is the system that does not work? Thanks for the answer
Hello Michele, apparently this item has no EAN code for the moment, this is strange. However the ASIN code does work (you can see the banner link to the product).
Hi Erwin,
your converter for the ASIN to EAN doenst work for amazon.com this time?
Do you know how to repair it?
kind regards
Hi, there are usage limits to the use of the Amazon API, so you should just wait and try again. It works right now.
hi
I have a huge list of ASIN number , how do i convert it to EAN by using your tool. i see we need to enter one by one and then convert right? is there any way… any help would be appreciated ..
Hi shabareesh, please send me more information using the contact form. Thanks.
some asin numbers don’t run in your program, a sample ftom this USA Asin:
B008AWTZPQ
What it’s the problem or mistake?.
Thanks!
Hi artur, some items may be listed on Amazon and obtain an ASIN code even though they were never assigned an EAN, which could explain the impossibility to convert to EAN that you observed.
using your snippets in production use. very useful 🙂
Hi,
Although I don’t use it a lot but I like this tool so much, it’s very useful
what is the value of donation that you want?
Thanks
Hi Erwin,
I just came across your site and thought this may be a godsend. I need to batch convert a significant amount of ASIN to my database based on EAN and or UPC and or GTIN
Even better if there is also a product attached
Is there a way I can do this through you or your site? I have more than 1million ASIN in winzip txt format, I need to update my system to match this. Let me know if you can help
I’m not a programmer so you can appreciate my pain with the recent Amazon changes.
Best regards
Hi Erwin,
Im using Erwinmayer for past 2 years. Im not able convert ASIN to EAN now.
What happend? why conversion is not working? Please make it online.
Thanks.
Hi Madhan,
Thanks for reporting the issue. It should work again now.
Hello Erwin,
thanks for your wonderful tool it helped me a lot today and it will help me in the future
Would it be poosible to use a txt-file with ean or asin (not both in same file) underneath each other
for example
B00XYZ1ABC
B00XYZ1ABD
B00XYZ1AEF
B00XYZ1AGH
B00XYZ1AIJ
and let it be converted, this would be great
if you think it would be to much work, then i ask you friendly for both codes ean2asin and asin2ean, then i can try to use them on an excelfile
if i have success, i would send you a copy
Thanks in advance
Michael Hoy
Hi Michael,
The easiest way is to replace all new lines (« \r\n ») by « , » or « ; » in Notepad++ or another text editor (or in Excel with a formula), then to paste the result and click « Convert » (it will be processed in batch mode).
New lines are not directly supported as separators for now and will be stripped instead (I could change that or allow uploading an input file if there is more demand).
Hi Erwin,
Thank you for sharing your tool it’s quick and precise.
Best regards.
It is very helpfully for my work.
Thank you so much
Hey, thanks for making and puttin’ this out. I use it nearly every day or so. Really makes me API 🙂
Hi Erwin,
your tool ist super.
Rudi