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.