Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. 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", "DE")
=GORILLA_SKUFNSKU(D33:E39, "fnsku2sku")
=GORILLA_SKUFNSKU(D33:E39,"sku2fnsku")

Syntax Description

convert sku/asin to fnsku

Description:

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

Syntax:

GORILLA_SKUFNSKU(SKU/ASIN, [direction])

For 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 SKUs or ASINs.

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.

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

  • sku2fnsku
  • fnsku2sku

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_SKUFNSKU(D33:E39, "fnsku2sku")

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

=GORILLA_SKUFNSKU(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", "DE")
=GORILLA_SKUFNSKU("SELLER832J", D33:E39, "fnsku2sku")
=GORILLA_SKUFNSKU("SELLER832J", D33:E39,"sku2fnsku")

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?