Sales per product

Store excl. VAT before refunds

Line value excl. VAT and shipping, only from lines with a proven price basis.

Formula

Σ line_total × 1/(1+VAT)

Where the AI finds it

get_product_sales → products.*.sales_excl_vat

How it is verified

Calculation checked against hand-computed values · MT-49 · McpProducts::forWindow

Ask it like this

For [store], rank products by sales per product over the last 30 days (get_product_sales).

Can be broken down by

Product soldget_product_sales

Used in prompts

The products that make the money Products often in refunded orders Products sold at thin margin

From the same tool

Units sold per productproduct_units Gross profit per productproduct_gross_profit Gross margin per productproduct_margin Refunded orders containing the productproduct_refunded_orders

Connect Claude or ChatGPT to seenly.ad and ask for this figure on your store, for any period, with its basis and verdict.

Connect