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()
=GORILLA_ASINLIST( , , , "FBA")
=GORILLA_ASINLIST( , , "ALL")
=GORILLA_ASINLIST("ALL", "B43")
=GORILLA_ASINLIST("US" , , "INACTIVE", "FBM", "DATE_DESC")

Syntax description

asinlist function box 2104 Gorilla ROI

Description:

Return a list of active and inactive ASINs from your marketplace(s).

Syntax:

GORILLA_ASINLIST([marketplace], [filter_sku], [status], [fulfillment], [sort])

for Gorilla Agency, the syntax is

GORILLA_ASINLIST(sellerID, [marketplace], [filter_sku], [status], [fulfillment], [sort])

marketplace – OPTIONAL

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

filter_asin – OPTIONAL

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 SKUs.
  • ACTIVE lists active SKUs only.
  • INACTIVE lists inactive 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()

If no attributes are entered, it will list all your current active and inactive ASIN from all marketplaces.

=GORILLA_ASINLIST( , , , "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( , , “ALL”)

This will list the entire list of ASINs in your account including all the deleted, inactive, closed, suppressed products. If no inputs are entered like GORILLA_ASINLIST(), the default value is “EXCLUDE”.

=GORILLA_ASINLIST(“ALL”, “B43”)

Lists all ASINs from all marketplaces where the ASIN starts with “B43”.

=GORILLA_ASINLIST(“US” , , “INACTIVE”, “FBM”)

This will list all inactive FBM ASINs for the US marketplace only. Will also show closed, inactive, deleted, suppressed ASINs.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_ASINLIST(“SELLER ID”)
=GORILLA_ASINLIST(“SELLER ID”, , , “ALL”, “FBM”)
=GORILLA_ASINLIST(“SELLER ID”, “ALL”, “B43”)
=GORILLA_ASINLIST(“SELLER ID”, “US” , , “INACTIVE”, “FBA”, "ASIN_DESC")

How can we help?