I've recently been let down by a developer who was employed to create an application that sits between my eBay store and my supplier.
The main function of this application was be to keep the eBay store listings synchronised with my supplier's products. The application would needed 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 my supplier's site via it's API and apply the following rules:
i) No changes – No action necessary
ii) Price has changed - If the supplier's 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 supplier's price is more than £20, then the eBay listing is ended.
If the new supplier's 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 supplier's 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 supplier's APIs.
Details of the Supplier's API will be provided via the PMB.
As I understand it, my previous developer has created the database and all the rules abover are in place, all that's left is for the respective Ebay auction to be updated.
This is going to be done via eBay file exchange. The script will need to submit a CSV to the ebay file exchange detailing the changes necessary to the ebay store (Ebay File Exchange user guides will be provided).
As my previous developer is uncontactable, the chosen developer will be required to look at the current code, figure out what it does and finish off this project so that teh script is able to upload the auction changes to eBay.