I am interested in having a program or script created that I can input an excel file(or .csv - it can be saved either way) that I have with approximately 65k entries of ISBN-13's(and other information about books in the list-each piece of information, in a different column), that will query Amazon against the ISBN to gather the sales rank, lowest used and new price, and trade-in amounts from [url removed, login to view], and put them into a copy of the same excel file in appended columns. (The file I have uses columns A-K in excel. Therefore, the file I would like it to generate would be A-O, since 4 pieces of data are being added to each entry).
I am not particularly picky as to whether to file uses actual excel files or csv, so long as the information retains order, and is searchable and sortable within the excel program.
Optimally this could be run on a daily basis, with a dedicated machine devoted to pretty much dealing with this type of info. I am not sure what the run time is on that many queries, but please let me know if my idea about running this at least once daily is unreasonable for approx. 65k entries.
I apologize if the terminology I used is not perfect(such as difference between program or script) as I am not sure exactly what the solution is in this case, nor an I sure whether the field to input my file would be local on my machine, or have to be hosted on a server somewhere. It appears as you have done enough similar projects to be very highly rated in those fields though, and to know what the best way to approach this is.
I listed the time-frame as 7 Day because I am being pressed to find someone to do this project quickly, but if this is unfeesible, yet the project could still be done with slightly more time, please let me know.
If there is further information, or files needed to make a distinction or decision, please let me know, and I can provide those. I included a sample file. This one has about 8 entries, but is exactly the same format as the ones with 60k+. If you would need to see a whole file for any reason, just let me know.