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