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

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

- Family: seller
- Report type: `GET_FBA_MYI_ALL_INVENTORY_DATA`
- How fresh: Several times a day — Every 6 hours, at minute 15 (marketplace local time)
- Need it right now: [`fbaInventory_getInventorySummaries`](https://sellersheetai.com/docs/mcp-api/tools/fbaInventory_getInventorySummaries) (one or a few SKUs)
- Grain: per_mkt · sync: snapshot

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `snapshot_date` | DATE | key |
| `country_code` | VARCHAR(16) | key |
| `sku` | VARCHAR(200) | key |
| `fnsku` | VARCHAR(200) |  |
| `asin` | VARCHAR(20) |  |
| `product_name` | TEXT |  |
| `condition` | VARCHAR(50) | key |
| `your_price` | NUMERIC(12, 2) |  |
| `inbound_working` | INTEGER |  |
| `inbound_shipped` | INTEGER |  |
| `inbound_receiving` | INTEGER |  |
| `total_units` | INTEGER |  |
| `afn_fulfillable_quantity` | INTEGER |  |
| `afn_unsellable_quantity` | INTEGER |  |
| `afn_reserved_quantity` | INTEGER |  |
| `afn_researching_quantity` | INTEGER |  |
| `afn_warehouse_quantity` | INTEGER |  |
| `afn_reserved_future_supply` | INTEGER |  |
| `afn_future_supply_buyable` | INTEGER |  |
| `afn_fulfillable_quantity_local` | INTEGER |  |
| `afn_fulfillable_quantity_remote` | INTEGER |  |
| `mfn_listing_exists` | VARCHAR(10) |  |
| `afn_listing_exists` | VARCHAR(10) |  |
| `per_unit_volume` | NUMERIC(12, 4) |  |
| `mfn_fulfillable_quantity` | INTEGER |  |
| `afn_fc_transfer_quantity` | INTEGER |  |
| `afn_onhand_buyable_quantity` | INTEGER |  |
| `amazon_store` | VARCHAR(50) |  |
| `extra` | JSON |  |

## Query it

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