Skip to content

Working Out Production Cost for a Shopify Product

How to work out what one unit of a product you make really costs, including ingredients, packaging, waste, labor and freight, and keep Shopify's cost current.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed October 27, 2026 · 3 min read

Production cost is what one unit of a product took to make: ingredients and packaging at what you paid, plus waste, plus the labor and overheads you choose to include, divided by how many good units the batch produced. Work it out per batch, then enter the result as Cost per item in Shopify so profit reports mean something. The two mistakes that make it wrong are dividing by the planned yield instead of the actual one, and leaving out what went in the bin.

The short version

  • Cost of a batch = ingredients + packaging + freight + labor + overhead you assign.
  • Cost per unit = cost of the batch ÷ good units made.
  • Use actual yield, not the recipe's planned yield.
  • Include waste: trimmings, failed units, product used for testing.
  • Update Shopify's cost per item when a major ingredient changes price.

A worked example

Kapahulu Cookie Co., a made-up bakery, makes chocolate chip cookies in batches meant to give 240.

Line Quantity Price Cost
Flour 18 lb $0.62/lb $11.16
Butter 12 lb $4.10/lb $49.20
Sugar (brown and white) 14 lb $0.85/lb $11.90
Eggs 36 $0.38 $13.68
Chocolate chips 15 lb $5.40/lb $81.00
Vanilla, salt, soda $6.20
Bags and labels (for 6-packs) 40 $0.32 $12.80
Labor, 3 hours $22/hr $66.00
Ingredients, packaging and labor $251.94

Planned yield: 240 cookies, 40 six-packs. Actual: 12 cookies broke and 6 were eaten testing, so 222 good cookies, 37 six-packs.

  • Per six-pack on planned yield: $251.94 ÷ 40 = $6.30.
  • Per six-pack on actual yield: $251.94 ÷ 37 = $6.81.

The 51-cent difference is the real cost of breakage. If the six-pack sells for $14 on Shopify, the margin is 51%, not 55%.

What to include, and what to leave for later

  • Always: ingredients, packaging, freight on ingredients.
  • Usually: direct labor for making and packing.
  • Your choice: rent, utilities and equipment, spread per batch. Including them gives a truer cost; leaving them out gives a cleaner comparison between products. Be consistent.
  • Not here: Shopify fees, shipping to customers, marketing. Those are selling costs.

Putting it into Shopify

Enter $6.81 as the six-pack's Cost per item. Shopify uses the cost recorded at the time of sale for its profit reports, so update it when butter or chocolate move. Shopify cost per item and Shopify cost of goods sold cover the reports.

Where this stops working

The calculation above is a snapshot. Next week butter costs more, the next batch yields 230, and the number in Shopify is still $6.81. Doing this by hand for every product after every price change is the job most makers stop doing by March. Recipe costing template for Google Sheets covers a spreadsheet version, and Shopify FIFO covers costing stock made at different prices.

How TaroStack does it

TaroStack for Shopify runs inside your Shopify admin and works out each batch's cost from what it actually used and what it actually yielded, at what each ingredient actually cost, including freight. It shows actual against standard cost, flags suppliers whose prices are creeping, and keeps margins on what things really cost. Free for 14 days.

Questions people also ask

Should I include my own time in production cost?

Yes, at what you'd pay someone else to do it. Otherwise the price won't survive the day you hire help.

How often should I recalculate product cost?

When a major ingredient changes by more than a few percent, when the recipe or packaging changes, and at least every quarter.

What's a good margin for handmade products on Shopify?

It varies by product, but many makers aim for production cost to be a third or less of the retail price, leaving room for fees, shipping and wholesale discounts.

Sources

  1. Shopify Help Center: Profit reports · read October 27, 2026
  2. Shopify Help Center: Using CSV files to import and export products · read October 27, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

TaroStack for Shopify

Free for 14 days.