I am currently operating a Wordpress site with Woocommerce that is not yet launched. I am using a plugin that easily adds Amazon products as affiliate products (along with pictures, description, pricing, reviews), however, the product prices and reviews do not update well. I am looking to add ~400,000 (yes four hundred thousand) affiliate products to my site, and while the plugin can handle adding the products, updating is the issue I have. What I propose is the creation of a parallel product sync tool that will once a day update prices and number of product reviews and review star rating, and I will still use the original plugin for adding products. The star rating and number of reviews should show up under the title beside the price and should link to amazon with my affiliate id. As far as I know, Amazon allows 2000 requests per hour, and you can have 10 products in each, so per day you can update 480,000 products. The bottom line is that prices and reviews need to be updated daily. And if there is a sale price, it should show the regular price as well so that the customer can see they are getting a good deal.
The other function that this tool should have is adding the number of amazon reviews as a product attribute. I would like this function so that I can sort products by most reviewed.
Freelancer should have experience with the Amazon API.
Please let me know if you have any questions.