Supplement Inventory Management: Lots, Expiry, and Production Under Control
Supplement inventory management software with lot and expiry traceability, FEFO shipping, BOM production, and reorder points on raw actives. Recall-ready in minutes.
On this page
- Why supplement inventory is a compliance problem, not just a stock problem
- Lot and expiration-date traceability: what 21 CFR Part 111 actually expects
- Stock states from receiving to release: quarantine, tested, in-process, finished goods
- Building a bill of materials for capsules, blends, and bottled SKUs
- Reorder points on raw actives when lead times run 4 to 8 weeks
- FEFO: shipping the oldest lots first and cutting expiry write-offs
- Recall readiness: tracing a lot from raw material to customer order
- How Shelvr runs it offline on the production floor
Supplement inventory management software has to answer a question that generic stock tools were never built for: which raw-material lot went into which finished bottle, and where did that bottle ship? For a supplement or nutraceutical brand, inventory is not just about not running out of stock. It is the paper trail that keeps you compliant with FDA 21 CFR Part 111, the thing that lets you settle a recall in an afternoon instead of a week, and the difference between shipping fresh product and eating a pallet of expired capsules. This guide walks through how nutraceutical inventory management actually works on a production floor — lots, expiry, quarantine states, bills of materials, reorder points on botanical actives, and FEFO shipping — and where Shelvr's batch and expiry engine fits.
Why supplement inventory is a compliance problem, not just a stock problem
Most inventory advice treats a SKU as an anonymous, interchangeable unit: you have 400 of something, you sell one, now you have 399. Supplements break that model. Every incoming lot of a botanical extract, every drum of microcrystalline cellulose, and every finished 60-count bottle carries a lot number and an expiration or best-by date. Two bottles of the same SKU are not interchangeable if one expires in three months and the other in two years, and they are legally distinct if one traces back to a raw-material lot that later fails testing.
That is why lot traceability for supplements is the foundation everything else sits on. Part 111 — the cGMP rule for dietary supplements — expects you to prove component-to-finished-good linkage and to keep those records for at least one year past the product's shelf-life date, or two years from the last distribution of the batch, whichever is longer. If your inventory system cannot tell you what lot went into what, you do not have an inventory problem. You have a compliance gap.
Lot and expiration-date traceability: what 21 CFR Part 111 actually expects
Two documents govern a compliant run. The Master Manufacturing Record (MMR) is the recipe: one per unique formulation and batch size, specifying every component and every step. The Batch Production Record (BPR) is what actually happened during a specific run — and crucially, it records the specific component lot numbers that were weighed and blended into that batch. The BPR is where traceability is won or lost.
The mechanics are simple to state and easy to botch in practice: capture the lot number and expiry the moment material is received, carry that lot linkage through the production step, and attach the finished lot to the outbound order. Miss any one of those handoffs and the chain breaks. Shelvr's batch and expiry tracking is built to capture lot and expiry at receiving on raw actives and excipients, then carry that linkage through assembly so every finished bottle knows which component lots it consumed.
Record retention under 21 CFR 111.605 runs to one year past the product's shelf-life date, or two years from the date the last batch was distributed — whichever is longer. That is not a period you want to reconstruct from shoeboxes of paper batch records.
Stock states from receiving to release: quarantine, tested, in-process, finished goods
A single "on hand" number cannot describe supplement inventory, because material moves through distinct legal states before it is ever usable. A realistic flow looks like this:
- Received / quarantine. Raw material arrives and is held. It physically exists in your building but cannot be weighed into anything.
- Testing. COA review plus identity and assay testing under USP methods — heavy metals, microbiology, and pesticide or residual-solvent screens where relevant. This adds 5 to 10 business days per lot.
- Released / available. The lot passes and is cleared to the floor.
- In-process (WIP). Material is dispensed, blended, and encapsulated but not yet a finished, released SKU.
- Finished goods. Bottled, sealed, labeled, and released for sale.
If your system lumps quarantined and released material into one bucket, someone will eventually weigh untested powder into a batch. Tracking these as separate states — and separate stock — is what keeps a promising lot from becoming a deviation report.
| Stock state | Usable in a batch? | Sellable? | Typical dwell |
|---|---|---|---|
| Received / quarantine | No | No | 1–2 days |
| Testing (identity + assay) | No | No | 5–10 days |
| Released / available | Yes | No | Until dispensed |
| In-process (WIP) | — | No | Run length |
| Finished goods | — | Yes | Until shipped |
Building a bill of materials for capsules, blends, and bottled SKUs
A finished bottle is an assembly, and the bill of materials is where its true cost and its lot linkage live. For a single encapsulated SKU, the BOM lists:
- Each active — the label-claim ingredients (vitamins, minerals, botanical extracts, amino acids like L-theanine, branded ingredients) — by weight in grams.
- Each excipient or inactive — fillers such as microcrystalline cellulose or rice flour, flow agents, and lubricants like magnesium stearate, added last in the blend for flowability.
- One empty capsule shell of the right size (say, size 0) multiplied by the capsule count.
- The bottle, cap, desiccant, cotton, and label — one of each per unit.
Serving size and servings per container drive how many capsules a bottle consumes: a 60-count bottle at two capsules per serving is 30 servings, and the BOM must consume 60 capsules' worth of blend per unit. With Shelvr's BOM and production feature, recording a production run and assembling the finished good auto-deducts every component — weighed actives, excipients, shells, bottles, caps, and labels — from stock, and stamps the finished lot with the component lots it drew from.
Yields are never 1:1. Manufacturers deliberately add overage — extra active — so the product still meets label claim at end of shelf life, because actives degrade with time, heat, humidity, and light. Add to that blending dust, encapsulation setup loss, line clears, and QC retention samples pulled from every lot. Build expected process loss into your BOM or your raw-active counts will drift.
Reorder points on raw actives when lead times run 4 to 8 weeks
Running out of a botanical active does not mean a quick reorder. Extracts, branded ingredients, and specialty amino-acid forms carry long, variable lead times driven by harvest cycles, export regulations, and global logistics — commonly 4 to 8 weeks. Then identity and COA testing adds another 5 to 10 business days before the material can even be released to the floor. Your reorder point for raw ingredients has to include that QC release time, or you will "have stock" that is legally untouchable.
The formula is standard, but the inputs are what matter here:
reorder point = (avg daily usage × total replenishment lead time) + safety stock
Total replenishment lead time means supplier lead time plus QC release time. Keep safety stock on your high-velocity actives, and pre-qualify a secondary supplier for anything critical so a single failed harvest does not stop your line. Our deep-dive on the reorder point and safety stock formula walks through sizing that buffer. Shelvr's low-stock alerts and reorder points run this per raw active, so a botanical with an eight-week lead time trips its alert long before you are actually short.
MOQs on raw actives are often large, which ties up cash and creates its own expiry exposure — a huge minimum buy of a two-year-shelf-life extract can outlast its own best-by date. Balance reorder quantity against shelf life, not just against price breaks.
FEFO: shipping the oldest lots first and cutting expiry write-offs
Because every bottle carries a printed expiration date and every active loses potency over time, the correct rotation is not FIFO — it is FEFO, First Expired, First Out. You ship the lot expiring soonest first, regardless of when it arrived, because a lot received later can easily expire sooner. This is the single biggest lever on waste in the whole operation.
Expired raw actives and finished bottles are the largest source of shrinkage in most supplement brands. FEFO is the discipline that turns "we'll deal with it at year-end" into product that leaves the building before it can go short-dated.
FEFO expiry tracking is Shelvr's hero feature for this vertical. The batch and expiry engine surfaces the oldest-expiring lot first at pick and pack, so warehouse and 3PL staff physically ship the right lot without checking a spreadsheet. That directly cuts expired-product write-offs and the short-dated complaints that flow back from retail and Amazon returns.
Recall readiness: tracing a lot from raw material to customer order
Here is the payoff for everything above. Suppose a supplier notifies you that a raw-material lot of an active failed a heavy-metals retest. You need to answer, ideally the same day: which finished batches consumed that component lot, and which customer and retailer orders shipped those finished lots?
That is a backward-and-forward trace — component lot → BPR → finished lot → shipment — and it is only possible if the lot number was captured at receiving, carried through the BOM and production step, and attached to the outbound order. When those three handoffs are intact, a recall is a query, not an archaeology dig. This is the same discipline any regulated formulator needs; brands crossing over from personal care will recognize it from our guide to skincare brand inventory management. DTC and Shopify sales plus 3PL fulfillment make FEFO enforcement at pick and pack essential, because that is where lot-to-order mapping is either preserved or lost.
How Shelvr runs it offline on the production floor
Weighing, blending, and packing happen in warehouses and production rooms where the signal is terrible. A traceability system that needs a live connection to log a lot number is a system that gets bypassed with a paper note "to enter later" — which is exactly how lot linkage breaks. Shelvr is offline-first: you can scan a barcode, receive a lot, record a production run, and count stock with no signal at all, and it syncs across web, iOS, and Android the moment you are back online.
Put together, that is the whole loop for a supplement brand: capture lot and expiry at receiving, deduct components through a BOM at production, enforce FEFO at ship, trace any lot end-to-end for recalls, and reorder raw actives before long botanical lead times bite — all of it usable on the floor without a connection. You can start free and explore it at web.shelvr.app, and see plan details on the pricing page when you are ready to turn on production and batch tracking for your whole catalog.
Run your inventory in one app
Track stock, orders, and production across web, iOS, and Android — free to start.
