Home / Blog / Shopify Profit Calculator
How-to · 2026

Shopify Profit Calculator: Profit per Product After Fees, Discounts and Refunds

Shopify shows what each product sold for. It does not show what you kept after payment fees, shipping, discounts and refunds. The gap is often the difference between a best-seller and a product that loses money.

By · Published November 17, 2026 · 7 min read

A Shopify profit calculator should answer one question for each product: what did we keep? That means net sales after discounts and refunds, minus payment fees, minus product cost, minus shipping and fulfillment. A simple price-minus-cost calculator skips most of those lines, and the skipped lines are the ones that decide whether a product is worth selling. Below is a worked example, then how to run the calculation on your own orders.

A worked example

The figures are illustrative: one product sold over a month.

Gross sales (40 units at $60)               2,400.00
- Discounts                                   -180.00
- Refunds (2 units)                           -120.00
= Net sales                                  2,100.00

- Payment fees (about 3.2% of net sales)       -67.20
- Product cost (40 units at $18, less 2 refunded)  -684.00
- Shipping and fulfillment (38 orders at $9)  -342.00
= Profit                                      1,006.80

Margin on net sales = 1,006.80 / 2,100.00 = 47.9%

The dashboard would show $2,400 of sales for this product. It kept $1,006.80, about 42% of that. That gap is why a product can look like a best-seller on the dashboard and still be the thinnest line you carry.

The lines people leave out

The spreadsheet version

Export orders with line items, and one row per product for the period. Columns: gross sales, discounts, refunds, units refunded, fee rate, cost per unit, shipping per order, orders. Then:

Net sales   =C2-D2-E2
Profit      =H2-(H2*F2)-(G2-I2*J2)-(K2*L2)
Margin      =M2/H2

These columns are a layout, not a template. Check the references against your own export before you fill down, and keep the same layout each month so the rows compare.

Running it on your Shopify orders

Doing this by hand is a few hours a month for a small catalogue and a day for a large one, and it breaks each time the order export changes shape. Quiriz reads the Shopify orders export or the connector, keeps the profit definition in Company Context, and answers the question directly. In Excel with the Excel add-in:

=QUIRIZ.ASK("profit and margin on net sales by product, last 30 days, after fees, discounts and refunds", "table")

In Google Sheets, use the Sheets add-in with the function written without the dot. The answer lists the costs it used. If a product has no cost entered, it says so, rather than showing a profit figure that is really just revenue.

Where this stops. The fee allocation and the refund timing are conventions you choose. Quiriz applies the one you define, and it cannot recover a product cost nobody recorded. For the same products against their ad spend, use the break-even ROAS post, and for cost data alone, gross margin by SKU.

🛠 Free tool: prefer not to click through menus? the free Shopify Profit Calculator takes one product’s units, discounts, refunds and costs and returns profit and margin, in your browser.

Profit per product from your Shopify orders

Try it on sample store data with no signup, then connect your Shopify store and ask for profit by product.

Try Quiriz free →

Frequently asked questions

Does Shopify have a profit report by product?
Shopify reports sales and some margin fields, but the margin depends on product costs you have entered, and it does not allocate every fee, shipping cost or refund to the product. Check the report definitions before you rely on it for a decision.
Should discounts reduce the product profit or the sales figure?
Both, in the sense that discounts reduce the revenue you keep. Calculate profit on net sales, after discounts, so the profit figure matches what hit the bank.
How do I allocate payment fees to a product?
Allocate each order’s fee across the products in it by their share of the order value. That is an approximation, and it is the usual method. Say so in the definition.
What about refunds that happen next month?
Attribute them to the period of the original sale or to the period of the refund, and say which. Choosing one and keeping it is what makes the monthly figures comparable.
Is a profit calculator the same as an ROAS calculator?
No. Profit per product tells you what a product keeps after its own costs. Break-even ROAS tells you what return the ads need to pay for themselves. Use both: the first picks products, the second judges campaigns.