Return a list of active and inactive SKU’s from your marketplace(s).
Gorilla Agency, the syntax is
GORILLA_SKULIST(sellerID, [marketplace], [filter_sku])
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.
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.
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.
If no attributes are entered, it will list all your current active and inactive SKU’s from all your marketplaces.
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.
For Gorilla Agency, the formulas will start with the seller ID:
=GORILLA_SKULIST("SELLER ID", "UK","IPHONE")
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.