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

How can we help?