Orders Statistics by Product

📊 Returns top-selling products with order statistics.

HTTP: GET /orders/stats/by-product

Query parameters

Name	Type	Required	Description	Example
domain	string	no	Filter by domain.	profi-parfemy.cz
date_from	string	no	Start date (YYYY-MM-DD).	2025-01-01
date_to	string	no	End date (YYYY-MM-DD).	2025-12-31
convert_to	string	no	Convert all amounts to this currency.	EUR
limit	integer	no	Number of top products to return (default 50).	50
sort	string	no	Sort by: quantity, revenue, margin, orders.	revenue

Notes

📊 Top products by sales/revenue/margin
🏷️ Includes product ID and aggregated stats
💱 Optional currency conversion

Sample request

curl -H "Authorization: ApiKey YOUR_API_KEY" "https://admin.elpricing.com/api/orders/stats/by-product?domain=profi-parfemy.cz&limit=20&sort=revenue"

Interactive call

HTTP MethodDomainFilter by domain.Date FromStart date (YYYY-MM-DD).Date ToEnd date (YYYY-MM-DD).Convert To CurrencyConvert all amounts to this currency.LimitNumber of top products to return (default 50).Sort BySort by: quantity, revenue, margin, orders.

Queue workflow

Tasks are persisted to var/api_queue/tasks.json. Process them with:

php go.php cron:list\nphp go.php cron:go

Logs are written to var/api_queue/logs/{task_id}.log.