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

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

Syntax Description

GORILLA_SKUASIN() – Convert SKU or ASIN to SKU and SKU to ASIN 1

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: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_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")

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?