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 a list of active, inactive and suppressed ASINs from your account.
Syntax
GORILLA_ASINLIST(Seller ID, [marketplace], [filter_asin], [status], [fulfillment], [sort])
Parameter Descriptions
Seller ID – (REQUIRED)
Seller ID or Nickname found within the Gorilla App to work with.
Marketplace – (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)
Filter_ASIN – (OPTIONAL)
Part of the ASINs to filter results.
The filter will apply to entries that begin with, for example, "B012" to get all the ASINs in your account starting with "B012".
Status – (OPTIONAL)
Status of the ASINs
ALL will list active and inactive ASINs.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
all (DEFAULT)
active
inactive
suppressed
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
Sort – (OPTIONAL)
Order of the ASINs retrieved.
If left blank, the default input will be used
Valid inputs:
Valid inputs:
date_asc (DEFAULT)
date_desc
asin_asc
asin_desc
Usage & Examples
=GORILLA_ASINLIST("TOY STORE")Returns a list of all FBA and FBM active and inactive ASINs across the main marketplace for TOY STORE, sorted by created date in ascending order.
=GORILLA_ASINLIST("TOY STORE", , , "INACTIVE", "FBA", "DATE_DESC")Returns only FBA inactive ASINs across the main marketplace for TOY STORE, sorted by created date in descending order.
=GORILLA_ASINLIST("TOY STORE", "CA", , "ALL", "FBM")Returns all FBM active and inactive ASINs across the Canada marketplace for TOY STORE, sorted by created date in ascending order.
Output Screenshot
