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
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.