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")
=GORILLA_SKUASIN(D33:E39, "asin2sku")
=GORILLA_SKUASIN(D33:E39,"sku2asin")

Syntax Description

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

GORILLA_SKUASIN(SKU/ASIN, [direction])

Gorilla Agency, the syntax is

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

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.

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 SKU’s 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 SKU’s from a file, you can get the matching ASIN quickly with this function.

=GORILLA_SKUASIN(D33:E39, "asin2sku")

Return an array of SKU’s by entering a column, row or range of ASIN’s like this example.

=GORILLA_SKUASIN(D33:E39,"sku2asin")

Return an array of ASIN’s by entering a column, row or range of ASIN’s 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")

GORILLA_SKUASIN Attributes

  • sku2asin
  • asin2sku

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?