Using msaccess 2007 we need to make the following 4 API calls to Amazon.
1- GetReport ReportID = 9952180983 - Returns all our current listings including ASIN, seller SKU, etc.
2- Getlowestofferlistings by ASIN - Returns all seller's prices, landed cost, if multiple sellers are at the same price, etc. - EXCLUDING ourselves, NEW ITEMS ONLY
3- Getcompetitiveprice by ASIN- Returns buy box price and if we own it or not, etc. - NEW ITEMS ONLY
4- SubmittFeed - to change our price and quantity available
The database will contain 3 tables, one for each GET API call.
GetReport table field list
1-seller sku
2- price
3- Quantity
4- ASIN -primary key
Getcompetitiveprice by ASIN field list
1- buy box price
2- Landed Price
3- Shipping
4- buy box belongs to requester, yes/no
5- ASIN - primary key
Getlowestofferlistings by ASIN field list
1- Lowest Landed Cost (excluding ourselves)
2- handling time
3- fulfillment channel
4- ASIN - primary key
Program Flow:
1- GetReport ReportID = 9952180983 - Returns all our current listings including ASIN, seller SKU, etc. Populate table
2- Loop through all our current listings calling the following 2 api calls
a- Getlowestofferlistings by ASIN
b- Getcompetitiveprice by ASIN
VERY IMPORTANT: when making the getlowestofferlistings and getcompetitiveprice calls submit as MANY ASINs as possible for each call. We have over 100,000 items listed on Amazon. This project must call more than 1 ASIN at a time. We believe the max number is 200 ASINs at once.
3- We will insert our own code which will re-calculate our selling price and update the quantity available. READ TWICE, we will insert our own code to re-calculate our selling price and update the quantity . You do not have to write the code for this step. We will do it.
4- SubmittFeed to update our selling price and quantity available.
The database has to be well documented, (comments throughout the code).
The database has to have complete error trapping. Checking to see if the Amazon status is green before making the API call, etc.
Do not bid on this project unless you have successfully called ALL 4 API calls listed above from msAccess2007.
Please feel free to ask any questions before bidding.
let me work with this script.
i have recently implemented the script using amazon mws api see my recent work for the technical expertise along with reviews & feedback on my profile page.
i will implement the script in php.
let's start if you are interested.