Syntax
=DRAGON_ASIN2SKU(account, [ASIN], [marketplace], [fulfillment], [columns], [header], [transpose])
Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.
This page is also available inside Sheets – type
=DRAGON_ASIN2SKU("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Example output from the Nordvik demo store – your sheet shows your own store's data.
A1fx
=DRAGON_ASIN2SKU("Nordvik", "", "US", "FBA")| A | B | C | D | |
|---|---|---|---|---|
| 1 | marketplace | asin | sku | fnsku |
| 2 | US | B0KNIT0101 | NV-HAT-CHARCOAL | X0KNIT0101 |
| 3 | US | B0KNIT0104 | NV-HAT-NAVY | X0KNIT0104 |
| 4 | US | B0KNIT0109 | NV-TEE-BLACK-L | X0KNIT0109 |
| 5 | US | B0KNIT0121 | NV-SWT-CHARCOAL-L | X0KNIT0121 |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account. |
| ASIN | Optional | Optional ASIN or an ASIN list separated by ;. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list. |
| marketplace | Optional | Optional marketplace/country code such as US, CA, or MX. |
| fulfillment | Optional | Optional fulfillment filter: FBA or FBM. |
| columns | Optional | Optional output columns separated by ;. |
| header | Optional | Use no, false, or 0 to suppress the output header row. Default: Yes. |
| transpose | Optional | Use yes, true, or 1 to transpose the output. |
Columns
Columns are evaluated left to right: a field or group name adds columns, a leading - removes them. default and all select the default or full column set.
| Column | Default | Description |
|---|---|---|
| marketplace | Yes | Marketplace |
| asin | Yes | ASIN |
| sku | Yes | SKU |
| fnsku | Yes | FNSKU |
Examples
=DRAGON_ASIN2SKU("Mystore", "B0MYASIN01", "US", "FBA")