Syntax
=DRAGON_INVENTORY(account, [ASIN/SKU], [marketplace], [fulfillment], [period], [disposition], [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_INVENTORY("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_INVENTORY("Nordvik", "", "US", "FBA", "last_5_days")| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | sku | asin | 2026-10-12 | 2026-10-11 | 2026-10-10 | 2026-10-09 | 2026-10-08 |
| 2 | NV-HAT-CHARCOAL | B0KNIT0101 | 639 | 643 | 646 | 650 | 655 |
| 3 | NV-HAT-NAVY | B0KNIT0104 | 432 | 435 | 438 | 442 | 445 |
| 4 | NV-TEE-BLACK-L | B0KNIT0109 | 87 | 91 | 91 | 94 | 95 |
| 5 | NV-SWT-CHARCOAL-L | B0KNIT0121 | 362 | 362 | 363 | 366 | 368 |
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/SKU | Optional | Optional ASIN, SKU, or a 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. Default: FBA. |
| period | Optional | Optional period such as last 7 days, last 30 days, or last 90 days. Default: last 7 days. |
| disposition | Optional | Optional inventory disposition: sellable, incoming, reserved, unsellable (damaged), researching (being located by Amazon), available, or total. Default: total. |
| columns | Optional | Optional output columns separated by ; before the date columns. |
| 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. |
The period accepts values like last_30_days, this_month, 2026Q1, or ranges like 2026-01-01..today – see the full period reference.
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 – for example compact,-seller_id.
| Column | Default | Description |
|---|---|---|
| seller_id | No | Amazon seller id (merchant token) of the store. |
| marketplace | No | Marketplace |
| sku | Yes | SKU |
| asin | Yes | ASIN |
| fnsku | No | FNSKU |
| condition | No | Condition |
| fulfillment | No | Fulfillment |
| status | No | Status |
| per_unit_volume | No | Per unit volume |
| reserved_future_supply_quantity | No | FBA reserved future supply quantity |
Column groups
Groups select several columns at once and combine with single fields in the columns parameter.
compact
Examples
=DRAGON_INVENTORY("Mystore", "", "US", "FBA", "last 30 days", "total")
=DRAGON_INVENTORY("Mystore", "", "US", "FBA", "last 30 days", "sellable; incoming", "compact")
Notes
- send an ASIN and its SKU rows are summed into one row per ASIN (units add up across every condition); send a SKU to keep per-SKU rows.
- fulfillment: defaults to FBA. use FBM or FBA,FBM only when those quantities should be included.
- disposition: additive and deduped. accepted values are sellable, incoming, reserved, unsellable (damaged), researching (being located by Amazon), available, total. default is total.
- columns: use compact to show only inventory date columns. default and all are also supported.
- columns are evaluated left to right. A field or group adds columns; prefix with - to remove a field or group.