Manufacturing Inventory Management — The Complete Guide for Makers

If you’re managing your raw materials in a spreadsheet called something like “Stock_Final_v3.xlsx” — we get it. That’s where almost every maker starts. But at some point the spreadsheet stops keeping up: you’ve sold something on Etsy that you already committed to a Shopify order, your resin stock is at zero but the spreadsheet says otherwise, and you’re not totally sure which batch of candle dye you used for last month’s wholesale run.

That’s the manufacturing inventory problem. And it’s different from the inventory problem a retail shop has — because you’re not just moving boxes around. You’re transforming materials into products — beeswax into candles, lye and oils into soap, polymer into jewelry, botanicals into cosmetics — tracking what went into what, and trying to keep track of stock across multiple places at once.

Last updated: March 2026

This guide covers everything you need to know about manufacturing inventory management as a small-batch maker or handmade seller — from the basic definitions through to the formulas, the terminology, and the software options worth considering.

What is manufacturing inventory management?

Inventory management is the process of tracking and controlling stock across a business — purchasing it, storing it, and moving it out the door. In a standard retail context, that mostly means tracking finished goods: what you bought, what you sold, what’s left.

Manufacturing inventory management adds a layer on top of that. Because you’re making things, you also have to track:

• Raw materials — what you have on hand, what you’ve used, and what you need to buy
• Work in progress (WIP) — partially completed products sitting on your workbench or in a production queue
• Finished goods — completed products ready to ship or list for sale

Managing all three simultaneously is what makes inventory for makers genuinely different from retail inventory. The raw materials you buy feed into production runs, production runs consume materials and generate WIP, and WIP eventually becomes finished goods — which then get sold across whatever channels you use.

Get any part of that chain out of sync and things unravel quickly.

Why most inventory advice doesn’t apply to makers

Here’s a slightly uncomfortable truth: most inventory management content is written for businesses that buy finished goods and resell them. The advice is designed for a shop that orders widgets from a supplier and sells them on. It assumes your “inventory” is a box of things you didn’t make.

If you make things, that model breaks down. Your inventory starts as ingredients or materials, gets consumed during production, and only becomes a product at the end of the process. Standard retail inventory tools typically can’t handle that transformation — they have no concept of a Bill of Materials, no way to deduct raw material stock when you run a production batch, and no way to track what went into a specific lot if a customer has a quality issue.

This is why small-batch manufacturers often end up with a patchwork: one spreadsheet for materials, another for stock, a third for orders. The information exists — it’s just scattered.

Inventory management for handmade and small-batch manufacturers

For makers, the inventory flow looks like this:

1. Raw materials come in. You order beeswax, fragrance oils, and wicks. You receive them, check quantities, and put them away. Your materials inventory goes up.

2. A production run starts. You make 40 candles. That consumes a specific amount of each material — your materials stock goes down, and you now have 40 units of WIP (or, if you finish them in one session, 40 units of finished goods).

3. Finished goods go into stock. Your product inventory goes up by 40.

4. Sales happen. Each sale reduces your finished goods count. If you’re selling across Etsy and Shopify, both channels need to reflect the same stock level — which is where multi-channel inventory gets complicated.

5. You need to reorder. When materials drop below a certain level, you need to reorder before you run out. The trick is knowing that level before you’re placing an emergency order at 11pm.

The right manufacturing inventory management software handles all five of these steps automatically — deducting materials when you log production, updating stock when you make a sale, and flagging when you’re running low. Without it, you’re doing each step by hand, and that’s fine until it suddenly isn’t.

See also: Work in Progress (WIP) inventory — what it is and how to track it

Retail vs. wholesale inventory management

Retail businesses sell directly to consumers — either online (Etsy, Shopify, your own website) or in person at markets and boutiques. Retail inventory management focuses on keeping enough finished goods on hand to fill orders quickly. Customers expect fast fulfilment and won’t usually wait long.

Wholesale businesses sell to other businesses — retailers, boutiques, gift shops — usually in bulk. Wholesale typically involves longer lead times, larger order quantities, and different pricing structures. The inventory challenge shifts from speed to volume: you need enough materials and production capacity to fill a 500-unit order from a boutique chain.

Many makers do both, which makes inventory management more complex. A candle maker might sell individually on Etsy, in packs on their Shopify store, and in wholesale quantities to a gift shop — all from the same pool of raw materials and finished goods.

