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_BUYBOXWINNER(A1:A1000, "US")
=GORILLA_BUYBOXWINNER("B00YD545CC")
=GORILLA_BUYBOXWINNER(A1:A1000)
Syntax description
Description:
Returns “winner” or “loser” based on whether you are winning or losing the buy box.
Syntax:
GORILLA_BUYBOXWINNER(sku, [marketplace])
for Gorilla AGENCY, the syntax is
GORILLA_BUYBOXWINNER(seller ID, sku, [marketplace])
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.
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_BUYBOXWINNER(A1:A1000, "US")
Returns “winner” or “loser” for each of the SKU or ASIN listed. The results are for the US marketplace.
=GORILLA_BUYBOXWINNER("B00YD545CC")
Returns “winner” or “loser” for the ASIN B00YD545CC. The default marketplace is used as no marketplace is defined.
=GORILLA_BUYBOXWINNER(A1:A1000)
Returns “winner” or “loser” for each of the ASINs or SKUs listed from A1 to A1000.
For Gorilla AGENCY, the same formulas will start with the seller ID:
=GORILLA_BUYBOXWINNER("SELLERID837834", A1:A1000, "US")
=GORILLA_BUYBOXWINNER("SELLERID837834", "B00YD545CC")
=GORILLA_BUYBOXWINNER("SELLERID837834", A1:A1000)