This one will be using the same database as the original [login to view URL] script you created for me, but will be primarily using the ebay finding [login to view URL] to the amount of listings in the database, the finished product will need to go through the ebay appoved application process (just like the [login to view URL] script you created for me originally).
The purpose of this script is to keep all eBay listings competetive by checking competitor prices on eBay and adjusting prices accordingly. Due to the fact that I already have 2 scripts running on the database every hour, this script will need to incorporate both the ebay checking and listing revision in the same script otherwise I risk other scripts ovewriting any changes this script requires.
I'm open to suggestions on how best to achieve this but have come up with the following plan:
1) Create additional fields in the database for:
ebay_keywords
floor_limit
competitor_price
2) Script updates the floorlimit field on the DB record with a value equivalent to ((((Price/100)*112.2) 0.45) - this represents the minimum amount I'm willing to list that item for.
3) If DB record Status = Processing, then use the finder api to search for all listings with the keywords found in the keywords field applying the following search filters:
Fixed Price Listing
Condition:New
max_price=(Price 3.5)
excluding seller : cobalttiger
4) Update the Competitor_price field with the value of the lowest price returned (the lowest price being a combination of the ebay price and postage costs i.e. an item with a £2.00 price and a £2.00 postage cost is greater than an item with a £3 price and free postage).
5) If the competitor_price > Price 2.9 then update the markup field to 2.9
6) If the competitor_price < floorlimit value then update markup field to a value equivalent to ((floor_limit 0.01)-Price)
7) If no results are returned then update the markup field to 2.9
8) Else, update the Markup field to a value equivalent to ((competitor_price - 0.01)-Price)
9) Script then revises the price of the eBay listing to an amount equivalent to (Price Markup).
10) Script moves onto the next record and begins process again
The budget for the project is $300 (all inclusive) which is to includes getting the script through eBay's approval process.