I would like an interface developing within Microsoft access vba (not php!) that integrates into Amazon MWS (Merchant Web Services) and allows:
1. the upload of a new product to Amazon. This product may be a complex product i.e. it has a set of sizes and colours that need to be selected
2. upload of ammended pricing data to Amazon
3. the upload of inventory count data to Amazon
4. the download of orders including customer details and specific items ordered and prices paid
5. upload of order dispatched information to Amazon to update fullfilled orders.
The format of data within Access is not important. You will be expected to provide a working access database together with sample data that interacts with an Amazon seller account in each of the 5 ways above.