How to Track COGS in Shopify When You Make Your Own Products
Shopify's 'cost per item' field doesn't work for handmade sellers. Here's how to calculate and track COGS accurately when you make what you sell.
If you sell handmade products on Shopify, you’ve probably noticed the “Cost per item” field buried in each product’s Inventory tab. You might have even filled it in, thinking it would handle your cost tracking automatically.
It won’t. Not if you make what you sell.
That field was built for resellers: people who buy finished products wholesale and mark them up. Enter a number, Shopify tracks your margin. Simple enough. But when you’re a maker who turns raw materials into finished goods, a single static number doesn’t capture what it actually costs you to make anything. Your materials prices change. Your recipes use different quantities. Some products share ingredients. Shopify has no way to account for any of that.
This is the COGS gap that trips up thousands of handmade Shopify sellers, and it’s not obvious until you’re staring at a tax return wondering why nothing adds up.
Why Shopify Can’t Calculate COGS for Handmade Products
Shopify’s inventory system is built around a simple model: you buy something for $X, you sell it for $Y. The difference is your margin. For resellers, that model works perfectly.
Handmade sellers don’t fit that model. You don’t buy a finished candle for $4 and resell it. You buy fragrance oil, soy wax, wicks, jars, and labels. Then you combine them in specific quantities to make that candle. The actual cost depends on:
- How much of each material goes into one candle
- What you paid for each material (which changes with every supplier order)
- How you allocate shared materials across multiple products
- Whether you’re counting your labour time
Shopify’s “cost per item” field takes one number and calls it done. That number can’t automatically update when your wax supplier raises prices. It can’t split shared materials across product variants. And it certainly can’t generate the COGS report your accountant needs at tax time.
The result? Most handmade Shopify sellers are either guessing at their margins or manually keeping a separate spreadsheet. That’s exactly the kind of double-entry work that eats hours and invites errors.
What COGS Actually Means for a Handmade Seller
COGS, cost of goods sold, is the total cost of producing the products you’ve actually sold in a given period. For handmade businesses, it includes:
Materials cost: the raw ingredients and components that went into each finished product, priced at what you paid for them.
Direct labour: the time you (and any team members) spent making the products, valued at an hourly rate.
Manufacturing overhead: a share of costs that support production but aren’t tied to a single product, such as packaging, equipment depreciation, and workspace costs.
Most small makers start with materials cost alone, which is fine for early-stage tracking. The important thing is consistency: calculating COGS the same way every period so your numbers are comparable.
Here’s why it matters beyond curiosity about your margins. When you file taxes as a product-based business, COGS flows directly onto your Schedule C as an expense that reduces your taxable income. Understate it, and you overpay tax. Overstate it without backup, and you’ve got a problem if you’re ever audited. Getting it right means having a real record of what went into every product you sold, not a number you typed into a Shopify field six months ago.
The Spreadsheet Approach and Where It Breaks Down
The most common workaround for Shopify makers is a materials spreadsheet. You list each ingredient, what you paid per unit, and how much goes into each product. Run the numbers and you get a cost per unit.
This works when you have five products and three materials. It starts to fall apart when:
- You have 30+ products sharing many of the same materials
- Your supplier prices change and you have to update every formula that references that material
- You’re manufacturing in batches and need to know cost per unit from a batch of 50, not just per-unit theoretically
- You need to pull a COGS total for a full year across hundreds of orders
“It starts to get unwieldy,” as one maker put it. “And it starts to make less and less sense.” Another common complaint: not being able to trust the numbers when formulas are linked across sheets and one missed cell throws everything off.
The deeper problem is that a spreadsheet is static. It captures a snapshot of what your costs were when you built it. Craftybase works differently. Your costs are live and connected to your actual inventory.
Recipe Costing in Craftybase and How It Works
Craftybase approaches costing the way a handmade business actually operates. You start by entering your materials, the raw inputs you buy. Then you build recipes: the specific combination of materials and quantities that goes into each finished product.
When you record a purchase of fragrance oil at $28 for 500ml, Craftybase knows the cost per ml. When your recipe calls for 30ml per candle, it knows that candle costs $1.68 in fragrance oil alone. Add your wax, wick, jar, and label (each with their own quantities and purchased costs) and Craftybase calculates the total material cost per unit automatically.
Here’s what changes everything: when your fragrance oil supplier raises prices, you update one purchase. Every product recipe that uses that oil reflects the new cost immediately. No formula hunting across spreadsheets. No manual recalculation.
You can also add labour directly to recipes. Assign an hourly rate and log the time a product takes to make, and that cost gets folded into the unit cost. The more complete your recipe, the more accurate your COGS.
Step-by-step: setting up recipe costing
1. Add your materials. In Craftybase, every raw ingredient you buy goes in as a material. Add the name, unit of measure (ml, g, oz, each), and a starting quantity if you have inventory on hand.
2. Record purchases. When you buy materials, record the purchase with the price paid and quantity received. Craftybase calculates your cost per unit from that, and updates it automatically as prices change.
3. Create recipes. For each product, build a recipe that lists the materials and quantities needed per unit. This is your bill of materials: the same concept used in manufacturing, scaled down for a handmade business.
4. Record manufactures. When you make a batch of products, record a manufacture in Craftybase. It deducts the materials automatically from your inventory and costs the batch based on the recipe.
5. Connect your Shopify store. Once connected, Craftybase pulls in your orders automatically. Every time an order comes in with products you’ve manufactured, the COGS flows through correctly, because Craftybase knows what those products cost to make.
How the Craftybase-Shopify Integration Works
The integration is the part that closes the loop between making and selling. Once you connect your Shopify store to Craftybase, your orders sync automatically (typically overnight). Each order brings in the products sold, quantities, and sale prices.
Craftybase matches those sold products to the ones you’ve manufactured and costed in the system. So when someone buys your 8oz soy candle in Vanilla Sandalwood, Craftybase already knows what that candle cost to make. It records that COGS against the order.
This is what makes managing inventory on Shopify actually workable for makers. You’re not manually entering costs order by order. You’re not trying to reconcile a spreadsheet against Shopify’s order history. The costs are built into your products before they ever sell.
The sync also handles inventory. When you manufacture a batch of candles, Craftybase adds them to your finished product stock. When they sell on Shopify, the stock decrements automatically. You always know what’s on hand, without counting.
What You Get at Tax Time
This is where accurate COGS tracking pays off most visibly. At the end of your financial year, you need to know your total cost of goods sold to complete your Schedule C (or pass accurate numbers to your accountant for whatever business structure you’re operating).
With Craftybase, you pull a COGS report. It shows you total materials cost, broken down by period, against the orders that have synced from Shopify. Your accountant gets a clean number. You’re not spending a week reconstructing what things cost you from old receipts and supplier emails.
If you want to go deeper, the data is all there: cost per product, cost per order, margin by product line. That’s the kind of information that tells you which products are actually worth making and which ones are quietly eating your margins.
“Now that I know exactly what each product costs me to make, I can set prices that work for both me and my customers!” That’s Tracey Brown from Clean Heart Soap Company, and it sums it up pretty well.
COGS isn’t just a tax line item. It’s the foundation of knowing whether your handmade business is actually profitable, product by product.
For more on how COGS fits into your broader tax reporting, see our guide on COGS for handmade sellers and Schedule C reporting.
Shopify’s Cost Field vs. Real COGS Tracking
To put it plainly:
| Shopify “Cost per item” | Craftybase COGS | |
|---|---|---|
| Updates when supplier prices change | No | Yes, automatically |
| Supports recipes with multiple materials | No | Yes |
| Tracks actual batches manufactured | No | Yes |
| Generates COGS reports for tax | No | Yes |
| Works with Shopify orders | Partial (static margin only) | Full (dynamic COGS per order) |
| Handles labour costs | No | Yes |
Shopify’s field gives you a margin indicator. Craftybase gives you real COGS: the kind you can take to your accountant, use to price profitably, and rely on when making decisions about which products to keep making.
If you’re already tracking materials in Shopify’s inventory but feeling like something is missing, it’s probably this. The Shopify material inventory tracking piece explains how the two systems fit together at the inventory level, and where each one’s limits are.
Frequently Asked Questions
Does Shopify calculate COGS for handmade products automatically?
No. Shopify's "Cost per item" field accepts a single static number per product variant. It does not understand recipes, raw materials, or batch manufacturing. It was designed for resellers who buy finished goods at a fixed cost. If you make your own products from materials, Shopify has no way to calculate your real COGS. You need a tool like Craftybase that handles recipe-based costing.
How do I calculate COGS for handmade products sold on Shopify?
COGS for handmade products equals the materials cost per unit (from your recipe) multiplied by units sold, plus any direct labour you include. The most accurate method is to build a recipe for each product listing every ingredient and its quantity, record all material purchases with actual prices paid, and then track which orders used which products. Craftybase automates this calculation and syncs with Shopify orders so your COGS totals stay current as you sell.
What's the difference between Shopify's inventory cost and COGS?
Shopify's inventory cost is the number you manually enter per product, a static figure Shopify uses to estimate gross margin in its reports. COGS is the actual total cost of products you've sold in a period, calculated from real purchase prices and recipe quantities. The two rarely match for handmade sellers because Shopify's number does not update with changing material costs and does not account for recipes with multiple ingredients.
Do I need to enter my COGS into Shopify for tax purposes?
No. Your COGS for tax purposes goes on your Schedule C (or your business tax return), not into Shopify. Shopify's cost field only affects Shopify's own reports and has no bearing on your actual tax filing. What matters is that you can produce an accurate COGS total for your accountant. Craftybase generates this report directly, which is far more reliable than extracting numbers from Shopify's cost fields.
Can Craftybase sync COGS data with Shopify automatically?
Craftybase pulls your Shopify orders automatically and matches them to products you've manufactured and costed in the system. As orders sync, Craftybase records the COGS for each product sold based on its recipe and the material prices you've entered. You don't push COGS back into Shopify. Instead, Craftybase becomes your single source of truth for costing and reporting, with Shopify handling the storefront and order management side.
How do I handle Shopify COGS when I sell on multiple channels?
When you sell on Shopify plus other channels like Etsy, each platform tracks orders separately, which makes consolidated COGS reporting almost impossible without a central tool. Craftybase connects to multiple sales channels at once, pulling orders from Shopify, Etsy, Amazon, and others into one place. Because the product costs live in Craftybase rather than in each platform, your COGS calculation stays consistent across every channel you sell on.
Shopify is a great place to sell handmade products. It handles the storefront, checkout, and order management better than almost anything else at its price point. But it was never designed to help you understand what it costs to make what you sell.
That’s a gap worth closing. Not for the sake of tidy spreadsheets, but because knowing your real COGS is what separates a handmade business that’s growing confidently from one that’s busy but guessing.
If you’re selling on Shopify and you’ve been using a rough estimate, or a number you vaguely remember entering months ago, it’s worth getting that right. Craftybase connects to Shopify and gives you recipe-based COGS tracking built for the way makers actually work. 14-day free trial, no credit card needed.
