- List all sales (default pagination):
GET /api/sales/read.php

- Search by customer name:
GET /api/sales/read.php?search=Jane

Filter by date range:
GET /api/sales/read.php?start_date=2026-02-01&end_date=2026-02-07

- Combined search + pagination:
GET /api/sales/read.php?search=0712&page=2&limit=5



Sales by day (last week):
GET /api/sales/report_by_day.php?start_date=2026-02-01&end_date=2026-02-07

- Top customers:
GET /api/sales/report_by_customer.php?limit=5

Top products sold:
GET /api/sales/report_top_products.php?limit=10

Revenue for all time:
GET /api/sales/report_revenue_by_day.php

Revenue for last week:
GET /api/sales/report_revenue_by_day.php?start_date=2026-02-01&end_date=2026-02-07

Product performance for all time:
GET /api/sales/report_product_performance_by_month.php

- Product performance for last year:
GET /api/sales/report_product_performance_by_month.php?start_date=2025-01-01&end_date=2025-12-31

Customer performance for all time:
GET /api/sales/report_customer_performance_by_month.php

Customer performance for last year:
GET /api/sales/report_customer_performance_by_month.php?start_date=2025-01-01&end_date=2025-12-31

- Sales by variant:
GET /api/sales/report_by_variant.php?limit=5

- Sales by parent product:
GET /api/sales/report_by_parent.php?limit=5

GET /api/sales/report_margin.php?limit=5

Something to do

do you want me to also scaffold a combined dashboard endpoint that returns multiple reports (daily revenue, monthly revenue, top products, top customers) in one JSON payload, so your frontend can load all charts in a single request?

Next step: do you want me to also scaffold a combined dashboard endpoint that returns multiple reports (sales by variant, parent aggregation, margin report) in one payload, so your frontend can load all profitability charts in a single request