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.
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
- Discounts. Codes and automatic discounts reduce the price the customer paid. Net them out, or the margin is overstated.
- Refunds and returns. A refunded unit is revenue you lost. If the item is not restocked, its cost is lost too.
- Payment fees. Allocated per order, not per product, so a multi-item order needs a split rule.
- Shipping and fulfillment. A heavy or fragile product can cost more to ship than it earns in margin.
- Product cost. The number that goes stale. A supplier increase you have not entered makes every profit figure too high.
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.
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 →