Syntax
=DRAGON_INBOUND_FBA(account, [ASIN/SKU], [marketplace], [period], [shipment ID], [status], [destination FC], [basis], [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_INBOUND_FBA("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_INBOUND_FBA("Myaccount", , "US", "last 90 days")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | shipment_id | shipment_name | status | destination_fc | shipment_date | shipped_date | sku | … |
| 2 | US | FBA1EXAMPLE1 | – | ACTIVE | – | 2026-07-21 | 2026-07-21 | MB-TEE-BLK-L_FBA | … 7 more |
| 3 | US | FBA1EXAMPLE2 | – | ACTIVE | – | 2026-07-20 | 2026-07-20 | MB-TEE-NVY-M_FBA | … 7 more |
| 4 | US | FBA1EXAMPLE3 | – | ACTIVE | – | 2026-07-19 | 2026-07-19 | MB-HAT-GRY_FBA | … 7 more |
| 5 | US | FBA1EXAMPLE4 | – | ACTIVE | – | 2026-07-18 | 2026-07-18 | MB-MUG-11OZ_FBA | … 7 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. |
| shipment ID | Optional | Optional shipment id filter. |
| status | Optional | Optional shipment status filter. |
| destination FC | Optional | Optional destination FC filter. |
| basis | Optional | Optional row basis: ITEM or SHIPMENT. Default: ITEM. |
| 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. |
| shipment_id | Yes | FBA shipment id. |
| shipment_name | Yes | Shipment name. |
| status | Yes | Current shipment status. |
| destination_fc | Yes | Destination fulfillment center. |
| shipment_date | Yes | Shipment creation date (from the shipment name, else plan created). |
| shipped_date | Yes | Date the shipment shipped: ready-to-ship window start, shown only once status is in transit or later; null before then. |
| sku | Yes | Seller sku. |
| asin | Yes | Asin. |
| fnsku | No | Fnsku. |
| friendly_name | Yes | Product name: nickname when set, else the listing title, else the asin. |
| sku_count | No | Distinct SKUs in the shipment (SHIPMENT basis only). |
| quantity_shipped | Yes | Units shipped (planned quantity until Amazon reports shipped). |
| quantity_received | Yes | Units received at the FC. |
| quantity_discrepancy | Yes | Received minus shipped when both are known. |
| quantity_in_case | No | Units per case. |
| inbound_plan_id | No | Amazon inbound plan id when the shipment is v2024-planned. |
| plan_status | No | Inbound plan status when the shipment is v2024-planned. |
| last_update | Yes | Amazon's last recorded activity: latest FC receipt event, else the inbound plan's last-updated time. |
| days_since_update | Yes | Days since Amazon's last recorded activity. |
Examples
=DRAGON_INBOUND_FBA("Myaccount", , "US", "last 90 days")