Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SKUASIN() – Convert SKU or ASIN to SKU and SKU to ASIN

GORILLA_SKUASIN() – Convert SKU or ASIN to SKU and SKU to 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_SKUASIN("IPHN3724")
=GORILLA_SKUASIN("B00YD545CC", "sku2asin", "US")
=GORILLA_SKUASIN(D33:E39, "asin2sku")
=GORILLA_SKUASIN(D33:E39,"sku2asin")

Syntax Description

gorilla skuasin Gorilla ROI

Description:

Convert ASIN to SKU and SKU to ASIN. Bulk convert compatible.

Syntax:

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

for Gorilla Agency, the syntax is

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

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

direction
OPTIONAL – Conversion type. If sku2asin (default), first parameter is interpreted as SKUs and ASINs will be returned. If asin2sku, first parameter is interpreted as ASINs.

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.

GORILLA_SKUASIN Attributes

  • sku2asin
  • asin2sku

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_SKUASIN("IPHN3724")

Displays the ASIN for SKU IPHN3724. As the direction is not set, the function assumes the value is a SKU and will return the ASIN. If you have a long list of SKUs from a file, you can get the matching ASIN quickly with this function.

=GORILLA_SKUASIN("B00YD545CC", "sku2asin")

When the direction of sku2asin is entered, it will convert from SKU to ASIN. If you have a long list of SKUs from a file, you can get the matching ASIN quickly with this function.

=GORILLA_SKUASIN(D33:E39, "asin2sku")

Return an array of SKUs by entering a column, row or range of ASINs like this example.

=GORILLA_SKUASIN(D33:E39,"sku2asin")

Return an array of ASINs by entering a column, row or range of ASINs like this example.

sku2asin asin2sku

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

=GORILLA_SKUASIN("SELLER ID", "IPHN3724")
=GORILLA_SKUASIN("SELLER ID", "B00YD545CC", "asin2sku")
=GORILLA_SKUASIN("SELLER ID", D33:E39, "asin2sku")
=GORILLA_SKUASIN("SELLER ID", D33:E39,"sku2asin")

How can we help?