Popular products keep running out while other items sit untouched? Use a simple reorder calculation and a weekly stock review to make better purchasing decisions.
A customer asks for the pipe fitting you sell almost every day. You check the shelf, then the storeroom. Nothing left. Meanwhile, several boxes of another fitting have barely moved in weeks.
Buying more stock sounds like the answer, but your money is already sitting on those shelves.
To prevent stockouts, you need to know which products need attention, how long replenishment takes and what you have already ordered. You also need a separate plan for items that are moving slowly.
Here is a practical way to begin, whether you manage a hardware shop in Chitwan, an accessories store or a small wholesale business.
Start with the products that cause the most disruption
Counting and sorting fittings before updating stock records.
Choose ten to twenty products for your first review. Include items customers frequently request and products whose absence can hold up a larger order.
For each item, record its code, unit, usable quantity, recent sales, supplier delivery time and outstanding purchase orders. Keep damaged or unusable goods separate. A shelf may contain ten units, but that does not help if four cannot be sold.
Record sales and purchases in consistent units. If you buy a carton containing twelve pieces and sell individual pieces, make that conversion explicit. Otherwise, a tidy spreadsheet can still give you the wrong stock balance.
A practical purchasing review begins with quantities, commitments and delivery dates.
Set a reorder point before the shelf becomes empty
A simple starting rule is:
Reorder point = expected demand during replenishment lead time + safety stock
Lead time should reflect how long it takes until goods are ready to sell, including relevant delivery and receiving delays. Safety stock is a buffer for uncertainty. Its size should reflect your actual demand, supplier reliability and the consequences of running out.
A hypothetical Chitwan hardware-shop example
Assume a shop sells an average of eight fittings per trading day. Its supplier takes five trading days to replenish stock, and the owner chooses a twenty-piece buffer.
| Input |
Quantity |
| Average demand per trading day |
8 pieces |
| Replenishment lead time |
5 trading days |
| Expected demand during lead time |
40 pieces |
| Safety stock |
20 pieces |
| Starting reorder point |
Illustrative calculation only. The 60-piece trigger is not the quantity to order.
With no incoming orders or unusual commitments, sixty usable pieces is a signal to review replenishment. It is not an instruction to buy sixty pieces.
If each fitting costs NPR 150, purchasing another hundred pieces requires NPR 15,000 before any additional charges. Decide whether that quantity fits expected sales, supplier pack sizes and the cash available for other products.
These figures are illustrative. Average demand can hide busy periods, so review the rule when conditions change.
Check commitments and incoming stock before ordering
The shelf count tells only part of the story. Some goods may already be promised to customers, while a supplier delivery may be on its way.
Before approving a purchase, ask:
- How many usable units are here now?
- How many are committed to confirmed orders?
- What incoming quantity is confirmed, and when will it arrive?
- Is another branch holding stock that could be transferred?
Inventory systems can combine supply and demand into projected stock. ERPNext's projected-quantity documentation explains how actual stock, incoming supply and reservations contribute to its calculation. Exact definitions vary between systems.
Timing still matters. A delivery due next week cannot fulfil an order promised tomorrow. Check dates as well as quantities, and avoid counting the same demand twice.
Understand the timing behind a stock alert
Use this separate hypothetical example to see why a single total can be misleading. There are 70 usable pieces on the shelf, but 30 are already committed to customers. That leaves 40 uncommitted pieces. A confirmed 50-piece delivery arrives before sales on Day 4. Additional demand is eight pieces per trading day; it excludes the 30 pieces already committed.
A delivery can be confirmed and still arrive too late.
| Checkpoint |
Calculation |
Uncommitted balance |
| Today |
70 usable − 30 committed |
40 pieces |
| End of Day 3 |
40 − (8 × 3) |
16 pieces (buffer breach) |
| End of Day 4 |
16 + 50 received − 8 demand |
58 pieces |
The day-by-day check reveals a buffer breach on Day 3 even though the Day 4 balance looks healthy. Confirm an earlier receipt, consider a transfer or review another supply option. These numbers show a planning warning, not a guaranteed stockout.
Turn the numbers into a purchasing decision
Replenishment decision tree connects stock timing to approval and monitoring.
This is a review rule, not automatic permission to buy. Count confirmed commitments only once. If a demand forecast already includes confirmed orders, do not subtract those orders again. A supplier promise must retain its date and reliability assumptions.
| What the check shows |
Suggested action |
Control before approval |
| Stock falls below buffer before delivery |
Review transfer, earlier delivery or purchase |
Check arrival date, quantity and budget |
| Stock stays above buffer |
Monitor; avoid duplicating the incoming order |
Check for changed customer demand |
| Slow movement with adequate stock |
Reduce or pause the next purchase |
Check seasonality and essential spares |
Keep the trigger separate from the order size. The earlier 60-piece reorder point signals attention; the quantity to order still depends on future demand, confirmed supply, supplier pack sizes and cash available.
Give slow-moving stock a separate weekly review
A low-stock list helps you decide what may need replenishing. A slow-moving list helps you decide what may need less purchasing.
Review when each item last sold, how much has sold recently and why you are holding it. Some products are seasonal. Others are essential spare parts that customers buy infrequently. A product with no recent sales is worth investigating, but it is not automatically worthless.
Consider reducing the next purchase, transferring stock, discussing supplier returns or testing a suitable promotion. Check the margin and any return conditions before acting.
For example, forty unsold items purchased at NPR 500 each represent NPR 20,000 in purchase cost held in stock. That is not necessarily a loss, and selling them will not necessarily recover the full amount. It is a useful signal to examine how that purchasing decision affects available cash.
Balance availability with a separate review of stock that is moving slowly.
Connect purchasing decisions to sales and accounts
Store and accounts colleagues review a purchasing decision.
Stock control works better when teams share the information behind the numbers.
Sales staff can record repeated requests for unavailable products. A customer enquiry should remain separate from a confirmed order, but a pattern of enquiries can reveal demand that sales history misses.
The accounts team can help the buyer check upcoming supplier payments and the purchasing budget. A low-stock alert tells you an item needs attention; it does not tell you that every proposed purchase is affordable.
For manufacturers, include confirmed production requirements when reviewing materials. Goods reserved for an upcoming job should not quietly appear available for another commitment. This is a useful integration requirement to evaluate when choosing or planning software.
Turn the review into a repeatable task
Assign one person to maintain replenishment settings and another to approve purchases where your team size allows. Keep a short action list with the item, decision, owner and deadline.
Each week, review:
- Products below their replenishment trigger.
- Late or uncertain supplier deliveries.
- Important stock-count differences.
- Slow-moving items needing a decision.
- Changes in sales patterns or supplier lead times.
Start with a manageable group of products. Expand once the records are reliable and the review produces clear purchasing decisions.