Syntax
=DRAGON_ORDERS(account, [ASIN/SKU], [marketplace], [fulfillment], [period], [order ID], [fulfillment status], [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_ORDERS("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_ORDERS("Myaccount", "", "US", "FBA", "last 30 days")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | order_id | order_time | fulfillment | fulfillment_status | fulfillment_service_level | quantity_fulfilled | quantity_unfulfilled | … |
| 2 | US | 113-1234560-7654321 | 2026-07-21 9:17:04 | FBA | – | – | 0 | 0 | … 12 more |
| 3 | US | 113-1234671-7653210 | 2026-07-20 12:26:04 | FBA | – | – | 19 | 19 | … 12 more |
| 4 | US | 113-1234782-7652099 | 2026-07-19 15:35:04 | FBA | – | – | 12 | 12 | … 12 more |
| 5 | US | 113-1234893-7650988 | 2026-07-18 18:44:04 | FBA | – | – | 81 | 81 | … 12 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. |
| fulfillment | Optional | Optional fulfillment filter: FBA or FBM. |
| period | Optional | Optional period such as last 90 days, 2026-04, or 2026. Default: last 90 days. |
| order ID | Optional | Optional Amazon order id filter. |
| fulfillment status | Optional | Optional fulfillment status filter. Default: ALL_BUT_CANCELLED. |
| 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. |
| order_id | Yes | Order id. |
| order_item_id | No | Order item id. |
| order_time | Yes | Order time. |
| sales_channel_name | No | Sales channel name. |
| fulfillment | Yes | Fulfillment. |
| fulfillment_status | Yes | Fulfillment status. |
| fulfilled_by | No | Fulfilled by. |
| fulfillment_service_level | Yes | Fulfillment service level. |
| quantity_fulfilled | Yes | Quantity fulfilled. |
| quantity_unfulfilled | Yes | Quantity unfulfilled. |
| package_status | No | Package status. |
| package_detailed_status | No | Package detailed status. |
| recipient_city | Yes | Recipient city. |
| recipient_state_or_region | Yes | Recipient state or region. |
| recipient_country_code | Yes | Recipient country code. |
| proceeds_grand_total_amount | No | Proceeds grand total amount. |
| proceeds_grand_total_currency | No | Proceeds grand total currency. |
| quantity_ordered | Yes | Quantity ordered. |
| asin | Yes | Asin. |
| sku | Yes | Seller sku. |
| unit_price_amount | Yes | Unit price amount. |
| unit_price_currency | Yes | Unit price currency. |
| sales_amount | Yes | Sales amount. |
| sales_currency | Yes | Sales currency. |
| marketplace_amount | Yes | Marketplace amount. |
| marketplace_currency | Yes | Marketplace currency. |
| proceeds_total_amount | No | Proceeds total amount. |
| proceeds_total_currency | No | Proceeds total currency. |
Examples
=DRAGON_ORDERS("Myaccount", "", "US", "FBA", "last 30 days")