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

🚨 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_SKUASINPARENT(“SKU1234”)
=GORILLA_SKUASINPARENT(“B00YD545CC”, “ASINPARENT”, “DE”)
=GORILLA_SKUASINPARENT(A1:A1000, “SKUPARENT”)
=GORILLA_SKUASINPARENT(A1:Z1, “SKUPARENT”, “US”)

Syntax Description

gorilla function parent sku asin 1 Gorilla ROI

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 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_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”)

How can we help?