Operations Dashboard
Real-time overview of catalog, live inventory, orders, and sales activity.
🚀 Migrated from 10 Google Sheets to SQLite
Computed inventory ledger active. Stock is calculated on-demand from received restocks minus completed sales, eliminating manual recount drift. Customer and supplier duplicates have been fully resolved.
Total Revenue
$27,405.00
Completed orders
Orders
297
300 in legacy sheets
Active SKUs
34
18 parent products
Customers
86
Merged from 100 rows
Suppliers
10
Deduplicated from 11
Low Stock Alerts
1
Needs reorder
Recent Orders
View All →| Order # | Customer | Date | Items | Total | Status |
|---|---|---|---|---|---|
| ORD-1235 | Ivan Gonzales | 2026-08-17 | 1 items | $117.00 | completed |
| ORD-1042 | Marcus Vance | 2026-08-14 | 2 items | $91.00 | completed |
| ORD-1019 | Jon Washington | 2026-08-13 | 1 items | $166.50 | completed |
| ORD-1285 | Selma Price | 2026-08-02 | 1 items | $88.00 | completed |
| ORD-1241 | Gustav Smith | 2026-07-29 | 4 items | $131.00 | completed |
Inventory Alerts
Full Inventory →| SKU | Product | Available | Status |
|---|---|---|---|
| HSE-MR-WB-250 | Morning Ritual Blend Whole Bean / 250g | 0 | out_of_stock |
Recent Purchase Orders (Restocks)
All Purchases →| PO # | Supplier | Date | Lines | Total Cost | Status |
|---|---|---|---|---|---|
| PUR-024 | Horizon Coffee Importers Inc. | 2026-07-22 | 1 items | $1764.00 | received |
| PUR-007 | Omega Kitchenware BV | 2026-07-18 | 1 items | $702.00 | received |
| PUR-003 | Horizon Coffee Importers Inc. | 2026-07-15 | 1 items | $306.00 | received |
| PUR-055 | Omega Kitchenware BV | 2026-07-05 | 2 items | $726.00 | received |
| PUR-062 | Horizon Coffee Importers Inc. | 2026-06-13 | 2 items | $2184.80 | received |