Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_BUYBOXPRICE() – Get the current winning buy box price

GORILLA_BUYBOXPRICE() – Get the current winning buy box price

Sample Usage

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

Syntax descriptionGet amazon buy box price

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.


    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_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")

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?