Shopify Inventory Management for Handmade Businesses

Most guides to Shopify inventory management are written for people who buy things and resell them. Dropshippers. Wholesalers. Retailers who receive boxes from suppliers and list the contents on their store.

If that’s you, those guides will serve you just fine.

But if you make what you sell — if your inventory starts as raw ingredients, components, and supplies before it becomes a product your customers can buy — then the standard Shopify inventory advice is going to leave you with some very specific gaps.

You can track how many candles are sitting in your shop. You can’t track how much soy wax you have left. You can see that an order came in for a batch of lip balms. You can’t automatically deduct the beeswax and coconut oil that went into making them. And at tax time, Shopify won’t calculate what those lip balms actually cost you to produce.

This guide is for the makers. The people whose inventory starts with a material purchase and ends with a sale — with a manufacturing process in between that Shopify wasn’t designed to see.

Why handmade inventory is fundamentally different

There’s a reason most inventory advice doesn’t apply to makers: it skips the part that happens before the product exists.

A retailer’s inventory journey looks like this:

1. Order stock from a supplier
2. Receive the goods
3. List them for sale
4. Sell them
5. Reorder when low

A maker’s journey looks like this:

1. Purchase raw materials
2. Track what materials you have on hand
3. Figure out what you can make with those materials
4. Make things — using up materials in the process
5. Track how many finished products you’ve made
6. List them for sale
7. Sell them
8. Know what it cost you to make each one
9. Reorder materials when low
10. Repeat from step 2

Steps 2, 3, 4, 6, 7, and 8 are invisible to Shopify. Your store sees finished products. It has no concept of a raw material, a recipe, a production run, or a cost of manufacture.

This isn’t a criticism of Shopify — it’s genuinely excellent at what it was designed to do. But “designed for retail” and “useful for handmade manufacturing” are different things, and conflating them leads to inventory gaps that can quietly cost you money.

The three gaps Shopify can’t fill for makers

Gap 1: No raw material tracking

Shopify’s inventory lives at the product level — it tracks finished goods, not what goes into them. Your soy wax, fragrance oils, jars, wicks, labels, and shipping supplies don’t exist anywhere in Shopify’s world.

This means:

• You don’t know how much of each material you have without counting physically
• You can’t see when a material is running low until you go looking for it
• You can’t calculate how many more products you can make until you physically check your supplies
• When you restock, there’s no system to update

For low-volume makers doing a handful of orders a week, this is manageable. For anyone doing regular production runs, it becomes a recurring headache.

Gap 2: No recipes or bills of materials

Shopify has no concept of a recipe or formula. It doesn’t know that each of your Lavender Soy Candles takes 200g of wax, 15ml of fragrance, one wick, and one jar. It doesn’t know that your Peppermint Lip Balm uses a different ratio of beeswax, coconut oil, and shea butter than your Vanilla version.

Without a bill of materials:

• Manufacturing doesn’t automatically deduct materials
• You have to track material usage manually (or not at all)
• You can’t calculate production capacity from materials on hand
• Scaling a batch from 10 to 50 units requires manual multiplication every time

Gap 3: No COGS calculation

Cost of goods sold is the cost of everything that went into making each product you sold. It’s essential for pricing, profitability analysis, and your tax return. Shopify tracks how much you sold. It doesn’t calculate what it cost you to make those products.

That means at the end of the year, you’re either:

• Manually working backwards from supplier invoices to estimate COGS
• Using a rough average that may or may not be accurate
• Paying an accountant extra time to piece it together for you

And if your material costs change — which they do, especially if you buy in bulk sometimes and at retail price other times — a static COGS estimate gets less accurate over time.

What a complete inventory system looks like for handmade businesses

The approach that works for most makers is running two inventory layers side by side:

Layer 1: Shopify handles your storefront and sales. Product listings, order processing, checkout, multi-location finished goods tracking. This is what Shopify is good at — lean into it.

Layer 2: A manufacturing inventory system handles everything that happens before the sale. Raw materials, recipes, production runs, COGS, and the connection between your supplies and your finished products.

The two layers connect: when you complete a production run, your manufacturing system updates your Shopify stock. When Shopify orders come in, they flow back into your manufacturing system so your material inventory stays accurate.

Neither layer replaces the other. They do different jobs.

Setting up your manufacturing inventory layer

Step 1: Catalogue your raw materials

