Amazon Price tracker with Excel VBA

Amazon Price Tracker

Latest Update: Please try this Amazon Product Scraper tool to scrape advanced product details such as title, price, ratings, reviews, manufacturer, product availability, badge, strike price, etc.,

Here’s a demo of how to use this new tool

Old Blog continues …

Both buyers and sellers want to know the price of products listed on www.amazon.com which often very 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)

Want to check out my advanced amazon tracker on Google sheet which tracks the price automatically on a daily basis and send an email notification if the product is selling at offer price or low price.

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 the 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

 

Related Post

• Amazon price alert tracker on Google sheets
• Auto import stock quotes from yahoo finance with excel macro
• How to get Paid from Amazon KDP via Payoneer
• How to receive Amazon Affiliate Payments via Payoneer
• How to use Payoneer to get paid from top 5 online platforms
• Can I put affiliate links in Kindle ebooks?

This is for Pro!

Are you looking for an advanced tool to track keywords, keyword research, product research, sales tracking, competitor analysis, and reviews?  I suggest you go with amztracker. It works across all Amazon marketplaces.

Try AmzTracker

What to do before running the script?

Amazon is a very high-end website contain a lot of high-resolution images and a large amount of text data in a 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 the Advanced tab and scroll down to the Multimedia section.

Unmark the Show pictures check box.

Click OK. The setting takes effect immediately upon refresh.

And then Go To Tools ->Manage Add ons. Remove some unwanted add-ons 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 the Paid version.