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
Bulk retrieve the listing status of ASINs in your account.
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)
Use an ASIN to filter the results. This can be a range of values, such as A1:A100, where the cells contain values like ASIN111, ASIN222, ASIN333, or ASIN123.
Fulfillment – (OPTIONAL)
‘ALL’ shows any ASINs matching the search criteria. ‘FBM’ displays SKUs fulfilled by the merchant only. ‘FBA’ displays ASINs fulfilled by Amazon only. The default is set to ‘ALL'
Usage & Examples
=GORILLA_ASINSTATUS("TECH SHOP", "US", A2:B100)This will return "active" or "inactive" for all ASINs listed from A2 to B100 in the US marketplace. The function supports 2D arrays, allowing values from both column A and column B.
=GORILLA_ASINSTATUS("TECH SHOP", , A1:A1000)If the marketplace is omitted, the listing status of ASINs will be retrieved from the default marketplace linked to your account. Use ranges in your formula to retrieve results in bulk.
Output Screenshot
