Syntax
=DRAGON_INVENTORY_LOCATION(account, [ASIN/SKU], [marketplace], [period], [FC], [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_LOCATION("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Illustrative values – your sheet shows your account's live data.
A1fx
=DRAGON_INVENTORY_LOCATION("Myaccount", "", "US")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | ledger_date | sku | asin | fnsku | fulfillment_center | disposition | ending_balance | … |
| 2 | US | 2026-07-21 | MB-TEE-BLK-L_FBA | B0EXAMPLE1 | X0EXAMPLE1 | CLT2 | SELLABLE | – | … 3 more |
| 3 | US | 2026-07-20 | MB-TEE-NVY-M_FBA | B0EXAMPLE2 | X0EXAMPLE2 | LAX9 | SELLABLE | – | … 3 more |
| 4 | US | 2026-07-19 | MB-HAT-GRY_FBA | B0EXAMPLE3 | X0EXAMPLE3 | MDW2 | SELLABLE | – | … 3 more |
| 5 | US | 2026-07-18 | MB-MUG-11OZ_FBA | B0EXAMPLE4 | X0EXAMPLE4 | RIC2 | SELLABLE | – | … 3 more |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| ASIN/SKU | Optional | Optional ASIN, SKU, or comma/space separated list. 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. |
| period | Optional | Optional period such as last 30 days, 2026-04, or 2026. |
| FC | Optional | Optional FC filter. |
| disposition | Optional | Optional inventory disposition filter. |
| columns | Optional | Optional comma-separated output 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.
| Column | Default | Description |
|---|---|---|
| marketplace | Yes | Marketplace. |
| marketplace_id | No | Marketplace id. |
| ledger_date | Yes | Ledger date. |
| sku | Yes | Sku. |
| asin | Yes | Asin. |
| fnsku | Yes | Fnsku. |
| fulfillment_center | Yes | FC. |
| disposition | Yes | Disposition. |
| ending_balance | Yes | Ending balance. |
| warehouse_city | Yes | Warehouse city. |
| warehouse_state | Yes | Warehouse state. |
| warehouse_country | Yes | Warehouse country. |
| in_transit_between_warehouses | No | In transit between warehouses. |
| starting_balance | No | Starting balance. |
| receipts | No | Receipts. |
| customer_shipments | No | Customer shipments. |
| customer_returns | No | Customer returns. |
| vendor_returns | No | Vendor returns. |
| warehouse_transfer | No | Warehouse transfer. |
| found | No | Found. |
| lost | No | Lost. |
| damaged | No | Damaged. |
| disposed | No | Disposed. |
| other_events | No | Other events. |
| unknown_events | No | Unknown events. |
Examples
=DRAGON_INVENTORY_LOCATION("Myaccount", "", "US")