Margin-Leak Audit

Guides · Product cost

Missing product costs: why Shopify can show a profit report with the worst products left out

Every margin question depends on one number that Shopify does not require: the cost of each product. If it is blank, the product does not show zero profit. It can simply be missing from your profit reports. This guide shows how to find those products and how to read the margin once costs are in.

What Shopify's profit reports include

Shopify's profit reports include Gross profit by product, Gross profit by product variant, Profit margin by order and Average profit margin by market. The Help Center states: "Profit is reported only for products and variants that had cost recorded at the time they were sold." It adds that if orders are missing from a report, it is likely that those variants have no cost information.

So a blank cost has a practical effect: the report can look cleaner or healthier than the store really is.

What "cost per item" means

In Shopify, cost per item is the cost to you of a product or variant. For resellers, the page suggests the price paid to the manufacturer, excluding taxes, shipping and other costs. For makers, it can be based on labour and materials. Entering it is optional, in the Pricing section of the product page, and you can add costs to many products at once with the bulk editor or a CSV import.

Because the field excludes shipping and other costs, it is not your full cost of selling. Treat it as the starting point and put shipping, fees and returns alongside it.

Find the gaps

  1. Export your products. Whether the file includes cost per item is not stated on the export help page we reviewed, so open the file and check. If it does not, read costs from product pages or your supplier sheet.
  2. Filter for variants where cost is blank.
  3. Sort those by units sold, from your orders export.
  4. Enter costs for the top sellers first. Gift cards do not use this field.
  5. Re-run the profit reports and compare with before.

Do this in a copy of your data; do not paste customer details into any online tool.

Two margins that answer different questions

Shopify's page says margin is (price − cost) ÷ price × 100, for example a $50 price with a $30 cost gives 40%. On a product page, projected profit and margin are shown for products with a cost, but the page notes they are not displayed if you select "Charge tax on this product". In the profit reports, gross margin is (net sales − cost) ÷ net sales × 100, and discounts and refunds reduce net sales.

Hypothetical example, invented numbers: a $40 product with a $22 cost shows 45% on the product page. Sold with a 20% code at $32, the report margin is about 31%. Neither is wrong. See discount codes.

Beyond gross margin

Gross margin ignores everything after the product. Take the gross profit from a product and subtract what you spent on shipping, fees, returns and discounts that landed on it, and you have a contribution margin, which is closer to what you keep. The calculator does this for a single order.

What to do with the result

Need a full read?

The Margin-Leak Audit lists products with no cost recorded and states clearly that missing-cost exposure is overstated profit, not cash. For a do-it-yourself version, download the free Margin Leak Self-Check.

Sources

Help Center pages change. Check the current page before relying on a detail. Dollar figures above are invented examples.

Related guides