Shipping Dashboard
The Shipping Dashboard is a custom Filament admin page that provides real-time visibility into shipping performance. It is powered by data ingested from ShipStation via webhooks and stored locally in the middleware database.
Accessing the Dashboard
Log in to the Filament admin panel at /admin and click Shipping Dashboard in the left navigation (truck icon, sort order 2).
Metrics Overview
The dashboard presents three primary KPIs, each comparing the current 30-day window against the previous 30-day window:
1. Average Shipping Time
- What it measures: Average number of days from order creation to shipment across all fulfilled orders.
- Sentiment: Lower is better. An increase is flagged as "bad" (red); a decrease is "good" (green).
2. Order Complexity
- What it measures: Average number of line items per order.
- Sentiment: Lower is better. Higher complexity typically increases fulfilment time.
3. On-Time Delivery Rate
- What it measures: Percentage of orders shipped within the committed ship-by window.
- Sentiment: Higher is better. A decline is flagged as "bad".
Period Comparisons
Each metric shows:
| Field | Description |
|---|---|
current | Value for the rolling last 30 days |
previous | Value for the 30 days before that |
change | Percentage change (((current - previous) / previous) × 100) |
direction | up / down / same |
sentiment | good / bad / same — controls the UI colour indicator |
Data Source
All dashboard data is read from three tables populated by the ShipStation webhook handler:
| Table | Description |
|---|---|
shipstation_orders | Inbound order records (order date, status, ship-by date, etc.) |
shipstation_order_items | Individual line items per order |
shipstation_shipments | Shipment records linked to orders |
Key Files
| File | Description |
|---|---|
app/Filament/Pages/ShippingDashboard.php | Page class — fetches and structures all metric data |
app/Filament/Pages/ShippingDashboardChartHelpers.php | Trait with date-range helpers and calculation methods |
resources/views/filament/pages/shipping-dashboard.blade.php | Blade view template |