Table of Contents
Sample Usage
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
GORILLA_BUYBOXPRICE(sku, [marketplace], [condition], [returnStyle], [priceType])
Syntax description
Description:
Get the current buy box price of the seller winning the buy box.
Syntax:
GORILLA_BUYBOXPRICE(sku, [marketplace], [condition], [returnStyle], [priceType])
for Gorilla Agency, the syntax is
GORILLA_BUYBOXPRICE(seller ID, sku, [marketplace], [condition], [returnStyle], [priceType])
sku
SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below. If a range of SKU is used in the formula, it will display the buy box price only.
marketplace
OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, DE, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
-
- NEW = only displays the prices for products that are being sold in NEW condition.
- USED = only displays the prices for products that are being sold as USED condition.
returnStyleOPTIONAL – Displays the results in a table or as a list of prices.
- Default results show the price for the lowest price for each SKU/ASIN provided.
- FULL – loads all buy box data like price, fulfillment channel, offer count, listing price, suggested price, landed price.
- FULLWITHHEADER – shows the “full” data with a header row as the first row.
pricetypeOPTIONAL – Displays the results as either the following:- LandedPrice – Displays the results based on the LandedPrice of the SKU that is entered in Seller Central
- ListingPrice – Displays the results based on the ListingPrice of the SKU that is entered in Seller Central
- ShippingPrice- Displays the results based on the ShippingPrice of the SKU that is entered in Seller Central
Examples:
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_BUYBOXPRICE(A1:A1000, "US", "ANY", "PRICE")
Returns the lowest offered buy box prices only for all SKU’s in A1:A1000. Pulls from the US marketing for any condition.
=GORILLA_BUYBOXPRICE("B00YD545CC", "DEFAULT", "NEW", "FULL")
Returns the buy box price for the ASIN in the default marketplace. Looking up NEW condition products only. Full results are displayed with no header in the table of results.
=GORILLA_BUYBOXPRICE("B00YD545CC")
If only the SKU is entered, it will display the price of the buy box only.
For Gorilla AGENCY, the same formulas will start with the seller ID:
=GORILLA_BUYBOXPRICE("SELLERID837834", A1:A1000, "US", "ANY", "PRICE")
=GORILLA_BUYBOXPRICE("SELLERID837834", "B00YD545CC", "DEFAULT", "NEW", "FULL")
=GORILLA_BUYBOXPRICE("SELLERID837834", "B00YD545CC")