Advanced Reports
Deep-dive analytics beyond the dashboard — for investors, accountants, operations, and marketing.
Categories of reports
Sales
- Revenue by day / week / month
- Revenue by category
- Revenue by payment method
- Average order value over time
- Conversion funnel (cart → checkout → purchase)
Customer
- New vs. returning customers
- Customer lifetime value (LTV)
- Customers by state / country
- Top spenders
Products
- Best sellers by revenue
- Best sellers by units
- Stale inventory (not sold in N days)
- Category performance
Buyback / repairs
- Quote conversion rate (approved / total)
- Batch turnaround time
- Repair margin (revenue - parts cost)
- Most common repair services
Environmental
- CO2 by month / year
- Device processing by category
- Recycling volumes
Data sources
All live data pulled from:
commerce__orders+commerce__order_itemscommerce__customersehs__inventory+ehs__batchehs__quote+ehs__quoteItemsehs__repairs
Export
Most reports exportable to CSV and PDF for offline analysis.
API access
/api/v1/reports/* endpoints (scope reports:read):
/reports/revenue?from=&to=/reports/orders?from=&to=/reports/inventory/reports/buyback?from=&to=
Custom reports
Power users can write custom SQL queries directly against the DB. For recurring reports, wrap them in a PHP module under modules/commerce-reports/*.php.