Table of Contents
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
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”)