Inventory Planning for Makers Who Formulate Lotions, Salves, Soaps, and Candles

For many small makers, inventory starts as a shelf full of oils, waxes, jars, lids, labels, and fragrance bottles. Then the business grows. Suddenly, one missing preservative can delay a lotion batch, a forgotten box of old sweet almond oil can spoil on the back shelf, or a holiday candle rush can wipe out your wick supply faster than expected.

Inventory planning is what turns that chaos into a working system.

If you formulate lotions, salves, soaps, or candles, inventory is not just a count of what you own. It is the link between product quality, production scheduling, compliance, and profit. The goal is not to track every last scrap of tape with perfect precision. The goal is to know what matters, buy at the right time, use ingredients before they decline, and connect every batch to the materials that went into it.

Start by separating inventory into the right categories

One of the most useful shifts for makers is to stop treating all inventory as if it behaves the same way. A drum of wax, a bottle of preservative, and a case of labels do not need identical tracking.

In practice, most formulators are managing three inventory groups:

• Raw materials such as oils, butters, waxes, lye, water-based additives, fragrances, essential oils, colorants, and preservatives
• Packaging and consumables such as jars, bottles, caps, pumps, labels, wicks, boxes, shrink bands, and tape
• Finished goods that are ready to sell

This matters because each category creates different risks. Raw materials affect formula performance, safety, and shelf life. Packaging can stop production even when ingredients are available. Finished goods affect cash flow and order fulfillment.

A useful way to prioritize attention is ABC analysis. In simple terms, this means giving your most detailed tracking to the items that are expensive, critical, or hard to replace, while using lighter-touch controls for low-cost items.

For example, many makers benefit from closely monitoring:

• Fragrance and essential oils
• Specialty wax blends
• Preservatives and active ingredients
• High-cost butters or carrier oils
• Unique packaging components that are hard to source quickly

Meanwhile, trying to track every inch of tape or every sticker in real time often creates more admin work than value. Planning works better when the effort matches the importance of the item.

FIFO is not optional when you formulate with shelf-limited ingredients

FIFO, or first in, first out, is one of the simplest inventory rules and one of the most important. The oldest usable stock should be used first.

That is especially relevant for lotion and salve makers working with botanical oils and butters, and for candle and soap makers storing fragrance oils over long periods. Industry guidance commonly notes that many carrier oils and butters have shelf lives in roughly the 1 to 4 year range, depending on the ingredient and storage conditions. Essential oils and fragrance oils can also degrade or oxidize over time, which may change scent performance and, in some cases, affect product quality or safety.

In a real workshop, FIFO looks less like theory and more like shelf discipline:

• Put newer stock behind older stock
• Label every container with received date and supplier lot number
• Record expected expiry or best-by dates
• Open and use partial containers before starting a fresh one when appropriate

This is where a formulation workflow and an inventory workflow need to connect. FormulaPilot can help you keep formulas organized, but inventory planning adds the operational layer: what ingredient lot you actually used, when it was received, and whether it should still be in circulation.

Without FIFO, makers often end up paying for ingredients twice: once when they buy them and again when they throw them away.

Reorder points prevent the most frustrating stockouts

The ingredient that stops production is often not the one you expected. It might not be your main oil or wax. It might be the emulsifier, the wick tab, the preservative, or the 4 oz amber bottle that every product line uses.

That is why reorder points matter.

A reorder point is the inventory level at which you place a new order before you run out. It should account for how quickly you use the item and how long it takes to replace. If your lead times are inconsistent, reorder earlier. If a material is crucial to multiple products, protect it more carefully.

For small makers, a practical starting point is to set reorder points for:

• Any ingredient that appears in multiple bestsellers
• Packaging used across several SKUs
• Supplies with long or unreliable supplier lead times
• Materials that are expensive to expedite at the last minute

Once you define a reorder point, the next step is safety stock. This is your buffer. It protects you against delayed shipments, damaged goods, seasonal spikes, and the simple reality that demand is never perfectly predictable.

A business making winter salves, holiday candles, or giftable soap sets usually needs more buffer than a business with steady year-round volume. The exact amount will vary, but the principle stays the same: the more painful a stockout would be, the more carefully that item should be protected.

Demand forecasting should be simple enough to use

Forecasting can sound overly corporate, but for makers it often means asking a few grounded questions before placing your next purchase order.

What sold last winter? Which candle scents moved during the holidays? Do body butters rise in colder months? Did one soap design create a packaging bottleneck? Did a promotion on Etsy or Shopify create a sudden run on one SKU?

You do not need a complex forecasting model to improve decisions. Start with:

