Syntax
=DRAGON_INVENTORY_DETAILS(account, [ASIN/SKU], [marketplace], [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_DETAILS("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_DETAILS("Nordvik", "", "US")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | snapshot_date | sku | asin | fnsku | condition | warehouse_quantity | fulfillable_quantity | … |
| 2 | US | 2026-10-12 | NV-HAT-CHARCOAL | B0KNIT0101 | X0KNIT0101 | New | 85 | 85 | … 10 more |
| 3 | US | 2026-10-11 | NV-HAT-NAVY | B0KNIT0104 | X0KNIT0104 | New | 19 | 19 | … 10 more |
| 4 | US | 2026-10-10 | NV-TEE-BLACK-L | B0KNIT0109 | X0KNIT0109 | New | 50 | 50 | … 10 more |
| 5 | US | 2026-10-09 | NV-SWT-CHARCOAL-L | B0KNIT0121 | X0KNIT0121 | New | 81 | 81 | … 10 more |
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. |
| 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 – for example compact,-seller_id.
| Column | Default | Description |
|---|---|---|
| seller_id | No | Seller id |
| marketplace | Yes | Marketplace |
| snapshot_date | Yes | Date of the Amazon inventory report these numbers come from. |
| sku | Yes | SKU |
| asin | Yes | ASIN |
| fnsku | Yes | FNSKU |
| condition | Yes | Condition |
| fulfillment | No | Fulfillment |
| status | No | Status |
| warehouse_quantity | Yes | FBA warehouse quantity |
| fulfillable_quantity | Yes | FBA fulfillable quantity |
| unsellable_quantity | Yes | FBA unsellable quantity |
| reserved_quantity | Yes | FBA reserved quantity |
| total_quantity | Yes | FBA total quantity |
| inbound_working_quantity | Yes | FBA inbound working quantity |
| inbound_shipped_quantity | Yes | FBA inbound shipped quantity |
| inbound_receiving_quantity | Yes | FBA inbound receiving quantity |
| researching_quantity | Yes | FBA researching quantity |
| reserved_future_supply_quantity | Yes | FBA reserved future supply quantity |
| future_supply_buyable_quantity | Yes | FBA future supply buyable quantity |
| per_unit_volume | Yes | Per unit volume |
Column groups
Groups select several columns at once and combine with single fields in the columns parameter.
compact warehouse_quantity, fulfillable_quantity, unsellable_quantity, reserved_quantity, total_quantity, inbound_working_quantity, inbound_shipped_quantity, inbound_receiving_quantity, researching_quantity, reserved_future_supply_quantity, future_supply_buyable_quantity, per_unit_volume
Examples
=DRAGON_INVENTORY_DETAILS("Mystore", "B0MYASIN01", "US")
=DRAGON_INVENTORY_DETAILS("Mystore", "B0MYASIN01", "US", "compact")
Notes
- snapshot_date is the date of the Amazon inventory report the numbers come from. Amazon sends one report a day, so before today's report arrives you see yesterday's.
- send an ASIN and its SKU rows are summed into one row per ASIN (quantities add up, SKU/condition/fulfillment are listed together); send a SKU to keep per-SKU rows.
- columns: use compact to show inventory quantity fields without marketplace, SKU, ASIN, FNSKU, or condition context. 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.