Amazon Pricing API

Posted on 2010-09-19
Medium Priority
Last Modified: 2012-05-10
I am looking for an Amazon API to update my prices of my inventory (all books by ISBN) on a daily basis. I currently store the inventory in MS SQL Server. Any help steering me in the right direct much apprecaited.
Question by:bpfsr
  • 2
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 33711718

Author Comment

ID: 33712739
Thank you but I had seen that and it is not going to work for me as that is for a single item; I am looking to price an inventory of 300,000 items

Expert Comment

ID: 33712836
Have you checked out

That is a PHP class, so you could write a php script, which retrieves the ISBN of the book from the database and passes it to the Amazon API to retrieve the information, i.e. price, in XML format, which your PHP script can then update the data stored in your database.  The script could be set to run as a CRON job in the middle of the night when your server load and database activity is at its lowest.

Accepted Solution

lynxIT earned 2000 total points
ID: 33712855
Sorry ignore that PHP class! The Amazon API its related to has been depreciated!  The Amazon E-Commerce Service though does all you to do batch requests (ie search for book and DVDs at the same time).

Have a look at

So ... if you have tags against the inventory (i.e. a book on Bill gates might be tagged as 'Microsoft founder, bill gates, windows etc..), you could run the API search on a specific tag, and then update the details on ALL the items returned.  That would be the most efficient way, as your returning more than one item per API call.  

A flag could be set on the database so that you can clearly see which books have been updated that day.  The first time the script runs that day, the first thing it does is to deflag all the books.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In the below post we have mentioned the best hosting type for startups. Also, check out some of the superlative web hosting companies that are proposing affordable web hosting solutions to host your startup website.
Why WooCommerce is one of the majorly favored choices when it comes to having an eCommerce store. This article will acquaint you with some reasons that I believe make it one of the best eCommerce platforms available.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question