Sales summary
sales_summaryGet order count, revenue, average order value, status breakdown, and top products for a date range. Excludes cancelled orders, defaults to the last 30 days, and reports money in integer cents.
Instructions
Order count, revenue, average order value, orders by status and top products for a date range (inclusive, UTC). Cancelled orders are excluded from revenue. Defaults to the last 30 days. All money values are integer cents (12999 = $129.99).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | End date YYYY-MM-DD (default: today) | |
| top | No | How many top products to return | |
| from | No | Start date YYYY-MM-DD (default: 29 days before `to`) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | ||
| from | Yes | ||
| byStatus | Yes | ||
| orderCount | Yes | ||
| topProducts | Yes | ||
| revenueCents | Yes | ||
| averageOrderCents | Yes |