Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. GORILLA_SKUASINPARENT() –...

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("TOY STORE", "SKU1234")
=GORILLA_SKUASINPARENT("TOY STORE", "B00YD545CC", "ASINPARENT", "DE")
=GORILLA_SKUASINPARENT("TOY STORE", A1:A1000, "SKUPARENT")
=GORILLA_SKUASINPARENT("TOY STORE", A1:Z1, "SKUPARENT", "US")

Syntax Description

SKUASINPARENT 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(Seller ID, SKU/ASIN, [direction], [marketplace])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

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("TOY STORE", "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("TOY STORE", "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("TOY STORE", A1:A1000, "SKUPARENT")

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

=GORILLA_SKUASINPARENT("TOY STORE", A1:Z1, "SKUPARENT", "US")

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