Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SKUASINPARENT() – Get the parent SKU or ASIN based on a child SKU or ASIN

GORILLA_SKUASINPARENT() – Get the parent SKU or ASIN based on a child SKU or ASIN

Sample Usage

=GORILLA_SKUASINPARENT(“SKU1234”)
=GORILLA_SKUASINPARENT(“B00YD545CC”, “ASINPARENT”, “DE”)
=GORILLA_SKUASINPARENT(A1:A1000, “SKUPARENT”)
=GORILLA_SKUASINPARENT(A1:Z1, “SKUPARENT”, “US”)

Syntax Description

GORILLA_SKUASINPARENT() – Get the parent SKU or ASIN based on a child SKU or ASIN 1

Description:

Get the parent SKU or ASIN based on a child SKU or ASIN. Can be done in bulk using ranges.

Syntax:

GORILLA_SKUASINPARENT(SKU/ASIN, [direction], [marketplace])

for Gorilla Agency, the syntax is

GORILLA_SKUASIN("SELLER ID", SKU/ASIN, [direction], [marketplace])

sku – REQUIRED

Product’s SKU/ASIN. Can be an array of strings like {“ASIN12345″,”ASIN67890”} or a big list.

direction – OPTIONAL

  • skuparent
  • asinparent

marketplace – OPTIONAL

  • enter the marketplace you want to get convert to. If you have multiple accounts and the same sku across different marketplaces, use this to narrow the data down.

Examples:

Use closed 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_SKUASINPARENT(“SKU1234”)

For a child product SKU1234, this formula will return the parent SKU by default as the direction has not been entered. The default is to return the parent SKU if nothing is entered.

=GORILLA_SKUASINPARENT(“B00YD545CC”, “ASINPARENT”, “DE”)

When the direction of ASINPARENT is entered, it will load the parent ASIN of the SKU or ASIN you have entered.If the child SKU is sold in multiple marketplaces, you can narrow it down with the marketplace filter.

=GORILLA_SKUASINPARENT(A1:A1000, “SKUPARENT”)

Bulk loads the parent SKU for the SKU or ASINs listed in A1:A1000.

=GORILLA_SKUASINPARENT(A1:Z1, “SKUPARENT”, “US”)

If you have your SKU or ASIN listed horizontally, this will show the parent SKU for the US marketplace.

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

=GORILLA_SKUASINPARENT(“SELLER832J”, “SKU1234”)
=GORILLA_SKUASINPARENT(“SELLER832J”, “B00YD545CC”, “ASINPARENT”, “DE”)
=GORILLA_SKUASINPARENT(“SELLER832J”, A1:A1000, “SKUPARENT”)
=GORILLA_SKUASINPARENT(“SELLER832J”, A1:Z1, “SKUPARENT”)

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?