Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_BUYBOXPRICE() – Get list of sellers competing for the buy box

GORILLA_BUYBOXPRICE() – Get list of sellers competing for the buy box

Sample Usage

GORILLA_BUYBOXPRICE(sku, [marketplace], [condition], [returnStyle], [priceType])

Get amazon buy box price

Syntax description

Get the current buy box price of the seller winning the buy box.

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.


    returnStyle

    OPTIONAL – 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.

  • pricetype
    OPTIONAL – 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 closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

    =GORILLA_BUYBOXOFFERS(“B00YD545CC”, “US”, “TRUE”)

    Returns all sellers for the listing in the US market along with details of the buy box. A header row is automatically generated.

    =GORILLA_BUYBOXOFFERS(“B00YD545CC”, “DE”, “FALSE”)

    Returns all sellers for the listing in the German market along with details of the buy box. A header row is not present. Only the data is displayed.

    =GORILLA_BUYBOXOFFERS(“B00YD545CC”)

    If only the SKU is entered, it will display data for all sellers in the default marketplace and include the header in the table.

    For Gorilla Agency, the 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”)

     

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?