Overview
The Dashboard is the main landing page providing a high-level view of inventory health, sales performance, and key metrics. It helps store owners quickly identify issues and take action.
Key Performance Indicators (KPIs)
Revenue at Risk
$0
Potential lost revenue
SKUs Need Reorder
0
3 critical, 5 low
Inventory Value
$29,488
148 total SKUs
Fill Rate
33.8%
% healthy + low
| KPI | Description | Data Source |
|---|---|---|
| Revenue at Risk | Estimated revenue lost from pending stockout recommendations | reorder_recommendations table |
| SKUs Need Reorder | Count of products with pending reorder suggestions | reorder_recommendations where status = 'pending' |
| Inventory Value | Total value of current stock (cost × quantity available) | inventory_snapshots joined with products |
| Fill Rate | Percentage of SKUs that are healthy or low (not critical/stockout) | Computed from inventory_snapshots status counts |
Stock Status Distribution (Donut Chart)
Donut chart showing the distribution of inventory across four statuses.
| Status | Color | Description |
|---|---|---|
| Healthy | Green | Stock level above healthy threshold (default: > 20 units) |
| Low | Yellow | Stock level between low and healthy thresholds (default: 6–20 units) |
| Critical | Red | Stock level between critical and low thresholds (default: 1–5 units) |
| Stockout | Black | Zero stock remaining |
Interactive: Clicking any segment of the donut chart navigates to the Products page filtered by that status. Other filters (search, supplier, sync) are automatically cleared.
Daily Sales Chart
Bar chart showing daily sales revenue for the last 14 days.
- Green bars — Days with revenue > $0 (shows dollar amount)
- Gray bars — Days with $0 revenue or no orders
- Date labels — Format: "Sep 10", "Sep 11", etc.
Top Selling Products Widget
Top 5 Products by Daily Velocity
| Product | Daily Sales | Stock |
|---|---|---|
| Classic Essential Tee - XL | 5.2/day | 2746 |
| Bluetooth Speaker - Red | 3.5/day | 0 |
| Aerodynamic Mesh Runner | 4.5/day | 125 |
Shows the top 5 products ranked by daily sales velocity. Helps identify which products are moving fast and may need reordering soon.
Top Suppliers Widget
Top 5 Suppliers by Product Count
| Supplier | Products |
|---|---|
| DuffelPro Manufacturing | 3 |
| TechParts Co. | 4 |
| Global Textiles Ltd. | 3 |
Shows the top 5 suppliers ranked by how many products they supply. Helps understand supplier concentration.
Plan & Usage Widget
Current Plan & Usage Statistics
| Metric | Value |
|---|---|
| Current Plan | Starter (Free) |
| Products Synced | 148 |
| Orders This Month | 49 |
| Pending Reorders | 106 |
| Urgent Recommendations | 95 |
| Inventory Adjustments (7d) | 12 |
Quick Actions
Action Buttons
- View Reorder Queue — Navigate to the Reorder Queue page (shows count of pending recommendations)
- Manage Products — Navigate to Products page (clears all filters)
- View Orders — Navigate to Orders page (clears all filters)
- Manage Suppliers — Navigate to Suppliers page (clears all filters)
Data Sources
| Data | Source | Update Frequency |
|---|---|---|
| KPIs | /api/dashboard | Real-time from database |
| Top Selling Products | /api/dashboard/widgets | Real-time from database |
| Top Suppliers | /api/dashboard/widgets | Real-time from database |
| Sales Chart | sales_history table | Updated during order sync |
| Stock Status | inventory_snapshots table | Updated during product sync |
Sync Note: Dashboard data is only as fresh as the last sync. Click the Sync button on the Products page to pull latest inventory from Shopify. Order sync populates the sales history.