Google Sheets Functions

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

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

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_BUYBOXOFFERS(“B00YD545CC”, “US”, “TRUE”)
=GORILLA_BUYBOXOFFERS(“B00YD545CC”, “DE”, “FALSE”)
=GORILLA_BUYBOXOFFERS(“B00YD545CC”)

Syntax description

amazon buy box offers

Description:

Get the list of all sellers and offerings on the listing and competing for the buy box. Does not pull information for SKU’s that you do not sell. Only works for SKU’s and ASIN’s in your inventory.

Syntax:

GORILLA_BUYBOXOFFERS(sku, [marketplace], [header])

for Gorilla Agency, the syntax is

GORILLA_BUYBOXOFFERS(sellerID, sku, [marketplace], [header])

sku

SKU or ASIN of the product. Unlike other functions, this one does NOT accept array inputs or ranges like {“SKU12345″,”ASIN12345”} or A1:A100.

header

OPTIONAL – display header in the table of results

  • TRUE = auto creates a header as the first row of results. Selected by default if no values are entered.
  • FALSE = only shows the table of data. No headings or titles.

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_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_BUYBOXOFFERS(“SELLERID837834”, “B00YD545CC”, “US”, “TRUE”)
=GORILLA_BUYBOXOFFERS(“SELLERID837834”, “B00YD545CC”, “US”, “FALSE”)
=GORILLA_BUYBOXOFFERS(“SELLERID837834”, “B00YD545CC”)

How can we help?