Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_ASINLIST() – Get ...

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.
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.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.