Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_SKUFNSKU() – Conv...

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

Sample Usage

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources. 
=GORILLA_SKUFNSKU("TOY STORE", "IPHN3724")
=GORILLA_SKUFNSKU("TOY STORE", "B00YD545CC", "sku2asin", "DE")
=GORILLA_SKUFNSKU("TOY STORE", D33:E39,"sku2fnsku")

Syntax Description

SKUFNSKU Gorilla ROI

Description:

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

Syntax:

=GORILLA_SKUFNSKU(Seller ID, sku, [direction], [marketplace])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – REQUIRED
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.

Examples:

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources. 
=GORILLA_SKUFNSKU("TOY STORE", "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("TOY STORE", "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("TOY STORE", D33:E39, "fnsku2sku")

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

=GORILLA_SKUFNSKU("TOY STORE", D33:E39,"sku2fnsku")

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

image 6 Gorilla ROI

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.