I'm looking to create a web application which sits between my eBay store and Amazon.
The main function of this application would be to keep the eBay store listings synchronised with Amazon products. The application would need the following functionality:
1) The ability to upload a CSV file into the application's database, this CSV would contain details of the book's ISBN, EBay auction ID, Availability and current price. As I add more and more listings, I will need drop the current database and upload all store listings (current and new) in a new CSV.
2) Twice a day, the web application will query each book's ISBN from its database and compare it with the book's information on Amazon and apply the following rules:
i) No changes – No action necessary
ii) Price has changed If the new Amazon price is less than £20, then the price in the eBay listing would need to be amended to the new Amazon price.
If the new Amazon price is more than £20, then the eBay listing is ended.
If the new Amazon price is less than £20 (and was previously more than £20) a new listing would be created by relisting the original Auction ID
(In the above cases the price in the database would need to be changed to reflect the new Amazon price. If a new listing has been created, the auction ID will need to be substituted with the new listing ID in the database).
iii) The availability is no longer “usually dispatched within 24 hours” – In this event, the eBay listing is ended and the availability in the database updated to reflect the new availability.
iv) The availability has changed to “usually dispatched within 24 hours” – In this event, a new listing would be created by relisting the original Auction ID and substituting the auction ID in the database with the new ID generated.
3) A small summary page stating whether the script is currently running and how many eBay amendments it's made that day (just so I know it's active).
The eBay store is using “Good till Cancelled” listings which retain the same auction ID unless they are cancelled. From what I understand all aspects of this project are possible by using both the eBay and Amazon APIs.