Google Sheets Functions

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

GORILLA_SKULIST() – Get the list of SKUs from your account

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("MY TOY STORE")
=GORILLA_SKULIST("MY TOY STORE", , , , "FBA", "SKU_ASC")
=GORILLA_SKULIST("MY TOY STORE", , , "ALL")
=GORILLA_SKULIST($A$1, "UK","IPHONE")
=GORILLA_SKULIST($A$1, "US" , , "ACTIVE", "FBM")

Syntax Description

SKULIST FH Gorilla ROI

Description:

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

Syntax:

GORILLA_SKULIST(Seller ID, [marketplace], [filter_sku], [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_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.
Default is set to ALL to show both active and inactive SKUs.

  • ALL lists both active and inactive SKUs.
  • ACTIVE lists active SKUs only.
  • INACTIVE lists inactive SKUs only.

fulfillment OPTIONAL
Valid values are ALL, FBA, FBM.
Default is set to ALL to show both FBA and FBM SKUs.

  • All lists both FBA and AFBM SKUs
  • FBA will only display FBA SKUs.
  • FBM will only display FBM SKUs.

sort – OPTIONAL
Valid values are DATE_ASC, DATE_DESC, SKU_ASC, SKU_DESC.
Default is set 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("MY TOY STORE")

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

=GORILLA_SKULIST("MY TOY STORE", , , , "FBA", "SKU_ASC")

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

=GORILLA_SKULIST("MY TOY STORE", , , "ALL")

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

If no inputs are entered like GORILLA_SKULIST(“MY TOY STORE”), the default value is “ALL”.

=GORILLA_SKULIST($A$1, "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("MY TOY STORE", "US" , , "ACTIVE", "FBM")

This will list all active FBM SKUs for the US marketplace only.

How can we help?