Product sales
ps_get_product_sales
Shows which products sell best and how much they earned, without customer data.
TellMyShop Free: Yes. This tool is in TellMyShop Free, which costs nothing. It only reads your store and never changes anything.
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) | no | Start of the period (default 90 days before the end), YYYY-MM-DD. |
| date_to | string (YYYY-MM-DD) | no | End of the period (default today; max 366 days after the start), YYYY-MM-DD. |
| days | integer | no | Last N days up to date_to (1-366), instead of date_from. |
| 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 or by combination. Default product. |
| sort | enum: quantity | revenue | no | Sort by units or by net revenue. Default revenue. |
| 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. |
| limit | integer | no | Maximum rows (default 50, max 200). |
| offset | integer | no | Rows to skip, for paging (default 0). |
Limits
Both dates are optional: date_to defaults to today, date_from to 90 days before the end. Period max 366 days. Max 200 rows per call. Totals rounded to 2 decimal places. No customer data in the result.
Related tools
- Search products ps_search_products
- Get product ps_get_product
- Bought together ps_get_bought_together
Use cases with this tool
- Decide which products to improve first, based on sales
- Compare product sales with the previous period
- Refresh category texts for the season, and switch them back later
- Improve the pages of your 20 best sellers
- Prepare a Black Friday campaign across the shop
- Report products that haven't sold in 12 months
- Check free-shipping thresholds against your average order
- Schedule a seasonal sale in advance with start and end dates
- Write a blog post that links to your products
- Create new categories and move products into them
- A two-minute morning check of your shop
- Get the whole shop ready for Black Friday
- Clean up after a promotion
Last updated: 2026-10-11