Amazon Price Tracker
Both buyers and sellers want to know the price of products listed on www.amazon.com which often vary frequently.This simple Excel VBA sheet help you to track the details such as Title, List price ($), Price ($), Sale Price ($), Weight and Number of Reviews for the products.(Amazon Price Tracker)
Pull those details in Excel sheet with on single click. All you have to do is to add the ASINs for the list of products that you want to track in the column A of sheet “Amazon Price Tracker” as shown below
You can find two buttons “Update ASIN Details” and “Mac user Click Here”. If you are using Windows OS then click on button “Update ASIN Details” to start tracking the details. If you are using Mac OS then click on button “Mac user click here” to start tracking.
For Window users, after you click on button “Update ASIN Details”, you’ll be prompted with Message “Do you want to update ASINs details” with Yes or No button. Click on the Yes button to proceed.
You can track the progress in Progress bar as shown below
What to do before running the script?
Amazon is a very high end websites contain lot of high resolution images and large amount of text data in single link so it consumes more time for scraping. To reduce the time to some extent please follow the below steps in your internet explorer
Click the Tools menu and select Internet Options from the menu list.
Navigate to Advanced tab and scroll down to Multimedia section.
Unmark the Show pictures checkbox.
Click OK. The setting takes effect immediately upon refresh.
And then Go To Tools ->Manage Add ons. Remove some unwanted addons for better performance.
The Amazon price tracker is available in both free and premium edition for $2. Free Tracker allows you to track up to 20 ASINs and the premium editions allow you to track any number of products.I request you to check the feasibility of this macro with your Operating system by downloading the Free version first before purchasing a Paid version. If free version is working fine your PC then you can go ahead and purchase Paid version.