ERPNext Auto Reorder: How to Stop Stockouts Before They Happen

Running out of stock at the wrong moment is one of the most avoidable problems in business, and also one of the most common. A customer places an order, and only then does someone notice the shelf is empty. Or a production line stalls because a raw material ran out mid-week. In most cases, nobody was ignoring the problem. They just weren't watching that specific item closely enough, because nobody can watch hundreds of items closely enough, all the time, by hand.

This is exactly the kind of problem ERPNext's Auto Reorder feature was built to solve. Instead of relying on someone to notice low stock, the system watches it for you and takes the first step automatically.

What Is the Auto Reorder Feature?

At its core, Auto Reorder is simple: when an item's stock level drops below a predefined Reorder Level, ERPNext automatically generates a Material Request for that item. Nobody has to check a spreadsheet or remember to place an order. The system does the noticing.

Once that Material Request is created, the Purchase Manager is notified by email, so the right person knows immediately that action is needed. If the item needs to come from another warehouse instead of a new purchase, ERPNext can handle that too, since the request type is configurable per item.

In short: the system replaces "I hope someone catches this in time" with a rule that runs quietly in the background.

Who Actually Benefits From This Feature?

Auto Reorder isn't a niche feature for one type of business. It applies anywhere stock levels matter:

• Retailers, especially businesses like pharmacies tracking dozens or hundreds of SKUs, where a single missed item means a lost sale or an unhappy customer.
• Distributors and wholesalers, who need consistent replenishment across many products without manually reviewing stock every day.
• Manufacturers, who depend on raw materials, sub-assemblies, and components arriving on time, since a single missing part can stall an entire production run.

Across all of these, the underlying benefit is the same: fewer stockouts, less firefighting, and better use of working capital, since you're not over-ordering out of caution or under-ordering out of oversight.

Why This Matters in Real Business Operations

Consider a furniture manufacturer assembling chairs on a fixed production schedule, using a small, inexpensive bolt as one of hundreds of components tracked across the workshop.

Without Auto Reorder:

• The bolt's stock runs low without anyone noticing
• Assembly halts mid-production once the workshop runs out
• The supplier takes a few days to deliver a fresh batch
• Every order scheduled behind it that week gets pushed back
• The part itself costs very little, but the downtime, idle labor, and missed delivery date carry a real cost

With Auto Reorder in place:

• Stock is tracked automatically against a calculated Reorder Level
• Once stock hits that level, ERPNext raises a Material Request on its own
• The Purchase Manager is notified immediately
• A new batch is ordered before existing stock runs out, based on lead time and safety stock
• Production continues without interruption, and no one had to manually catch the shortfall

The value here isn't about the cost of the bolt. It's about removing the operational risk of a small oversight causing a much larger disruption.

The Formulas Behind Reorder Calculations

This is where Auto Reorder stops being a vague idea and becomes something you can actually calculate. Here are the formulas, along with a worked example using round numbers for clarity.

Average Daily Demand

This is the starting point for every other calculation. It tells you, on average, how many units of an item are used or sold per working day.

Average Daily Demand = Total Demand ÷ Number of Working Days

Example: If total demand is 300 pcs over 250 working days:

Average Daily Demand = 300 ÷ 250 = 1.2 pcs/day

Lead Time Demand

Lead time is how long it takes for a new order to actually arrive after you place it. Lead Time Demand tells you how much stock you'll use up while you're waiting for that new order to come in.

Lead Time Demand = Average Daily Demand × Lead Time

Example: With a 5-day lead time:

Lead Time Demand = 1.2 pcs/day × 5 days = 6 pcs

Safety Stock

No supply chain is perfectly predictable. Safety Stock is the buffer you keep on hand to absorb unexpected delays or demand spikes without running out.

Safety Stock = Average Daily Demand × Safety Days

Example: With 2 safety days:

Safety Stock = 1.2 pcs/day × 2 days = 2.4, rounded up to 3 pcs

How is "Safety Days" decided? It isn't a fixed number, it depends on a few practical factors:

• Possible fluctuation in lead time (does your supplier sometimes run late?)
• Stockout cost (how expensive is it if you run out?)
• Working capital constraints (how much cash can you afford to tie up in extra stock?)

A business with an unreliable supplier or a high cost of stocking out will typically set more safety days than one with a dependable, fast supply chain.

Reorder Level

This is the number that actually triggers the automation. Once stock drops to this level, ERPNext creates a Material Request.

Reorder Level = Lead Time Demand + Safety Stock

Example:

Reorder Level = 6 pcs + 3 pcs = 9 pcs

Reorder Quantity

This tells you how much to order each time a reorder is triggered, based on how often you plan to reorder.

Reorder Qty = Average Daily Demand × Reorder Cycle

The Reorder Cycle is simply the regular interval between two reorders. It isn't calculated with a formula, it's a decision based on:

• Stocking capacity (how much physical space you have)
• Stock value (how much cash is tied up per unit)
• Shelf life (perishable or time-sensitive items need shorter cycles)
• Working capital constraints

Example: With a 10-day reorder cycle:

Reorder Qty = 1.2 pcs/day × 10 days = 60 pcs

Once you know your Reorder Level and Reorder Qty, ERPNext takes over. You don't need to run these calculations every day, you calculate them once per item, enter them into the system, and let the automation do the watching.

Where This Lives in ERPNext

In ERPNext, Reorder Level and Reorder Qty are set directly on the Item master. If the same item behaves differently across locations, you can also set warehouse-specific reorder levels and quantities, rather than using one number for the entire business.

Behind the scenes, the system compares the item's projected quantity against the reorder level to decide whether a request needs to be raised. If the projected quantity is still above the reorder level, nothing happens. If it drops below, the automation kicks in.

Rather than walk through every setup step here, it's worth going straight to the source. ERPNext's official documentation covers this in detail, including where to configure warehouse-wise settings: Auto Creation of Material Request.

How the System Runs Automatically

Before going further, it helps to know what a Material Request actually is. In ERPNext, a Material Request is simply an internal document that says "we need this item." It doesn't commit you to a purchase or a transfer on its own, it's a flag that something needs to happen next, whether that's buying, transferring, or manufacturing.

Here's how the automation plays out in practice:

• The feature is enabled from Stock > Setup > Stock Settings.
• When an item's projected quantity drops below its reorder level, ERPNext creates a separate Material Request for that specific item.
• The user with the Purchase Manager role receives an email alert about the new request.
• If the automatic creation fails for any reason (a common one being a fiscal year configuration issue), the Purchase Manager is notified about the error instead, so it doesn't fail silently.

From there, the Material Request doesn't just sit there. Depending on what the item needs, it can be converted into:

• A Purchase Order, if the item needs to be bought from a supplier
• A Supplier Quotation, if you want quotes before committing to a purchase
• A Stock Entry, if the item just needs to be transferred from another warehouse

The automation handles the noticing and the first step. The follow-through, deciding which supplier, confirming pricing, approving the order, still stays in human hands, which is exactly where that judgment belongs.

Bringing It All Together

Stockouts rarely happen because a business doesn't care about inventory. They happen because nobody can watch every item, every day, without missing something eventually. ERPNext's Auto Reorder feature closes that gap by turning a manual habit into a system rule: set your Reorder Level and Reorder Qty once, based on real demand and lead time data, and let ERPNext flag the moment action is needed.

If your current process for reordering still depends on someone remembering to check, it might be worth setting this up properly. Want to see this feature explained visually, with the formulas walked through step by step? Watch the full breakdown here.