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

> Seller reports (SP-API) · GET_MERCHANT_LISTINGS_ALL_DATA · Daily at 01:05 marketplace local time

- Family: seller
- Report type: `GET_MERCHANT_LISTINGS_ALL_DATA`
- How fresh: Daily — Daily at 01:05 marketplace local time
- Need it right now: [`listings_searchListingsItems`](https://sellersheetai.com/docs/mcp-api/tools/listings_searchListingsItems)
- 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 |
| `seller_sku` | VARCHAR(200) | key |
| `item_description` | TEXT |  |
| `listing_id` | VARCHAR(200) |  |
| `asin1` | VARCHAR(20) |  |
| `asin2` | VARCHAR(20) |  |
| `asin3` | VARCHAR(20) |  |
| `item_name` | TEXT |  |
| `item_condition` | VARCHAR(50) | key |
| `open_date` | TIMESTAMP WITH TIME ZONE |  |
| `image_url` | TEXT |  |
| `item_is_marketplace` | VARCHAR(20) |  |
| `product_id_type` | VARCHAR(100) |  |
| `zshop_shipping_fee` | NUMERIC(12, 2) |  |
| `item_note` | TEXT |  |
| `zshop_category1` | VARCHAR(200) |  |
| `zshop_browse_path` | TEXT |  |
| `zshop_storefront_feature` | VARCHAR(50) |  |
| `will_ship_internationally` | VARCHAR(20) |  |
| `expedited_shipping` | VARCHAR(20) |  |
| `zshop_boldface` | VARCHAR(20) |  |
| `product_id` | VARCHAR(100) |  |
| `bid_for_featured_placement` | NUMERIC(12, 2) |  |
| `add_delete` | VARCHAR(20) |  |
| `fulfillment_channel` | VARCHAR(20) |  |
| `optional_payment_type_exclusion` | VARCHAR(100) |  |
| `status` | VARCHAR(50) |  |
| `merchant_shipping_group` | VARCHAR(100) |  |
| `price` | NUMERIC(12, 2) |  |
| `quantity` | INTEGER |  |
| `pending_quantity` | INTEGER |  |
| `points` | INTEGER |  |
| `maximum_retail_price` | NUMERIC(12, 2) |  |
| `sell_remainder` | VARCHAR(20) |  |
| `minimum_order_quantity` | INTEGER |  |
| `extra` | JSON |  |

## Query it

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