Skip to main content

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

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

GORILLA PRODIDCONV Gorilla ROI

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.

Did this answer your question?