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

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

Syntax Description

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

 

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:

=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")

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?