Product sales
ps_get_product_sales
Read-onlyBlock 1 · Content & SEOFree in AuditDaily connectorVisible right after install
Shows which products sell best and how much they earned, without customer data.
Ask Claude
„Which 20 products sold best in September, compared with August? Start the description work with those.”
Example answer
1. Sofa Oslo 3-seat: 14 units, 28,443 PLN net (+22% vs August). 2. Corner sofa Bergen: 9 units ...
Technical details
Best-selling products in a period: units, net and gross revenue in the shop's default currency (other currencies converted at the rate stored in the order), number of orders, optional comparison with the previous period of the same length. Only valid (paid) order states, no customer data.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date_from | string (YYYY-MM-DD) | yes | Start of the period. |
| date_to | string (YYYY-MM-DD) | yes | End of the period (max 366 days from the start). |
| category_id | integer | no | Only products of this category, with subcategories. |
| compare_previous | boolean | no | Compare with the previous period of the same length (default false). |
| group_by | enum: product | combination | no | Group by product (default) or combination. |
| sort | enum: quantity | revenue | no | Sort by units or net revenue (default revenue). |
| limit | integer | no | Maximum rows (default 50, max 200). |
| offset | integer | no | Rows to skip, for paging (default 0). |
| shop_id | integer | no | Shop ID in a multistore installation. Defaults to the shop in the connector address. IDs are listed by ps_get_shop_info. |
Limits
Period max 366 days. Max 200 rows per call. No customer data in the result.
Related tools
- Search products ps_search_products
- Get product ps_get_product
Last updated: 2026-10-03