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.
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 |