Video Tutorial
⚠️ IMPORTANT NOTICE
Optimize Your Formula Usage
Use ranges (e.g., A2:A1000) in your formula whenever possible to ensure faster results and to prevent Google from blocking your account for 24 hours due to excessive resource usage.
Syntax Screenshot
Description
Returns the active or inactive status of ASINs in bulk.
Syntax
GORILLA_ASINSTATUS(Seller ID, [marketplace], ASIN, [fulfillment])
Parameter Descriptions
Seller ID – (REQUIRED)
Seller ID or Nickname found within the Gorilla App to work with.
Market place – (OPTIONAL)
Marketplace country filter.
If left blank, the Main Marketplace in the Gorilla App will be used.
Valid inputs:
Valid inputs:
ALL (All Marketplaces)
US (USA)
CA (Canada)
MX (Mexico)
BR (Brazil)
BE (Belgium)
UK (United Kingdom)
DE (Germany)
FR (France)
ES (Spain)
IT (Italy)
ZA (South Africa)
NL (Netherlands)
SE (Sweden)
PL (Poland)
TR (Turkey)
SA (Saudi Arabia)
EG (Egypt)
AE (United Arab Emirates)
JP (Japan)
AU (Australia)
SG (Singapore)
IN (India)
IE (Ireland)
EU (includes all European markets except the UK)
EURO (combines countries using the Euro currency)
ASINs – (REQUIRED)
ASIN to filter the results. Can be a string like "ASIN111", or "ASIN123", or a range like A1:A100 where A1 to A100 consists of inputs like ASIN111, ASIN222, ASIN333 etc.
Fulfillment – (OPTIONAL)
Fulfillment method of the ASIN.
ALL will list FBA and FBM ASINs.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
all (DEFAULT)
FBM
FBA
Usage & Examples
=GORILLA_ASINSTATUS("TECH SHOP", "US", A2:B100)Returns the active or inactive status of ASINs listed in cells A2 to B100 for the seller “TECH SHOP” in the US marketplace.
=GORILLA_ASINSTATUS("TECH SHOP", , A1:A1000)Returns the active or inactive status of ASINs listed in cells A1 to A1000 from the default marketplace linked to your account for the seller “TECH SHOP”.
Output Screenshot
