Article Summary (TL;DR)
✅ Techniques for obtaining the lowest listing price on Amazon, particularly useful for reselling items and competing for the buy box.
✅ Two methods provided by Gorilla ROI within Google Sheets: GORILLA_MYPRICE for displaying your price and GORILLA_LOWESTOFFER for including prices from other sellers.
✅ Examples of formulas are given, such as =GORILLA_MYPRICE(“SKU”) and =GORILLA_LOWESTOFFER(“SKU”, “default”, “fullwithheader”), which allow users to view their price and the lowest offered price for a specific SKU.
✅ Read until the end for a FREE spreadsheet template available to Gorilla ROI members.
Getting the lowest Amazon listing price
This works the best if you are reselling items and competing with other sellers for the buy box.
Without leaving Google Sheets, you can pull the price being offered on the listing using 2 methods we provide at Gorilla ROI.
=GORILLA_MYPRICE( SKU )
=GORILLA_LOWESTOFFER( SKU )
GORILLA_MYPRICE will display your price only.
GORILLA_LOWESTOFFER also includes prices from other sellers.
If you did something like:
=GORILLA_MYPRICE("839-JDK-93K")
where the SKU (839-JDK-93K) has 5 other sellers, then it would show the price that you are selling for. If you have a sale price set up, this function will display your current sale price that will show up in the buy box.
=GORILLA_LOWESTOFFER("839-JDK-93K")
This function will return the lowest price that is currently being offered. This is not the buy box price. Another offer could be lower but not be in the buy box based on Amazon’s algorithm.
To view all the sellers listed on this SKU, enter more variables to define what you want to see.
=GORILLA_LOWESTOFFER("839-JDK-93K", "default", "fullwithheader")
This is the easiest example to display all sellers where;
- the SKU “839-JDK-93K”
- default marketplace (US, UK or whatever your main marketplace is)
- will display all the headings in a table format
If there are multiple sellers for the SKU, this formula will create a row for each seller and display the full stats of each seller.
“Default” refers to your main marketplace.
“Fullwithheader” creates another row before the results with the table headers to make it easy to identify.
Combine MYPRICE and LOWESTOFFER
A good tip is to use both MYPRICE and LOWESTOFFER to get your Amazon listing price. Put it together in a spreadsheet side by side.
Let’s say you load myprice for all your SKU’s in column A.
You then load the lowestoffer for all your SKU’s in column B.
If you can see and compare the price from column A and B, you know:
- you are not the cheapest
- or your private label listing may have been hijacked
- who the other sellers are and how many you are competing against
Free spreadsheet template for Amazon listing price and trend
Click the image above to see a preview of how it looks.
This spreadsheet is available to all Gorilla ROI members.
It’s available at Your Account > Basic Spreadsheets > BASIC] AMZN Reviews and Prices.
How I created this spreadsheet
The spreadsheet uses a mix of:
- GORILLA_MYPRICE
- GORILLA_LOWESTPRICE
- GORILLA_REVIEWS
- GORILLA_RATINGS
- GORILLA_SALESCOUNT
- GORILLA_CATEGORY
GORILLA_MYPRICE is used to bring in my price that I am selling for.
GORILLA_LOWESTPRICE pulls in the lowest price from the listing.
GORILLA_REVIEWS gets the user reviews for the product.
GORILLA_RATINGS displays the average review rating.
GORILLA_SALESCOUNT is used to get the last 30 days of units sold for a better dashboard.
GORILLA_CATEGORY grabs the product category for easier filtering.
All the data is then loaded automatically to create an all round dashboard that provides more context than the standard pages that you see on Amazon’s backend.
Short video explainer of the spreadsheet
To get a quick idea of how the spreadsheet is set up and work, watch the video below.
Comments
Related Posts
3 Key Strategies for Accurate Amazon Inventory Forecasting
In the fast-paced world of e-commerce, staying ahead of the…
Mastering Amazon Seller Central Integration: Unlocking Real-Time Data Sync Without Coding Hassles
Getting your Amazon Seller Central data integrated with other platforms…
How to Use the Amazon Investment Calculator for Accurate Forecasting
Running an Amazon business can feel like steering a ship…
Leave a Reply