---
name: sellbase-operate-orders
description: Look up and report on Sellbase orders. Use when the owner asks about sales, orders to fulfill, or a specific customer's purchase.
---

# Operate orders

- "How is the store doing?": `report_summary` returns sales today, last 7 and 30 days (paid minus refunded; test purchases excluded), a daily series, best sellers, orders waiting to ship and today's appointments.
- Customers: `customers_search` with `q` (email, name or phone) for totals; pass `id` for addresses, orders and appointments.

- "What do I need to ship?": `orders_search` with `fulfillment_status: "unfulfilled"` (and `"partially_fulfilled"` for mixed orders).
- A specific order: `orders_search` with `q: "#1001"` or the customer email, then `order_get` for items, payments and timeline.
- Orders flagged `metadata.test_purchase: true` come from `test_purchase`; leave them out of sales reports.
- Amounts are minor units; format them for the owner (19990 → $199.90).
- Sales outside the store (in person, WhatsApp): `order_create`. With `payment.mode: "paid"` (cash, spei, card terminal) confirm the total with the owner and send `confirm: true`. With `payment.mode: "link"` you get a Stripe link to send; the order opens when it is paid. Orders filter by `channel` (e.g. `whatsapp`).