# rpt_get_stranded_inventory_ui_data (https://sellersheetai.com/docs/data/rpt_get_stranded_inventory_ui_data)

> Seller reports (SP-API) · GET_STRANDED_INVENTORY_UI_DATA · Every 6 hours, at minute 30 (marketplace local time)

- Family: seller
- Report type: `GET_STRANDED_INVENTORY_UI_DATA`
- How fresh: Several times a day — Every 6 hours, at minute 30 (marketplace local time)
- Need it right now: synced only
- Grain: account · sync: snapshot

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `snapshot_date` | DATE | key |
| `primary_action` | VARCHAR(100) |  |
| `date_stranded` | DATE |  |
| `date_to_take_auto_removal` | DATE |  |
| `status_primary` | VARCHAR(100) |  |
| `status_secondary` | VARCHAR(100) |  |
| `error_message` | TEXT |  |
| `sku` | VARCHAR(200) | key |
| `asin` | VARCHAR(20) |  |
| `image` | TEXT |  |
| `fnsku` | VARCHAR(200) | key |
| `product_name` | TEXT |  |
| `condition` | VARCHAR(50) | key |
| `fulfilled_by` | VARCHAR(50) |  |
| `fulfillable_qty` | INTEGER |  |
| `unfulfillable_qty` | INTEGER |  |
| `reserved_quantity` | INTEGER |  |
| `inbound_shipped_qty` | INTEGER |  |
| `fulfillment_center_id` | VARCHAR(50) |  |
| `stranded_reason` | VARCHAR(200) | key |
| `quantity` | INTEGER |  |
| `days_in_stranded_inventory` | INTEGER |  |
| `estimated_removal_cost` | NUMERIC(12, 2) |  |
| `your_price` | NUMERIC(12, 2) |  |
| `program` | VARCHAR(50) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_get_stranded_inventory_ui_data"
    ],
    "columns": [
      "rpt_get_stranded_inventory_ui_data.snapshot_date",
      "rpt_get_stranded_inventory_ui_data.sku",
      "rpt_get_stranded_inventory_ui_data.fnsku",
      "rpt_get_stranded_inventory_ui_data.condition"
    ],
    "order_by": [
      {
        "column": "rpt_get_stranded_inventory_ui_data.snapshot_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```