Start by logging every material you use into your inventory system — not just the big ones. Fragrance oils, packaging supplies, labels, the mesh bags you use for soap — all of it. Each material gets its own entry with:

• Current quantity on hand
• Unit of measure (grams, millilitres, units, metres)
• Supplier and purchase history
• Cost per unit

This baseline is the foundation everything else builds on. It takes time upfront, but once it’s done, the system maintains it going forward.

Step 2: Build your bills of materials

For each product you sell, create a recipe that lists exactly what goes into making one unit:

• Each raw material
• The exact quantity used
• The unit (200g of soy wax, not just “some wax”)

Good manufacturing inventory software lets you scale these automatically. Once you’ve defined that one Lavender Candle uses 200g of wax, it knows that a batch of 24 candles uses 4.8kg — and it knows whether you have enough on hand before you start.

This is also where your COGS calculation starts. If you know exactly what went into each product, and you know what each material costs, the unit cost follows automatically.

Step 3: Log your production runs

When you manufacture a batch — whether that’s 10 candles or 200 bars of soap — record it as a manufacturing run in your system. A good system will:

• Automatically deduct the materials used (based on your recipe)
• Add the finished products to your finished goods count
• Update your material inventory in real time

This is the moment the two inventory layers connect. Material inventory goes down; finished product inventory goes up.

Step 4: Sync finished goods to Shopify

Once your batch is made and logged, your finished goods count in your manufacturing system needs to reach Shopify. This is where a Stock Push feature comes in — it prepares the quantity updates for each of your Shopify listings, lets you review them, and syncs in one action.

If you also sell on Etsy, the same push can update both channels from a single action, so your stock counts stay consistent wherever you sell.

Step 5: Orders flow back automatically

When a Shopify order comes in, your manufacturing system imports it automatically (usually nightly). This keeps your finished product count accurate in both systems without manual data entry.

More importantly: if your recipes know what went into each product, and your system knows what sold, it can maintain an accurate picture of what you’ve used and what you have left — even between physical stock counts.

A practical example: a candle maker’s workflow

Here’s what this looks like in practice for someone running a candle business on Shopify.

Monday morning: You check your manufacturing system. You have 3kg of soy wax, 8 jars of Lavender fragrance, 40 wick sets, and 40 glass jars. Your recipe says one candle takes 200g of wax, 15ml of fragrance, one wick, and one jar. The system tells you that you can make a maximum of 15 Lavender candles before you run out of wax (the limiting ingredient).

You start a production run: 15 Lavender Soy Candles. The system records the run, deducts the materials (3kg wax, 225ml fragrance, 15 wicks, 15 jars), and adds 15 candles to your finished goods count.

You trigger Stock Push: The system prepares an update for Shopify. You review it, confirm, and your Shopify listing for Lavender Soy Candle goes from 2 (your remaining stock from last week) to 17.

Wednesday: Three orders come in through Shopify. Your manufacturing system imports them overnight. Finished goods count adjusts automatically. Your remaining material stock reflects what you have after the production run and the sales.

End of month: You pull your COGS report. Every candle sold has a unit cost attached — calculated from actual material usage, not an estimate. You can see which products are most profitable and whether your pricing still makes sense.

The whole system runs mostly in the background. The parts that need your attention are production runs (which you’re doing anyway) and the Stock Push review (which takes two minutes).

What to look for in a manufacturing inventory system

Not all inventory software handles the manufacturing side. Here’s what to look for if you make things:

Bills of materials / recipe management — Can you define exactly what goes into each product? Can you scale recipes by batch size?

Automatic material deduction — When you log a production run, does the system automatically deduct materials based on your recipe? Or do you have to do it manually?

COGS calculation — Does the system calculate your unit cost from actual material costs, and does it update when material prices change?

Sales channel integration — Does it connect directly to Shopify (and Etsy, if relevant) so you don’t have to manually sync stock counts?

Material reorder alerts — Can it tell you when a specific material is running low based on your usage patterns?

Craftybase is built specifically for handmade manufacturing businesses. It handles all of these — bills of materials, automatic material deduction, weighted average COGS, Shopify sync via Stock Push, and low-material alerts. It’s designed for the maker’s workflow, not the retailer’s.

For a deeper look at how Shopify’s built-in inventory features work — including plan pricing, Shopify Flow automations, and multi-location tracking — see our complete Shopify inventory management guide.

Frequently Asked Questions