• Historical sales by product
• Seasonality by category
• Planned launches or promotions
• Lead times for key ingredients and packaging
• Minimum order quantities from suppliers

This kind of forecasting helps you buy enough without overcommitting to ingredients that may age on the shelf. It is particularly important for fragrances, natural oils, and trend-driven seasonal products.

The biggest planning mistake is often buying as if every month is average. Maker businesses rarely work that way. Sales cluster around weather, gifting seasons, launch schedules, and events. Your inventory plan should reflect that rhythm.

Batch tracking protects both cost accuracy and traceability

When a batch is made, the business should know exactly which materials went into it. That means ingredient names, quantities used, supplier lots, and ideally packaging lots where relevant.

Batch tracking matters for two reasons.

First, it improves costing. If you want accurate cost of goods sold, you need more than a rough estimate of how much oil or wax probably went into production this month. You need inventory consumption tied to actual batches.

Second, it supports traceability. For cosmetic products in the United States, recordkeeping and traceability expectations have increased under the FDA's Modernization of Cosmetics Regulation Act of 2022, commonly called MoCRA. For makers selling lotions, salves, and other cosmetics, maintaining detailed records of ingredients, sources, and lots is part of a more resilient compliance process and can be critical if you ever need to investigate a quality issue or manage a recall.

Even if you are very small, batch records make it easier to answer practical questions fast:

• Which lot of fragrance oil went into this candle batch?
• Which preservative lot was used in these lotions?
• Which finished units were filled from a specific production run?
• Which customers may have received affected stock?

Spreadsheets can handle some of this at a basic level, but once volume increases, dedicated inventory tools usually reduce errors and make retrieval much easier.

Do not let waste disappear into the numbers

Waste is inventory movement too.

If a fragrance spills, if a soap batch seizes, if a lotion test batch gets discarded, or if a candle pour has to be remelted and reworked, that should be recorded separately rather than silently absorbed into your general inventory count.

Tracking waste does two useful things:

• It gives you a more honest COGS picture
• It highlights process problems you may be able to fix

A ruined batch may point to a scaling issue, a temperature control problem, a packaging mismatch, or a formula process step that needs refinement. If waste is invisible, those patterns stay hidden. If it is logged consistently, your inventory records become a tool for process improvement rather than just bookkeeping.

Spreadsheets work until they do not

Many makers begin with spreadsheets, and that is completely reasonable. A spreadsheet can be enough when your SKU count is low, your formulas are simple, and your production volume is manageable.

But formulators tend to outgrow spreadsheets sooner than expected because inventory is interconnected. A single finished product may draw from a formula, a batch record, multiple raw material lots, packaging components, and one or more sales channels. As complexity rises, manual systems become harder to trust.

Dedicated inventory software is often a better fit when you need:

• Batch and lot tracking
• Expiry date monitoring
• Multi-step recipe or formula support
• Automatic COGS calculations
• Reorder alerts
• Integration with Etsy, Shopify, or other sales platforms

This is why many maker-focused systems emphasize more than stock counting. They connect costs, materials, production, and sales. If you already use FormulaPilot for formulation work, it makes sense to pair that structured formula data with an inventory process that can manage lot numbers, shelf life, and stock movements more reliably than a generic spreadsheet.

A practical inventory planning routine for small makers

The best inventory system is the one you will actually maintain. For most small businesses, consistency beats complexity.

A workable routine often looks like this:

• Receive inventory and label it immediately with date, supplier, and lot number
• Store materials using FIFO so the oldest stock is easiest to reach
• Set reorder points for critical ingredients and packaging
• Keep safety stock for items that would seriously interrupt production
• Record every production batch against the materials used
• Log waste, test batches, and damaged stock as separate transactions
• Review seasonal demand before major buying periods
• Audit physical counts on a regular schedule

That routine is simple, but it touches the core problems makers face: running out unexpectedly, overbuying, losing traceability, and misunderstanding margins.

The real goal is confidence

Good inventory planning is not about becoming a warehouse manager. It is about being able to trust your numbers and protect your products.

When your inventory system is working, you can answer important questions without guessing. You know whether you can fulfill the next production run. You know which oil lot was used in a specific lotion batch. You know whether your holiday candle plan requires more jars, lids, and fragrance before the rush starts. You know whether waste is eating into profit.

For formulators, that confidence matters because product quality depends on material quality, and business stability depends on operational visibility. Inventory planning sits right in the middle.

If you make lotions, salves, soaps, or candles, the most useful next step is not to build a perfect system overnight. It is to make your current system a little more traceable, a little more proactive, and a little more connected to the way you actually formulate and produce.

That is where inventory planning stops feeling like admin and starts supporting the craft.