get_orders
Retrieve orders from the shop database with filters for status, customer, and date range. Optionally include order items; cancelled orders are included in results.
Instructions
List orders. Filter by exact status (validated against the DB), customer_id, and/or a date range on order_date (from_date, to_date — ISO date or datetime strings). When include_items is true, attach an items array to each order. Sorted by id by default. Cancelled orders are shown here but excluded from analytic tools.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max rows to return. | |
| offset | No | Number of rows to skip. | |
| status | No | Order status. One of: new, processing, shipped, completed, cancelled (validated against the DB). | |
| to_date | No | Include orders with order_date <= this ISO date/datetime. | |
| from_date | No | Include orders with order_date >= this ISO date/datetime. | |
| customer_id | No | Only orders for this customer id. | |
| include_items | No | When true, attach an `items` array to each returned order. |