See also: Wholesale Price Calculator

Multi-channel inventory management for makers

Selling across multiple channels is basically the default now. Etsy for handmade buyers, Shopify for your own store, perhaps a market stall on weekends and occasional wholesale orders. That’s four places where stock can move — and if your inventory system doesn’t sync them all, you will at some point sell something you don’t have.

Multi-channel inventory management means maintaining a single source of truth for your stock levels, and pushing updates to every sales channel automatically when something sells. When a customer buys your lavender soap on Etsy, your Shopify listing should reflect that immediately — not after you remember to update it manually.

This is called inventory synchronization or Stock Push. In practice it means:

• Every sale on every channel reduces the same central stock count
• If you have 10 units and sell 3 on Etsy, all other channels show 7 — automatically
• New stock you add after a production run appears everywhere at once

Without sync, the most common failure mode is overselling — taking payment for stock you don’t have. The second most common is underselling — keeping listings artificially low out of fear of overselling, leaving money on the table.

Read more: How to sync Etsy and Shopify inventory and Best inventory sync software for makers (2025)

Just-in-time manufacturing and inventory

Just-In-Time (JIT) manufacturing is a strategy built around minimizing stored inventory by producing or ordering only what you need, when you need it. In theory it reduces waste and frees up cash. In practice, it depends on reliable suppliers and predictable demand — two things small-batch makers often can’t count on.

The pandemic supply chain disruptions made this painfully visible. Makers relying on single suppliers with no safety stock buffer found themselves unable to fulfil orders for weeks or months. JIT works best when your supply chain is stable and your demand is predictable — not ideal conditions for a growing handmade business.

A more practical approach for most makers is a hybrid: maintain a reasonable safety stock buffer on your most-used materials, and use reorder points to trigger purchasing before you run out rather than after.

Read more: Stockout prevention — how to avoid running out of stock

Why inventory management matters for small manufacturers

Small manufacturers sometimes figure they can worry about “proper” inventory management later, once the business is bigger. We’d argue the opposite — it’s much easier to build good habits from the start than to untangle years of spreadsheet chaos later.

Cost savings

Proper inventory management cuts costs in ways that compound over time:

• Avoid stockouts and overbuying. Stockouts mean lost sales and disappointed customers. Overbuying ties up cash in materials that sit on shelves gathering dust. Knowing your actual usage rates helps you order the right amount at the right time.
• Reduce waste. Tracking material usage precisely shows you where things are going — including what gets used in production and what gets wasted. That’s real money.
• Improve cash flow. Cash tied up in excess inventory is cash you can’t spend on marketing, equipment, or materials you actually need.

Efficiency

When your inventory is accurate, a lot of decisions that used to require manual checking get easier. You know whether you can take a large wholesale order. You know which materials to reorder. You know how long a production run will take based on what you have on hand.

Customer satisfaction

Accurate stock levels mean you’re not overselling, not cancelling orders, and not sending “sorry, we’re out” messages to buyers who’ve already paid. That consistency builds the kind of reputation that drives repeat business.

Scalability

The makers who scale most cleanly are usually the ones who built inventory discipline early. When you’re doing 20 orders a month, chaos is manageable. At 200 orders a month, it’s catastrophic. Good systems now mean you’re not scrambling to build them later.

Best stock management practices for small manufacturers all point to the same thing: start tracking before you feel like you have to. By the time you need it urgently, the cost of catching up is much higher than the cost of setting it up right.

Common manufacturing inventory metrics

A handful of key metrics give you a read on how your inventory is performing:

Lead time — how long it takes to receive materials from your supplier after you place an order. Knowing your lead time lets you set reorder points that give you enough buffer to never run out.

Inventory turnover — how often your stock is sold or used in a given period. Higher turnover generally means your capital is working efficiently. Very low turnover on specific materials might mean you over-ordered.

Average inventory — the average amount of stock you hold over a period. Useful for calculating holding costs and understanding whether you’re carrying too much.

Days of supply — how long your current stock would last at your current sales rate. Useful for planning production runs and ordering schedules.

By tracking these over time, you develop an intuition for your business’s rhythm — when you typically run low, when demand spikes, and where your biggest inventory risks are.

Manufacturing inventory terms you should know

These are the core terms you’ll encounter when working with manufacturing inventory systems:

Batch tracking — tracing a group of materials or products through production. Essential for quality control — if a product has a defect, batch tracking lets you identify which materials were used and which other products might be affected.

