The job will be to write a script that can:
1. Read a spreadsheet to acquire ISBN and Price (our stock take data)
2. Query Amazon API against the ISBN to acquire book data and store an image file
3. Output to a .csv file for uploading to Our E-commerce Store
The final output .csv will need to be in a format that can be uploaded to a Magento E-commerce Store, we will provide a .csv file to show the exact format needed.
The initial spreadsheet to get the data from (our stocktake) consists of only 3 fields, ISBN - Our Price - Our Quantity, we would like to add the data from amazon to complete a products profile for upload to our magento site.