Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SKUFNSKU() – Convert SKU or ASIN to FNSKU and vice versa

GORILLA_SKUFNSKU() – Convert SKU or ASIN to FNSKU and vice versa

Sample Usage

=GORILLA_SKUFNSKU("IPHN3724")
=GORILLA_SKUFNSKU("B00YD545CC", "sku2asin")
=GORILLA_SKUASIN(D33:E39, "fnsku2sku")
=GORILLA_SKUASIN(D33:E39,"sku2fnsku")

Syntax Description

Convert single or bulk SKU or ASIN to FNSKU and vice versa.

GORILLA_SKUFNSKU(SKU/ASIN, [direction])

Gorilla Agency.the syntax is

GORILLA_SKUFNSKU(sellerID, sku or asin, [direction])

sku

Product’s SKU/ASIN. Can be an array of strings like {“ASIN12345″,”ASIN67890”} or a range like A2:A100 where cells 2 to 100 in column A would all have SKU’s or ASIN’s.

direction

OPTIONAL – Conversion type. If sku2fnsku (default), first parameter is interpreted as SKUs and FNSKUs will be returned. If fnsku2sku, first parameter is interpreted as FNSKUs.

Examples:

Use ranges in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_SKUFNSKU("IPHN3724")

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

=GORILLA_SKUFNSKU("B00YD545CC", "sku2asin")

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

=GORILLA_SKUASIN(D33:E39, "fnsku2sku")

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

=GORILLA_SKUASIN(D33:E39,"sku2fnsku")

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

sku2fnsku

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

=GORILLA_SKUFNSKU("SELLER832J", "IPHN3724")
=GORILLA_SKUFNSKU("SELLER832J", "B00YD545CC", "sku2asin")
=GORILLA_SKUASIN("SELLER832J", D33:E39, "fnsku2sku")
=GORILLA_SKUASIN("SELLER832J", D33:E39,"sku2fnsku")

GORILLA_SKUASIN Attributes

  • sku2fnsku
  • fnsku2sku

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?