I have a need for a scheduled download of a top 100 product in Amazon category and load them into our MySQL database.
We will have two tables. One table will have a list of categories that we want to monitor the second table will have the results of the pull. We want to schedule the pull weekly and input the year, week, and date of the pull to identify the job.
The data we are looking for from Amazon is
- Product Name
- Category ID (numberic I believe) - It will run the code for the IDs that we have in the other table
- Category Name
- Salesrank in that category
- Lowest price with shipping included
- Number of sellers
We do a lot with Amazon and would love to build a relationship for future work, including repricing, more frequent downloads of specific ASIN. Competitor analysis with their ASINs, pricing, and inventory levels.
Looking forward to get to know a good developer and do lots of work.
P.S. Our shopping cart is Magento, so if someone is also knowledgeable in Magento it would help to build the relationship.