I have a database with 10,000+ Amazon products that include SKU, ASIN, and Price. The script needs to check each products price under the NEW category using the ASIN. This script needs to work off Amazon API. I will set a certain % markup that the script will base price changes off of. The script should be able to process 20,000 products per hour (AWS allows 10 ASIN per call and 2,000 calls per hour) and will run 24/7 all day everyday. Once the script has completed checking all products, a TXT file in the format of the attached file should be created in a certain folder on my server. The TXT file should only have products that changed in price. I should also have the ability to extract all products from the database into a single TXT file when needed.
To summarize the script:
Markup Percentage set to 20%
1) B008H2ETBE at price $11.99 is in database.
2) Script checks B008H2ETBE using API and finds the price is $10.99.
3) $10.99 x 20% markup is $13.19. Script adds ASIN B008H2ETBE at a price of $13.19 to the TXT file. Script updates price in database to $13.19.
4) Script proceeds to next product.
This is a very simple and straightforward script. I DO NOT want this to work off of web scraping. It should run off the Amazon API and be accurate. Please only bid lowest price and only if you have done a similar project before.
Hello Sir, a ready made application of this kind is already out there with more outstanding features. For more detail and snapshot, please refer to your inbox.
Regards,
Mehboob