We sell on Amazon in UK, France and Germany using the Seller Central platform. We require a script that will run daily via Cron, to do the following:
- Download all of the new orders placed that day (all order data available from Amazon, including contact details for buyers) onto a MySQL database
- Update our order database by checking for orders that have been canceled or dispatched that day
- Send a template email to buyers whose orders were dispatched 3 working days ago (excluding those where the order was dispatched late)
Any questions, please email me. You need at have access to a developer account with Amazon, you can't test with our live account.