woo_hub_query
READ-ONLY, HISTORY from the Vendooly data-hub (synced from the WooCommerce store by the worker: initial load, then every hour and right after each store webhook). Views: products (catalog with SKU/EAN/price/stock), stock (daily stock & price snapshots), orders (order headers with a pseudonymous customer_hash instead of buyer data, with units), daily_sales (units and gross sales per day and SKU, cancelled/failed/refunded excluded), customers_rfm (per pseudonymous customer_hash: last order, first order, order count, spend, recency in days — for RFM; only orders synced with a customer_hash; the days window filters on the last order), sync_status (freshness), amazon_mapping (same SKU in this organization's Amazon catalog). Use it for trends and history; for the current state of the store use the live woo_* tools.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"store_id": "<store_id>"
},
"name": "woo_hub_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | Window for stock, orders, daily_sales (default 30, max 730) | |
| view | No | Default products | |
| limit | No | Max rows (default 200, cap 1000) | |
| store_id | Yes | From woo_list_stores |