Check whether your price covers your costs
See what each sale contributes after the costs you enter, and use the break-even price to understand the point where those costs are covered.
See what you keepfrom each sale.
After product costs, shipping, fees, fulfillment, advertising, and returns, how much is left from each sale?
The Product Profit Calculator brings those costs together so you can check whether your prices leave enough room and see what a discount would change.
Product Profit Calculator / Shopify Edition $20.00
Google Sheets calculator + PDF guide · Manual entry
What you keep per saleExample / 01
A discount changes more than the price.
$20.00contribution profit per sale
Selling price$50.00
Costs per sale$30.00
Contribution margin40%
Illustrative example with costs held at $30. Contribution profit excludes fixed overhead and taxes.
In this example, a 20% discount cuts contribution profit in half. Check the effect before choosing your offer.
Up to 50 productsCompare results across your products
Built-in formulasEnter your numbers in the blue cells
PDF guide includedHelp with inputs and results
Give your pricing decisions a clearer starting point.
You need to know what a product leaves after its costs before deciding whether its price or a planned discount makes sense for your business.
For $20.00, you get:
- Cost fields and formulas already set up
- A summary of your product results
- Price scenarios to test changes before making them
- A PDF guide to help you enter numbers and read results
Inside the calculator
Know which products leave you money to work with.
Use the results to review your prices, spot products with little room left after costs, and decide which numbers need a closer look.
SKU Profit Calculator / At a GlanceActual workbook preview
Select the image to enlarge it. The preview shows the workbook before your numbers are entered.
Find products that need a closer look
Identify products that leave little or nothing after costs, then review their pricing and expenses. Input flags help you check missing or unusual numbers first.
See how your products compare
Check up to 50 products in one workbook instead of working through each one separately, with a summary showing profitability counts and rows to review.
The Price Scenario Tool
Run the numbers before you run the sale.
Before running a discount or changing a price, check how much you would keep at the new amount. You can also see how higher shipping or advertising costs affect a selected product.
You can also enter your own combination of changes to see how they affect your profit and margin.
New priceDeeper discountHigher shipping costHigher ad cost
Price Scenario Tool / One product at a timeActual workbook preview
Select the image to enlarge it.
Your download
The calculator and a guide to using it.
Work through your product numbers in Google Sheets, with the companion PDF to help you gather costs and understand your results.
- SKU Profit CalculatorProfit, margin, break-even price, and status for up to 50 products.
- At a Glance SummaryProduct profitability counts and rows to check.
- Price Scenario ToolCompare changes for one selected product at a time.
- Companion PDF GuidePlain-English steps for gathering numbers and reading results.
The PDF guide is included with your calculator.
Getting started
Understand what to enter and what your results mean.
- Gather your costs.
Use the guide to work through the numbers you need.
- Enter them in the blue cells.
The formulas are already built into the calculator.
- Review your results.
Check your profit, read the flags, and decide what to look at next.
Not sure of a cost yet? Use your best estimate and update it when you have a confirmed number.
Good to know before you buy
Does it connect to my Shopify store?
No. You enter your prices and costs manually in Google Sheets. No store connection is required.
What does “profit” mean here?
Contribution profit: what’s left from each sale after the per-unit costs you enter. It does not include fixed overhead or taxes, so it’s not your final net profit.
Can I use it if I ship orders myself?
Yes. Enter your own packaging and shipping costs, and use zero for costs that don’t apply.
How many products can I check?
Up to 50 in the SKU Profit Calculator. The Price Scenario Tool looks at one selected product at a time.
Do I need spreadsheet experience?
The formulas are already set up. Enter your numbers in the blue cells and follow the companion guide for help with inputs and results.
How does this help if I already track my sales?
Sales totals tell you what customers paid. This calculator brings together the per-unit costs you enter so you can see what remains for each product and test how a proposed change affects it.
What do I get?
A Google Sheets calculator with the SKU Profit Calculator, At a Glance Summary, and Price Scenario Tool, plus a companion PDF guide.