biz_query_sales
Retrieve GMV, order count, and refund rate for a date range, filtered by SKU, shop, or channel, and grouped by day, week, or category to answer structured sales questions.
Instructions
【销售查询】按结构化过滤汇总 GMV / 订单 / 退款率。
【硬约束】只能用本工具的过滤字段,禁止拼接 SQL。 【group_by】day / week / sku / category / channel / shop。 【ID 从哪来】sku_id 来自结果或 biz_get_sku;shop_id 为 SHOP-TM / SHOP-DY / SHOP-OS; channel_id 为 tmall / douyin / independent / xiaohongshu。不要编造 SKU。 【金额】gmv_cent 为分,展示时除以 100。 【何时用】「上周哪个 SKU GMV 最高」「音频类目 8 月退款率」。 【何时不用】只要异常对比 → biz_anomaly_scan;只要单订单 → biz_get_order。
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| sku_id | No | ||
| shop_id | No | ||
| category | No | ||
| end_date | No | ||
| group_by | No | day | |
| channel_id | No | ||
| start_date | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||