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_ASINLIST("MY TOY STORE")
=GORILLA_ASINLIST("MY TOY STORE", , , , "FBA")
=GORILLA_ASINLIST("MY TOY STORE", , , "ALL")
=GORILLA_ASINLIST("MY TOY STORE","ALL", "B43")
=GORILLA_ASINLIST("MY TOY STORE", "US" , , "INACTIVE", "FBM", "DATE_DESC")
Syntax description
Description:
Return a list of active and inactive ASINs from your marketplace(s).
Syntax:
GORILLA_ASINLIST(Seller ID, [marketplace], [filter_asin], [status], [fulfillment], [sort])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, UK, CA etc.
filter_asin – OPTIONAL
Part of an ASIN to filter result. The filter will act only on the start of the ASIN like ASINPART*.
status – OPTIONAL
Valid values are ALL, ACTIVE, INACTIVE.
Default is set to ALL.
- ALL lists both active and inactive ASINs.
- ACTIVE lists active ASINs only.
- INACTIVE lists inactive ASINs only.
- SUPPRESSED lists suppressed ASINs only.
fulfillment – OPTIONAL
Default is “ALL” to show FBA and FBM ASINs.
- “ALL” will show FBA and FBM ASINs.
- “FBA” will only display FBA ASINs.
- “FBM” will only display FBM ASINs.
sort – OPTIONAL
Default value is “date_asc” if not specified in the formula.
- “date_asc” lists ASINs in ascending order by created date.
- “date_desc” lists ASINs in descending order by created date.
- “asin_asc” lists ASINs in ascending alphabetical order.
- “asin_desc” lists ASINs in descending alphabetical order.
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_ASINLIST("MY TOY STORE")
If no attributes are entered, it will list all your current active and inactive ASIN from all marketplaces.
=GORILLA_ASINLIST("MY TOY STORE", , , , "FBA", "DATE_ASC")
This will list only the FBA ASINs in ascending order of created date for the default marketplace for your account, as the other attributes are empty.
=GORILLA_ASINLIST("MY TOY STORE", , , "ALL")
This will list all ASINs in your account, including all the deleted, inactive, closed, and suppressed products. If no inputs are entered like GORILLA_ASINLIST(), the default value is “EXCLUDE”.
=GORILLA_ASINLIST("MY TOY STORE", "ALL", "B43")
Lists all ASINs from all marketplaces where the ASIN starts with “B43”.
=GORILLA_ASINLIST("MY TOY STORE", "US" , , "INACTIVE", "FBM")
This will list all inactive FBM ASINs for the US marketplace only. Will also show closed, inactive, deleted, and suppressed ASINs.