Bill of Materials (BoM) — a list of all materials (and their quantities) needed to make one unit of a product. The foundation of manufacturing inventory management.

Bin location — a specific storage location within your workspace. Useful once you have enough materials that “somewhere in the studio” isn’t a useful answer.

Bundles — groups of products sold together as a single listing, often at a discount.

COGS (Cost of Goods Sold) — the total material and production cost of the inventory you’ve sold. A critical number for pricing and tax purposes.

Cycle count — a scheduled physical count of a subset of your inventory, rather than a full stocktake. Regular cycle counts catch discrepancies before they become big problems.

Deadstock — inventory that can no longer be sold (expired, damaged, or obsolete).

FIFO (First In, First Out) — using the oldest stock first. Important for perishable materials like food ingredients, cosmetic bases, or resins with shelf lives.

Holding costs — the costs of storing inventory: space, insurance, spoilage risk.

Inventory shrinkage — stock loss due to theft, damage, spillage, or measurement errors.

Lot tracking — tracking inventory by production lot or supplier batch number. Related to batch tracking; critical for traceability in regulated categories like cosmetics or food. Lot tracking software automates this process, linking materials to specific production batches and finished goods.

MRP (Materials Requirements Planning) — a system for calculating what materials you need, in what quantities, and when to order them — based on your production schedule.

Reorder point — the stock level at which you need to place a new order to avoid running out before the next delivery arrives.

Safety stock — a buffer of extra stock held to absorb demand spikes or supplier delays.

SKU (Stock Keeping Unit) — a unique code identifying a specific product or material variant. Need help generating SKUs quickly? Use our free SKU generator tool to create unique identifiers for your products and materials.

Stock Push — automatic synchronization of stock levels across multiple sales channels when a sale occurs on any one of them.

Supplies vs. Materials — in Craftybase terms, materials go into your products (and are tracked by usage); supplies are consumed in your business but don’t become part of the product (packaging tape, labels).

Traceability — the ability to trace a finished product back to the specific materials and production batches used to make it.

Variant — a version of a product that differs in some attribute (size, scent, color) but shares the same base recipe or structure.

Work in Progress (WIP) — inventory that has been started but not yet completed — partially assembled products, mixed compounds that haven’t been poured, etc.

Manufacturing inventory formulas

These are the key calculations for managing your inventory levels:

Turnover formula

How often your inventory is sold or used in a given period. Higher is generally better.

turnover = sales ÷ average inventory

Cost of goods sold (COGS)

What it actually cost you to make the products you sold — including materials, not just the sale price.

COGS = opening inventory + inventory purchases − closing inventory

This is one of the most important numbers in your business — and one of the most commonly guessed at. If you don’t know your true COGS, you don’t know whether your best-selling product is actually making you money or quietly losing it. Pricing on instinct is how makers end up busy but broke. Track your costs from the start, even if the numbers feel small.

Read more: How to calculate COGS

Economic order quantity (EOQ)

The optimal order quantity that minimizes total ordering and holding costs.

EOQ = √(2DS ÷ H)

Where D = annual demand, S = cost per order, H = holding cost per unit per year.

Days inventory outstanding (DIO)

How many days your current inventory would last at your current sales pace.

DIO = average inventory ÷ sales per day

Reorder point

The stock level that should trigger a new purchase order — calculated to account for lead time and expected demand during that lead time.

reorder point = (average daily usage) × (lead time in days)

Read more: How to set reorder points

Safety stock

The buffer you hold above your reorder point to absorb unexpected demand spikes or supplier delays.

safety stock = (maximum daily demand − average daily demand) × maximum lead time

Read more: How to calculate safety stock

Maximum inventory level

The highest level of stock you should hold before storage costs outweigh the benefits of having it on hand.

maximum inventory level = reorder point + order quantity − (minimum daily demand × minimum lead time)

Manufacturing inventory management software

Most makers start with a spreadsheet. That works for a while — until you’re selling across multiple channels, running regular production batches, and trying to track material usage for 15 different products simultaneously. At that point, spreadsheets start costing you more time than they save.

Manufacturing inventory management software handles the things spreadsheets can’t:

