Sales order figures
Order value totals on your chosen GST basis, with the prior comparable period alongside every number.
Contract v1 · read-only
Your SAAVI data, in your business dashboard, every hour.
SAAVI Insights is a read-only REST API over SAAVI order data. Sales order figures, order counts, pallets, average order value and your top customers — by day, week or month — alongside Xero, Google Analytics and everything else you already report on.
- Refresh cadence
- Hourly
- Load on your SAAVI database
- Zero at read time
- Write access
- None
Incremental sync; on-demand pulls are rate limited per key.
Dashboards read a mirror, never your production ERP.
Reporting only. This API cannot place or change an order.
The metrics you asked for
Live from the sandbox organisation below. Every figure carries the basis it was calculated on, so the dashboard label always matches the maths.
Sales value · last 6 months
$3,088,883
ex GST
Orders · last 30 days
661
Average order value · 30 days
$739.56
Pallets · last 30 days
277.6
data_as_of 15 h ago · organisation Sandbox Distributors (synthetic)
What the API covers
Pallets and volume
Pallet equivalents derived from order lines, with the derivation basis stated in every response so nothing is a black box.
Top 10 customers
Ranked by sales value for any window, including each customer's share of period sales.
Daily, weekly, monthly
One period parameter. Buckets respect your timezone, week start day and cancelled-order rules.
Webhooks
HMAC-SHA256 signed callbacks the moment a refresh lands, so your dashboard pulls only when there is something new.
Scheduled exports
The same figures as CSV for Google Sheets, Power Query or an existing ETL job.
How the data gets there
- 01
Read SAAVI incrementally
A bridge inside the customer's network reads the SAAVI tables using a modified-since watermark. Outbound only — nothing is exposed to the internet.
- 02
Mirror to reporting storage
Customers, products, order headers and order lines are upserted into a per-organisation mirror. Re-running a sync is safe.
- 03
Roll up deterministically
Day, week and month buckets are recomputed from the mirror under your documented rules, and can be replayed to prove any figure.
- 04
Serve and notify
Your dashboard calls the API or receives a signed webhook. Responses answer in milliseconds because they read rollups.
Every SAAVI customer is a separate organisation with its own database and its own keys. A key is scoped to one organisation, can be limited to specific customer accounts, and can be revoked instantly.