Syntax
=DRAGON_STRANDED(account, [ASIN/SKU], [marketplace], [period], [status], [reason], [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_STRANDED("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_STRANDED("Nordvik", "", "US", "last 90 days")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | date_stranded | asin | sku | fnsku | product_name | stranded_reason | status_primary | … |
| 2 | US | 2026-10-12 | B0KNIT0101 | NV-HAT-CHARCOAL | X0KNIT0101 | Nordvik Merino Wool Beanie, Ribbed Cuffed Knit Hat – Charcoal | CUSTOMER_RETURN | – | … 7 more |
| 3 | US | 2026-10-11 | B0KNIT0104 | NV-HAT-NAVY | X0KNIT0104 | Nordvik Merino Wool Beanie, Ribbed Cuffed Knit Hat – Navy | DAMAGED | – | … 7 more |
| 4 | US | 2026-10-10 | B0KNIT0109 | NV-TEE-BLACK-L | X0KNIT0109 | Nordvik Fjord Graphic T-Shirt for Men – Black, L | NO_LONGER_NEEDED | – | … 7 more |
| 5 | US | 2026-10-09 | B0KNIT0121 | NV-SWT-CHARCOAL-L | X0KNIT0121 | Nordvik Heavyweight Crewneck Sweatshirt for Men – Charcoal, L | DEFECTIVE | – | … 7 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. |
| period | Optional | Optional period such as last 90 days, 2026-04, or 2026. Default: last 90 days. |
| status | Optional | Optional primary status filter. |
| reason | Optional | Optional stranded reason filter. |
| 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. |
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. |
| date_stranded | Yes | Date stranded. |
| asin | Yes | ASIN. |
| sku | Yes | SKU. |
| fnsku | Yes | FNSKU. |
| product_name | Yes | Product name. |
| stranded_reason | Yes | Stranded reason. |
| status_primary | Yes | Primary status. |
| status_secondary | Yes | Secondary status. |
| primary_action | Yes | Primary action. |
| fulfillable_qty | Yes | Fulfillable quantity. |
| unfulfillable_qty | Yes | Unfulfillable quantity. |
| reserved_quantity | Yes | Reserved quantity. |
| inbound_shipped_qty | Yes | Inbound shipped quantity. |
| date_to_take_auto_removal | Yes | Auto removal date. |
| your_price | No | Your price. |
| item_condition | No | Item condition. |
| fulfilled_by | No | Fulfilled by. |
| error_message | No | Error message. |
| marketplace_id | No | Marketplace id. |
| seller_id | No | Seller id. |
Examples
=DRAGON_STRANDED("Mystore", "", "US", "last 90 days")