Project is to create a PHP script to check Amazons current marketplace prices for amazon price, new and used and to log them in a db along with the ASIN and timestamp.
The script will take the list of ASINs to be checked from a table called product_main (field name asin) , query Amazon Web Service and insert the data into a table called amazon_prices or update the relevant ASIN row if the ASIN already exists in the table.
The script will reference from a table amazon_exclusions a list of merchants not to be compared against. From this it will then log in the table amazon_prices the amazon price, the cheapest used price available and the cheapest new price available where the merchant is not in the exclusions table.
Fields to include (but not exclusive if you feel more fields are needed):
New Price Merchant Name
New Delivery Price
Used Price Merchant Name
Used Delivery Price
The script should also log in the table if the product is not available by anyone outside of the exceptions list.
As this script is going to run more than once a day it needs to be able to be written efficiently and check as many prices as possible with the fewest requests to amazon.
It would also be useful to have an amazon_ table to report when the script last ran and when it finished and how many products were checked.
Any further questions let me know