Google Sheets Functions

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

GORILLA_BUYBOXPRICE() – Get the current winning buy box price

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("TOY STORE", "B00YD545CC", "DEFAULT", "NEW", "FULL")

Syntax description

BUYBOXPRICE 1 Gorilla ROI

Description:

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

Syntax:

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

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – REQUIRED
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.

condition – OPTIONAL
Item condition. Default is Any.

  • 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

  • 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 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("TOY STORE", A1:A1000, "US", "ANY", "PRICE")

Returns the lowest offered buy box prices only for all SKUs in A1:A1000. Pulls from the US market for any condition.

=GORILLA_BUYBOXPRICE("TOY STORE", "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("TOY STORE", "B00YD545CC")

If only the SKU is entered, it will display the price of the buy box only.

How can we help?