Sole Sanctuary Order Desk
Order management, payment tracking & business overview
Business overview
Sales, collections and order status at a glance.
Recent orders
Latest order activity
| Order | Customer | Order value | Balance | Status |
|---|
Order status mix
Based on selected period
Outstanding balances
Orders with payment still due
| Order | Customer | Due | Delivery |
|---|
Quick actions
Common tasks
Orders
Search orders, update delivery status and manage payments.
Order register
0 orders
| Order ID / date | Customer | Products | Total due | Received | Balance | Payment | Delivery | Actions |
|---|
Customers
Customer list based on your saved orders.
Customer register
Each customer is grouped by phone number where available.
| Customer | Orders | Total order value | Received | Outstanding | Action |
|---|
Cloud database setup
Recommended: Supabase Postgres with Row Level Security (RLS).
Connect Supabase
Optional until you create your cloud project.
The public key is safe to use only with correctly configured RLS policies. Treat customer data as private. Use a Supabase Auth login and user-scoped policies before using this for real customer records.
Database schema
Starter schema for orders and customer records.
Open Supabase → SQL Editor → New query, paste this SQL and run it. This starter schema enables RLS and denies public access by default. Add authentication and owner-scoped policies before syncing real data.
Data & privacy
Understand where your records live.
- Local mode: records stay in this browser profile on this device.
- Backup: export a JSON file periodically and store it securely.
- Cloud mode: configure Supabase Auth and user-scoped RLS policies before enabling production sync. The starter HTML intentionally does not auto-upload private customer data.
- WhatsApp: the app opens the customer chat with a prepared message and downloads a PDF. You attach the PDF and tap Send manually.