Shopify works out cost of goods sold from Cost per item, a number you type on each variant. When something sells, Shopify takes the cost recorded on that variant at the time of sale and uses it in its profit reports. Variants without a cost show no profit at all. For a reseller, cost per item is the supplier's price plus freight. For a maker, it's what one unit cost to make, which changes with every batch, so Shopify's COGS is only as current as the last time someone updated it.
The short version
- COGS in Shopify = cost per item at the time of sale × units sold.
- Only variants with a cost recorded at the time of sale appear in profit reports.
- Changing cost per item today doesn't fix past sales.
- Profit reports: gross profit by product, by variant and by POS location; profit margin by order; average profit margin by market.
- In the product CSV, cost per item is a plain number, no currency symbol.
Setting cost per item
Open a variant, find Cost per item in the pricing section, enter the number, and save. For many variants, use the bulk editor or the product CSV. Shopify then shows profit and margin beside the price as you edit.
What a maker's cost per item should include
| Part | Example for one 12 oz bag of coffee |
|---|---|
| Green coffee (15.5 oz, allowing roast loss) | $4.65 |
| Bag, valve, label | $0.62 |
| Roasting gas and labor, per bag | $0.85 |
| Freight on green coffee, per bag | $0.20 |
| Cost per item | $6.32 |
A made-up roaster, Hōlualoa Coffee, enters $6.32 in January. In April, green coffee goes up 25%. The real cost is now $7.48, but Shopify keeps reporting $6.32 until someone changes it. Every bag sold in between shows $1.16 more profit than it made. Shopify production cost shows how to work out each line.
Keeping cost per item current
- Recost when a big ingredient moves. If the main ingredient changes price by more than about 5%, recalculate that day, not at the end of the quarter.
- Recost after a recipe change. A bigger bag, a new label or a different blend changes the number.
- Keep the working. A spreadsheet row per product showing how you got the number makes the next update a five-minute job.
- Note the date you last updated each product, so stale costs are easy to spot.
Reading the profit reports
Under Analytics > Reports, the profit reports use cost per item:
- Gross profit by product and by variant: which products earn the most after cost.
- Gross profit by POS location: per shop or stall.
- Profit margin by order: which orders actually made money.
- Average profit margin by market: per country or region you sell to.
If a product shows no profit, check that it had a cost recorded when it sold. Shopify margin report covers reading them.
Where this stops working
Shopify's COGS is one number per variant, typed in. It can't follow ingredient prices, can't tell two batches made at different costs apart, and doesn't include ingredients that went in the bin. For an accountant, COGS also depends on stock counted at the start and end of the year, including ingredients Shopify never held. Are Shopify fees cost of goods sold covers what belongs in the number, and Shopify FIFO covers why batch costs matter.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and works out each batch's true cost from the ingredients and packaging it actually used, at what they actually cost, including freight. Stock is valued first in, first out, so margins reflect what things really cost when they sold, and a price-creep report shows which supplier's prices are moving. Free for 14 days.
