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

Sample Usage =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 – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDProduct’s SKU/ASIN. Can be…

GORILLA_SKUASINPARENT() – Get the parent SKU or ASIN based on a child SKU or ASIN

Sample Usage =GORILLA_SKUASINPARENT(“TOY STORE”, “SKU1234”) =GORILLA_SKUASINPARENT(“TOY STORE”, “B00YD545CC”, “ASINPARENT”, “DE”) =GORILLA_SKUASINPARENT(“TOY STORE”, A1:A1000, “SKUPARENT”) =GORILLA_SKUASINPARENT(“TOY STORE”, A1:Z1, “SKUPARENT”, “US”) Syntax Description Description: Get the parent SKU or ASIN based on a child SKU or ASIN. Can be done in bulk using ranges. Syntax: GORILLA_SKUASINPARENT(Seller ID, SKU/ASIN, [direction], [marketplace]) Seller ID – REQUIREDEnter the seller ID…

GORILLA_SKUASIN() – Convert SKU to ASIN OR ASIN to SKU

Sample Usage =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 – REQUIREDEnter the seller ID or nickname you entered…

GORILLA_PRODIDCONV() – Convert between any product ID to another product ID in the Amazon system

Sample Usage =GORILLA_PRODIDCONV($A$1, $D$5:$D$20) =GORILLA_PRODIDCONV(“MY TOY STORE”, “GR-LE-JA”) =GORILLA_PRODIDCONV(“MY TOY STORE”, “B0722TZNZZ”, “asin2upc”) =GORILLA_PRODIDCONV(“MY TOY STORE”, “X001BAWNEZ”, “FNSKU2SKU”, “US”, “FBA”) Syntax Description Description: Convert between any product ID to another product ID in the Amazon system. Syntax: GORILLA_PRODIDCONV(sellerId, sku, [type], [marketplace], [fulfillment]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_BIZCONVERSION() – Display conversion related data from business reports

Sample Usage =GORILLA_BIZCONVERSION(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, , “2023-12-01”, “2023-12-21”) =GORILLA_BIZCONVERSION(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, 21) =GORILLA_BIZCONVERSION(“TOY STORE”, “This Week”, A2:A10, “US”, , “ALL”) =GORILLA_BIZCONVERSION(“TOY STORE”, “This Month”, “IPHN3724”, , , “UnitSessionPercentage”) =GORILLA_BIZCONVERSION(“TOY STORE”, “Same Day Last Month”, “IPHN3724”, “US”) =GORILLA_BIZCONVERSION(“TOY STORE”, “This Year”) Screenshot of Output Syntax Description: Description: Display…

GORILLA_BIZCONVERSIONHIST() – Daily historical conversions data from business reports

Sample Usage =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, , , “2023-12-01”, “2023-12-21”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, 21) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “This Week”, A2:A10, “US”, , “ALL”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “This Month”, “IPHN3724”, , , “UnitSessionPercentage”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “Same Day Last Month”, “IPHN3724”, “US”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “This Year”) Screenshot of Output Syntax Description Description:…