BouquetOS

Headline overhead and labor figures: recurring monthly/annual burn of active bills, that burn prorated over the period, one-off overhead in the period, and (when the pay module is on) labor cost per staff member with worked and overtime minutes. Flags explain missing numbers (missing pay rate, mixed currencies, someone still clocked in). Periods are America/Los_Angeles: 'mtd' = this month to date (default), 'last_month', 'last_7d', 'last_30d'. Money figures are numbers rounded to 2dp. Each amount is reported in its native currency, plus a `base*` equivalent in the shop's reporting (primary) currency. A base figure is null — never 0 — when an FX rate is missing: say the total is unavailable rather than treating null as zero or summing across currencies yourself.

get_cost_center_summary

Create a new sales order. Echo the parsed order back to the user for confirmation before calling this. Source is recorded as "chat" and the raw args are stored for audit. Rejected (as a tool error) when the fulfillment date breaks the shop's date rules. If the shop has turned on Email receipts and the order has a customer_email, the customer is emailed a receipt link as soon as the order is created — say so in the confirmation; otherwise no customer is notified. For a delivery, the address is sent to Google Maps to estimate drive time; if the shop caps bookings per storefront time slot, the new booked count is published to its Shopify storefront. Returns {id, summary}. If the user attached a photo of the bouquet or product, pass it as `image`; the result then carries imageAttached: true, or imageError when the order was created without it — only tell the user the photo was saved when imageAttached is true. Always pass a new idempotency_key for each record you mean to create, and the same key again when retrying it, so a retry never creates a duplicate.

create_order

Record a purchase order from a supplier. Echo the supplier, items, and total back to the user for confirmation before calling. Amounts are in the PO's currency, one of: USD. Total = Σ(quantity × unit_price) + shipping + tax and must be > 0. Status defaults to ordered. Internal record only — the supplier is not contacted. Returns the created purchase order. If the user attached a photo of the receipt or invoice, read the supplier, lines and amounts off it yourself, confirm them, and pass the photo as receipt_image so the PO keeps it as its source; the result then carries imageAttached: true, or imageError when the PO was created without it — only tell the user the photo was saved when imageAttached is true. Always pass a new idempotency_key for each record you mean to create, and the same key again when retrying it, so a retry never creates a duplicate.

create_purchase_order

Fetch a single order by id: status, fulfillment type/time (ISO 8601, UTC), customer and recipient contact, delivery address and driver, items, design and card notes, image URLs, amounts and payment.

get_order

Fetch a single purchase order with its line items by id.

get_purchase_order

List orders whose fulfillment falls on the given date (America/Los_Angeles), sorted by fulfillmentAt ascending. Each order has the same fields as get_order.

list_orders_for_day

List purchase orders (supplier buys — flowers and goods for resale) created in one month (America/Los_Angeles, default current month), newest first, with line items. Also returns per-currency totals for the filtered set (never combined across currencies) and the distinct supplier names used historically. Filter by supplier substring, status, or currency.

list_purchase_orders

Time series of operating expenses over a range, split into overhead (recurring bills prorated to a daily share), one-off overhead (landing whole on its date), and labor (staff pay; omitted when the pay module is off — see laborIncluded). laborIncomplete=true means some worked days had no pay rate, so labor is understated. Purchase orders are NOT included (see get_sales_series metric=cost). Money figures are numbers rounded to 2dp. Each amount is reported in its native currency, plus a `base*` equivalent in the shop's reporting (primary) currency. A base figure is null — never 0 — when an FX rate is missing: say the total is unavailable rather than treating null as zero or summing across currencies yourself.

get_expense_series

Time series of revenue (orders, by fulfillment date) or cost (non-cancelled purchase orders, by creation date) over a range, bucketed by day/week/month, with per-currency amounts, a base-currency total, and the delta vs the preceding window of the same length. Cost covers purchase orders only — use get_expense_series for overhead and labor. Money figures are numbers rounded to 2dp. Each amount is reported in its native currency, plus a `base*` equivalent in the shop's reporting (primary) currency. A base figure is null — never 0 — when an FX rate is missing: say the total is unavailable rather than treating null as zero or summing across currencies yourself.

get_sales_series

Snapshot of the shop's sales as of today (America/Los_Angeles): KPI tiles (today's revenue and order count, 30-day average order value, 30-day revenue vs purchasing) with deltas vs the prior period; month-to-date cumulative revenue vs last month at the same day; revenue by currency and by order source this month; a daily order-count heatmap; top products by units over the last 30 days (from structured line items only — coverage counts say how many orders had none); and orders needing attention (past due, missing pickup time, delivery without a driver). Revenue counts non-cancelled orders by fulfillment date. Money figures are numbers rounded to 2dp. Each amount is reported in its native currency, plus a `base*` equivalent in the shop's reporting (primary) currency. A base figure is null — never 0 — when an FX rate is missing: say the total is unavailable rather than treating null as zero or summing across currencies yourself.

get_sales_dashboard