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

GORILLA_SKUASIN( ) Function

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

Syntax:

GORILLA_SKUFNSKU(SKU/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.

GORILLA_SKUASIN Attributes

sku2fnsku
fnsku2sku

How can we help?