Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SKULIST() – Get a list of SKUs from your marketplace

GORILLA_SKULIST() – Get a list of SKUs from your marketplace

(The instructions from this video is exactly the same for SKULIST)

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_SKULIST()
=GORILLA_SKULIST( , , , "FBA", "SKU_ASC")
=GORILLA_SKULIST( , , “ALL”)
=GORILLA_SKULIST(“UK”,”IPHONE”)
=GORILLA_SKULIST(“US” , , “ACTIVE”, “FBM”)

Syntax Description

skulist function box 2104 Gorilla ROI

Description:

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

Syntax:

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

for Gorilla AGENCY, the syntax is

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

marketplace – 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_sku – OPTIONAL

Part of an SKU to filter result.

The filter will act only at the start of the SKU. If there multiple SKUs like 54145484, 5414345, 54145FD5, you can search for 5414* to list all SKUs starting with 5414.

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 SKUs in ascending order by created date.
  • “date_desc” lists SKUs in descending order by created date.
  • “sku_asc” lists SKUs in ascending alphabetical order.
  • “sku_desc” lists SKUs 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_SKULIST()

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

=GORILLA_SKULIST( , , , "FBA", "DATE_ASC")

This will list only the FBA SKUs for the default marketplace for your account as the other attributes are empty.

=GORILLA_SKULIST( , , “ALL”)

This will list the entire list of SKUs in your account including all the deleted, inactive, closed, suppressed products.

If no inputs are entered like GORILLA_SKULIST(), the default value is “EXCLUDE”.

=GORILLA_SKULIST(“UK”,”IPHONE”)

Lists all SKUs that start with the phrase “IPHONE” listed on the UK marketplace. You can enter any text string to use as a filter.

=GORILLA_SKULIST(“US” , , “ACTIVE”, “FBM”)

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

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

=GORILLA_SKULIST(“SELLER832J”)
=GORILLA_SKULIST(“SELLER832J”, “UK”, “IPHONE”)
=GORILLA_SKULIST(“SELLER832J”, , , “ALL”)
=GORILLA_SKULIST(“SELLER832J”, “US” , , “ACTIVE”, “FBM”, "SKU_ASC")

How can we help?