Create an Excel Application using Amazon MWS
$30-250 USD
Paid on delivery
Serious bidders ONLY. This is not a difficult job, but PLEASE read the following and make sure you can deliver on ALL the key points.
I use Excel to track my Amazon sales and have developed a spreadsheet for the purpose. Until now, I have downloaded copy/pasted several of the reports I use, into my various worksheets but that is time consuming and can lead to errors.
What I’d like for you to do is create a workbook consisting of the following sheets.
1. There will be an “Amazon Fulfilled Inventory” worksheet, which is automatically updated with new data when the user requests it.
2. There will be a “Manage FBA Inventory” worksheet which is automatically updated with new data when the user requests it.
3. There will be an “Amazon Fulfilled Shipments” worksheet. Unlike the two mentioned above, what I want to do is generate the “Amazon Fulfilled Shipments” report, and add any new orders to the existing data in this sheet. This will give me a “master list” of all of the orders that Amazon has ever fulfilled. There should be no data omitted and there should be no duplicate data either.
4. There will be a “fee preview” worksheet. As you should know, if an item is out of stock, it will not appear on this report. So what I am after, is to have a “master fee preview” list that will get updated with new information if it becomes available, but will NOT lose any existing data when an item goes out of stock. In other words, I’m looking for all of the information of the ”fee preview” for every SKU I have, whether that SKU is in stock or not.
This will hopefully at some point become a commercial application that others can use, so I will also need a form that seamlessly requests from the user whatever MMS information the application will need in order to communicate with Amazon.
One last thing. I am not an expert by any means, but I do want to learn more about this platform, so I will want the person that writes this code to please use many more comments within the code that they normally would, so that I can understand what is going on.
As this application develops further, there will be additional work for whoever wins this bid. Thank you for your consideration.
I look forward to working with you.
Project ID: #5796641
About the project
7 freelancers are bidding on average $268 for this job
Good day, I am Chrysalis Thorne, and it would be my pleasure to serve you! Just send me the details of your project with the needs clearly outlined, and I guarantee you will not be disappointed ! Best regards.
Hi, I am currently working in a warehouse as inventory assistant and my daily duties includes to manage the stockpiles that are registered in the physical and online database (SNAP ) . I use lots of formula if nece More