Manufacturing Inventory Management — The Complete Guide for Small Manufacturers

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 product business 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 manufacturer or product-based business, from the basic definitions through to the formulas, the terminology, and the software options worth considering.

What is manufacturing inventory management?

Manufacturing inventory management tracks raw materials, work-in-progress, and finished goods through every stage of production, from incoming supplies to completed products ready to sell.

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 product businesses 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 product businesses

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 small-batch and independent manufacturers

For product businesses, 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 product businesses 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.

Multi-channel inventory management for product businesses

Selling across multiple channels is basically the default now. Etsy for direct-to-consumer sales, 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: Multi-channel inventory management for product businesses

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 product businesses often can’t count on.

The pandemic supply chain disruptions made this painfully visible. Businesses 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 small-batch business.

A more practical approach for most product businesses 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.

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 product businesses that 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.

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.

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.

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

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 product businesses end up busy but broke. Track your costs from the start, even if the numbers feel small.

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)

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

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 product businesses 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 product businesses combines all of these features in a single system, so your materials, production runs, and sales all stay in sync without manual updates.

Software options worth considering

Stocksmith is built specifically for small-batch and independent 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.

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 small team running their studio.

The honest answer for most small-batch product 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 manufacturing 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 product business, one that actually understands the difference between raw materials and finished goods, and fits the way you work.

See how Stocksmith handles manufacturing inventory management →

Frequently Asked Questions