Overview
Generate exportable reports for accounting, purchasing, and inventory planning. All reports are computed from real data and can be exported as CSV or JSON.
Available Reports
1. Inventory Valuation Report
Current stock value by product and location.
| Column | Description |
|---|---|
| SKU | Product SKU |
| Title | Product name |
| Cost per Item | Unit cost from supplier or Shopify |
| Quantity Available | Current stock on hand |
| Total Value | cost_per_item × quantity_available |
| Location | Warehouse location name |
Parameters: Location filter (optional)
2. Dead Stock Report
Products with no sales in a configurable number of days, with tied-up capital.
| Column | Description |
|---|---|
| SKU | Product SKU |
| Title | Product name |
| Quantity Available | Current stock |
| Cost per Item | Unit cost |
| Tied-Up Capital | cost × quantity (money sitting unsold) |
| Last Sale Date | Date of most recent sale (or "Never") |
Parameters: Days threshold (default: 60, configurable in Settings)
3. Supplier Performance Report
Delivery performance metrics for each supplier.
| Column | Description |
|---|---|
| Supplier | Supplier name |
| Total Deliveries | Number of POs received |
| On-Time Rate | % of deliveries on time |
| Avg Fill Rate | Avg % of ordered qty received |
| Avg Lead Time | Average actual delivery days |
4. Sales Summary Report
Daily sales totals for a date range.
| Column | Description |
|---|---|
| Date | Sales date |
| Total Units | Sum of units sold |
| Total Revenue | Sum of revenue |
| Products Sold | Number of distinct products |
Parameters: Start date, end date
Export Options
| Format | Description | Use Case |
|---|---|---|
| CSV | Comma-separated values | Excel, Google Sheets, accounting software |
| JSON | Structured JSON data | API integration, data analysis |
API Endpoints
| Endpoint | Parameters | Description |
|---|---|---|
GET /api/reports/inventory-valuation | location_id (optional) | Stock value report |
GET /api/reports/dead-stock | days (default: 60) | Dead stock report |
GET /api/reports/supplier-performance | — | Supplier metrics |
GET /api/reports/sales-summary | start_date, end_date | Sales totals |
GET /api/reports/export | type, format, filters | Export as CSV/JSON |
Tip: Reports are ideal for sharing with bookkeepers, accountants, or purchasing teams. Export CSV for Excel import or JSON for API integration.