Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_ASINLIST() – Get list of ASINs from your marketplace

GORILLA_ASINLIST() – Get list of ASINs from your marketplace

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

ASINLIST Gorilla ROI

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.
  • ALL lists both active and inactive ASINs.
  • ACTIVE lists active ASINs only.
  • INACTIVE lists inactive ASINs only.
  • SUPPRESSED lists suppressed ASINs only.
  • Default is set to ALL.

fulfillment – OPTIONAL
Default is “ALL” to 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.

How can we help?