Solved

Amazon Pricing API

Posted on 2010-09-19
4
750 Views
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.
0
Comment
Question by:bpfsr
  • 2
4 Comments
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 33711718
0
 

Author Comment

by:bpfsr
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
0
 
LVL 1

Expert Comment

by:lynxIT
ID: 33712836
Have you checked out
http://www.phpclasses.org/package/642-PHP-A-PHP-XML-class-to-access-Amazon-API-they-released.html

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.
0
 
LVL 1

Accepted Solution

by:
lynxIT earned 500 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
http://docs.amazonwebservices.com/AWSEcommerceService/4-0/PgCombiningOperations.html

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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you using email marketing software? If not, you're missing out on effortless marketing and the reaching of desired conversion rates through email marketing software.
SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now