• Automatic material deduction — when you log a production run, the software reduces your raw material stock by the quantities in your Bill of Materials
• Real-time stock levels — no more “I think we have about 200g of this left”
• Multi-channel sync — when a sale happens on Etsy, your Shopify listing updates automatically
• Lot and batch tracking — trace any product back to the materials and production run used to make it
• Reorder alerts — get notified when a material drops below your reorder point, before you run out
• Production orders — plan and track manufacturing runs from materials in to finished goods out
• COGS reporting — know exactly what your products cost to make, automatically

The best inventory management software for makers combines all of these features in a single system, so your materials, production runs, and sales all stay in sync without manual updates. If you’re comparing options, we’ve broken down how Craftybase compares to Zoho Inventory and Craftybase stacks up against Trunk — both popular choices for small manufacturing operations.

If you’re a soap maker, candle maker, jewelry maker, or cosmetics formulator, we’ve written dedicated guides on soap making inventory management, candle making inventory management, jewelry business inventory management, and cosmetics manufacturing inventory management that dive into the specifics of your craft.

Software options worth considering

Craftybase is built specifically for handmade and small-batch manufacturers. It handles the full raw materials → production → finished goods flow, connects to Etsy, Shopify, WooCommerce, Wix, and Faire, and includes a Stock Push feature that syncs inventory across all your channels when a sale happens anywhere. It’s the only tool in this category that starts with a Bill of Materials and works forward through production — rather than starting with finished goods and working backward.

Read more: Best manufacturing software for small business, Best inventory sync software for makers, and the best inventory management systems for small manufacturers

QuickBooks Online includes basic inventory tracking and integrates with many Shopify and Etsy connectors, but it has no concept of raw materials, Bills of Materials, or production runs. It treats inventory as finished goods only — which means you’d need a separate system for tracking your materials.

inFlow Inventory and Fishbowl are mid-market manufacturing tools with BoM support and production tracking, but they’re built for traditional manufacturing businesses with purchase orders, warehouses, and dedicated inventory staff — not a solo maker running their studio. For a detailed comparison of how Craftybase stacks up, see our guides on Craftybase vs Katana (comparing cost and features) and Craftybase vs MRPEasy (comparing affordability and maker focus).

The honest answer for most handmade businesses: you want a tool that understands you’re making things, not just selling them.

From spreadsheet chaos to stock you can trust

Manufacturing inventory management is the difference between running your maker business on instinct and running it on information. When your stock levels are accurate, your materials are tracked, and your channels are in sync, a whole category of low-grade stress just disappears — the “did I oversell?”, “do I have enough beeswax?”, “which batch did that come from?” anxiety that eats up mental bandwidth you’d rather spend making things.

You don’t need a warehouse management system or an enterprise software budget to get there. You need the right tool for a maker business — one that actually understands the difference between raw materials and finished goods, and fits the way you work. If you’re new to inventory tracking, our guide to catching up in Craftybase walks you through setting up your first materials, recipes, and production runs step-by-step.

Craftybase is built for exactly this: soap makers, candle makers, cosmetics formulators, jewelers, and every other maker who produces things in batches and needs to know their numbers without a spreadsheet nightmare. If you’re a jewelry maker specifically, see our dedicated guide to jewelry inventory management — it covers how to set up materials registers, product recipes, and reorder points for the complexity of wire, stones, and findings.

See how Craftybase handles manufacturing inventory management →

Frequently asked questions

What is manufacturing inventory management?

Manufacturing inventory management is the process of tracking raw materials, work-in-progress (WIP), and finished goods through production. Unlike retail inventory — where you’re just counting boxes on a shelf — manufacturing inventory follows the transformation of materials into products, tracking what goes in, what comes out, and what’s left at every stage.

What’s the difference between retail and manufacturing inventory?

Retail inventory tracks finished goods: what you bought from a supplier, what you sold, what’s still in stock. Manufacturing inventory adds two extra layers — raw materials and WIP. You need to know not just how many candles you have ready to sell, but how much wax, fragrance oil, and wick you have on hand, and how many candles are mid-production.

Do I need inventory management software as a small maker?

You can start with a spreadsheet, but most makers outgrow them once they’re selling across multiple channels or running regular production batches. The tipping point is usually when updating stock by hand starts taking more time than making products — or when you oversell something for the first time.

What is Stock Push in inventory management?

Stock Push is automatic inventory synchronization across sales channels. When a product sells on one channel (say, Etsy), Stock Push updates the available quantity on all your other channels (Shopify, WooCommerce, your website) immediately — preventing overselling without manual updates.