GORILLA_PRODIDCONV() – Convert between any product ID to another product ID in the Amazon system
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_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 – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account .
sku – REQUIRED
SKU/ASIN/FNSKU/EAN/UPC to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123…
type – OPTIONAL
Conversion type. Left Input, Right Output.
Valid conversion types are:
sku2asin (DEFAULT)
sku2fnsku
sku2parentsku
sku2parentasin
sku2upc
sku2ean
asin2sku
asin2fnsku
asin2parentsku
asin2parentasin
asin2upc
asin2ean
fnsku2sku
fnsku2asin
fnsku2parentsku
fnsku2parentasin
fnsku2upc
fnsku2ean
ean2sku
ean2asin
ean2fnsku
ean2parentsku
ean2parentasin
ean2upc
upc2sku
upc2asin
upc2fnsku
upc2parentsku
upc2parentasin
upc2ean
marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, UK, CA, etc.
fulfillment – OPTIONAL
ALL lists results for any fulfillment channel. FBM displays fulfilled by merchant SKU/ASIN/FNSKU only. FBA displays fulfilled by Amazon SKU/ASIN/FNSKU only.
Default is set to ALL
All lists both FBA and FBM SKUs
FBA will only display FBA SKUs.
FBM will only display FBM SKUs.
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_PRODIDCONV($A$1, $D$5:$D$20)
$A$1 being the Seller ID and $D$5:$D$20 being the SKUs, and since no TYPE is mentioned, the output will list ASINs for the SKUs
=GORILLA_PRODIDCONV("MY TOY STORE", "GR-LE-JA")Instead of using Cell Reference, you can also type in a string to get the out. You can further specify the type to get the result accordingly.
=GORILLA_PRODIDCONV("MY TOY STORE", "B0722TZNZZ", "asin2upc")You can input an ASIN (B0722TZNZZ) to get the UPC for the mentioned ASIN.
=GORILLA_PRODIDCONV("MY TOY STORE", "X001BAWNEZ", "FNSKU2SKU", "US", "FBA")To get SKU out of an FNSKU (FBA) for the US Marketplace, you can use this method.