Amazon To MS Excel Plugin
I’ve been working on a little side project this week while running the FBA business. I use MS Excel an awful lot to:
- Help manage my stock levels
- Workout what needs to be sent to Amazon
- Evaluate wholesale price lists
- Check the current BuyBox price, lowest FBA price, lowest MFN price etc..
- and more
October 28, 2015 @ 2:28 pm
Is this Excel Plugin currently available?
Thank you
November 4, 2015 @ 4:34 am
Hi Krissy,
I haven’t done to much work on the plugin because to be honest there seemed to be very little interest in it from others. I continue to use it how it is but there are a few little bugs with it that I wouldn’t feel comfortable releasing it because of the extra support work I would have to do.
If there was more interest then I would put some more time and effort in but not right at this time.
Rgds
Pete
March 15, 2016 @ 8:15 pm
pete can you send me the beta plug in?
March 10, 2016 @ 7:11 am
Would it be possible to beta try this?
March 10, 2016 @ 10:54 am
Sure. Sending you an email right now.
March 22, 2016 @ 5:07 am
Hello Pete
Can I have a try for this
March 24, 2016 @ 6:22 pm
On it’s way Desi
April 7, 2016 @ 6:51 pm
pete..pls send me downloasd links for Selling Tracking
April 3, 2016 @ 6:15 am
I would love to try your beta if possible. Thanks!
April 8, 2016 @ 12:59 pm
Hi Pete, can I try this as well?
April 30, 2016 @ 7:51 pm
Hi Please could i try this also?
May 16, 2016 @ 8:59 am
It’s no longer available Saskia. Sorry
June 14, 2016 @ 12:39 am
Hi Pete,
Can I try it? It looks great
September 2, 2016 @ 10:10 am
Greatings Pete,
by looking at the other comments it seems that you no longer provide the plugin… but as I’m really interested, if you ever change your mind, I’d love to get it, even if it’s buggy 🙂
Thanks a lot !
Cheers
Nicolas
September 20, 2016 @ 5:33 pm
The Plugin is available Nicolas. Goto sellertools.io and grab it for free 🙂
August 4, 2017 @ 4:57 pm
Plugin is limited to 10 rows ☹️Anyways we can get a full version??
August 4, 2017 @ 5:15 pm
Hey Rahul,
It isn’t limited to 10 rows, that’s a limitation Amazon puts on the MWS API call. The MWS API provided by amazon isn’t designed to bring back more than 10 search results. To do that you would need something that works off different Amazon API’s.
January 7, 2018 @ 12:33 pm
Dear Pete!
I use the plugin everyday, it’s awesome!
Is there a way I can get a review count for an ASIN, via the plugin?
July 16, 2018 @ 8:35 am
Hi Eli, Amazon do not provide review information through their MWS API, sorry.
September 11, 2018 @ 11:01 pm
Hi Pete is this for Amazon.com only ?
September 12, 2018 @ 8:52 am
It will work for nearly all Marketplaces John. I personally use it for: US,UK,FR,DE,IT,ES
September 26, 2018 @ 12:46 pm
Hi Pete,
I’ve almost completely set up the excel plug in. After entering my Seller ID, AWS Access Key ID, Secret Key and Amazon Marketplace ID (A1F83G8C2ARO7P) and then clicking Validate I get the error message saying ”Amazon have not validated the Seller Id for the Amazon.com marketplace”
Any idea how I can get past this? What am I doing wrong do you think? Your advice would be really appreciated!
Kind Regards
Elliot
September 26, 2018 @ 3:39 pm
When the app produces an error at this stage it is 99.9% of the time a copy/paste error. Double check you have entered everything correctly. Make sure to remove any preceding and training spaces on each field.
December 12, 2018 @ 8:39 pm
Hi Pete, congratulations on the great addons for excel (from what I’ve seen in the video), but I have the same problem as the above companion, the error comes out “Amazon have not validated the Seller Id for the Amazon.com marketplace “, As you say, I have checked that there is no blank, I will generally use it for ES, FR, IT, DE, UK.
Can you tell me how to solve this problem? It took 4-5 days with this, and I do not know what to do anymore.
a greeting
February 6, 2019 @ 7:19 pm
This error is often caused by not having .NET 3.5 fully installed on your PC. I give a link to how to install .net 3.5 when you registered. Visit the link to ensure it is fully installed and try again.
January 3, 2019 @ 9:42 pm
Hello Pete,
the last three nights I was locking for a solution to receive mws data by using vba.
I receive data by https://mws-eu.amazonservices.com/scratchpad/index.html – no problem.
But using vba means at first to connect and send the datastream for the api (orders/listorders for example).
Your addin seems to have a solution for this. So could you please give me hint, how to this for my own.
best regards
Fabian
February 6, 2019 @ 7:22 pm
It took a lot of work to get it working for my own work but if you know VBA then just follow along with the MWS documentation to build you MWS API requests. It will take some trial and error but Amazon have documented everything you need.
June 22, 2019 @ 5:00 am
Hi Pete, I have been using this Add-in and it is awesome, thank you. Is it possible to mask the Add-In License Key and the MWS keys and ID or password it? I intend to give a third party to use it for me but I’m scared they would have access to all the Access keys and IDs. Thank you