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

GORILLA_SKULIST() – Get a list of SKU’s from your marketplace

GORILLA_SKULIST( ) Function

Description:
Return a list of active and inactive SKU’s from your marketplace(s).

Syntax:
GORILLA_SKULIST([marketplace], [filter_sku])

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 SKU’s like 54145484, 5414345, 54145FD5, you can search for 5414* to list all SKU’s starting with 5414.

Examples:
Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google 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 SKU’s from all your marketplaces.

=GORILLA_SKULIST(“UK”,”IPHONE”)
Lists all SKU’s that start with the phrase “IPHONE” listed on the UK marketplace. You can enter any text string to use as a filter.

How can we help?