Create an Excel Application using Amazon MWS

Closed Posted Apr 12, 2014 Paid on delivery
Closed 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.

Amazon Web Services Excel Software Architecture

Project ID: #5796641

About the project

7 proposals Remote project Active May 19, 2014

7 freelancers are bidding on average $268 for this job

dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$250 USD in 15 days
(66 Reviews)
5.5
spaul1107

Hello, I have good experience in creating such projects - interacting with web pages and downloading data into Excel (please refer my closed projects) I also have pretty good advanced Excel skills. I can complete this More

$277 USD in 5 days
(2 Reviews)
1.7
SKBS

Hi! One of the options is to arrange the excel file in such a way that some of the sheets will be allocated to get data copied into them while the reports sheet will be linked to those sheets. New data can be copie More

$155 USD in 5 days
(2 Reviews)
0.2
ChrysalisThorne

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.

$277 USD in 3 days
(0 Reviews)
0.0
cyboticx

DO NOT PAY TILL PROJECT IS COMPLETE! Hi I am Brian, I am from Cyboticx a leading Digital Agency specializing in product + brand development and lead generation optimization. Before getting into more details lets put More

$247 USD in 30 days
(0 Reviews)
0.0
timeataylor

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

$250 USD in 7 days
(0 Reviews)
0.0