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_SKUASIN("TOY STORE", "IPHN3724")
=GORILLA_SKUASIN("TOY STORE", "B00YD545CC", "sku2asin", "US")
=GORILLA_SKUASIN("TOY STORE", D33:E39, "asin2sku")
=GORILLA_SKUASIN("TOY STORE", D33:E39,"sku2asin")
=GORILLA_SKUASIN("TOY STORE", "B00YD545CC", "sku2asin", "US", "FBA")
Syntax Description
Description:
Convert ASIN to SKU and SKU to ASIN. Bulk convert compatible.
Syntax:
GORILLA_SKUASIN(Seller ID, SKU/ASIN, [direction], [marketplace], [fulfillment])
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 string.
direction – OPTIONAL
Conversion type. If sku2asin (default), first parameter is interpreted as SKUs and ASINs will be returned. If asin2sku, first parameter is interpreted as ASINs.
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.
fulfillment – OPTIONAL
Fulfillment type for the conversion when using asin2sku. Valid values are: ANY (DEFAULT), FBA, FBM.
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_SKUASIN("TOY STORE", "IPHN3724")
Displays the ASIN for SKU IPHN3724. As the direction is not set, the function assumes the value is a SKU and will return the ASIN. If you have a long list of SKUs from a file, you can get the matching ASIN quickly with this function.
=GORILLA_SKUASIN("TOY STORE", "B00YD545CC", "sku2asin")
When the direction of sku2asin is entered, it will convert from SKU to ASIN. If you have a long list of SKUs from a file, you can get the matching ASIN quickly with this function.
=GORILLA_SKUASIN("TOY STORE", D33:E39, "asin2sku")
Return an array of SKUs by entering a column, row or range of ASINs like this example.
=GORILLA_SKUASIN("TOY STORE", D33:E39,"sku2asin")
=GORILLA_SKUASIN("TOY STORE", "B00YD545CC", "sku2asin", "US", "FBA")
When the direction of sku2asin, marketplace, and the fulfillment is entered, it will convert from SKU to ASIN accordingly. If you have a long list of SKUs from a file, you can get the matching ASIN quickly with this function.
Return an array of ASINs by entering a column, row or range of ASINs like this example:
