Track Amazon competitor offers and Buy Box winners in Google Sheets
Know who shares your listings, who holds the Buy Box and how competing prices compare with yours. Hopted brings Competitor Offers & Buy Box data alongside your listing rows in Google Sheets, so you can find pricing opportunities and, for private-label brands, spot potential listing hijackers.
What you can monitor
A lower competing offer or another seller in the Buy Box can explain why a listing deserves attention. Keep these signals beside your own SKU, ASIN, price and marketplace, rather than checking product pages one at a time.
Competitor Offers & Buy Box is an additional source for your listing rows. Start with a primary listing source, such as Listing Details or All Listings, then add the competitive fields. It enriches those rows; it does not create a separate row for every competing seller.
Start with the ready-made monitor
Open Hopted → Pre-made solutions and choose Competitor Offers & Buy Box Monitor. Select the connected stores and marketplaces you want to monitor, then follow the short START HERE guide in the copied workbook.
The monitor brings your offers, current Buy Box position and competing prices together for review. You can filter the sheet to focus on a marketplace, an ASIN or listings where another seller holds the Buy Box.
Set up your own sheet
- Open Hopted in Google Sheets and connect your Amazon Seller Central account.
- Choose a primary listing source, such as Listing Details or All Listings. Include the listing identifiers and your own offer price so you have context for the comparison.
- Add fields from Competitor Offers & Buy Box to the same sheet.
- Select the connected stores and marketplaces you need. Keep marketplace and currency visible when combining them.
- Choose an automatic refresh schedule available on your plan and confirm the setup.
For a wider catalog view, see the All Listings guide.
Understand the seven fields
- Buy Box Offers: the current winning offers returned by Amazon, with seller and offer details for review.
- My Buy Box Share (%): your current share in the returned Buy Box snapshot, from 0 to 100. It is a current signal, not a metric for a historical date range.
- Buy Box Sellers Count: the number of sellers in the returned Buy Box offers.
- Other Sellers Count: the other sellers in the returned offer sample, excluding your connected seller. This is not the total number of sellers on the listing.
- Lowest Priced Offers: a sample of up to 20 New-condition consumer offers, with the offer details Amazon returns. It is not a complete list of every offer.
- Lowest Offer Price Including Shipping: the lowest returned offer price with shipping included, for a more useful comparison with what a shopper pays.
- Competitive Price: Amazon’s competitive benchmark based on external retailers. It is not the lowest Amazon offer or a price guaranteed to win the Buy Box.
To measure Buy Box performance over a past period, use Sales & Traffic by Child ASIN. Its historical Buy Box metrics answer a different question from this current pricing snapshot.
Find pricing opportunities
Filter listings where your current Buy Box share is low or another seller has a lower offer price including shipping. Review the winning offer, your own price and the offer conditions together before deciding what to change.
Compare offers within the same marketplace and currency, and account for shipping, condition and fulfillment. A price gap is a reason to investigate; it is not an automatic recommendation to lower your price.
This source and the monitor import data. They do not change Amazon prices. You decide whether a pricing change fits your margin and selling strategy.
Monitor potential listing hijackers
If you sell a private-label product, an unfamiliar seller on your ASIN or an unexpected Buy Box winner can be an early sign that the listing needs review. Use the seller and offer details to identify potential hijackers and investigate them.
An unfamiliar seller or a low price alone does not prove a counterfeit product or an unauthorized offer. Check the seller and the product before taking action. See Amazon listing hijacker monitoring for the brand-protection workflow.
Availability and refresh timing
Competitive pricing data refreshes at most once per hour. Your sheet’s actual update timing also depends on the schedule available on your plan and on Amazon’s data availability. A faster sheet schedule does not make this source refresh more often than hourly.
Some fields may be empty when Amazon does not return a value for a listing or marketplace. Offer details can change between refreshes, and the returned offer sample is not an exhaustive record of all sellers or past offers.
