Stock Transfer Between Stores Near Expiry: When It Pays
Same item sells at one branch and expires at the other. Work out when moving near-expiry stock between stores pays and when a markdown is cheaper.
ShelfLifePro Editorial Team
Inventory management insights for retail and pharmacy
The same batch, two different fates
Picture a shop owner with two grocery stores on opposite sides of town. At the main branch, one brand of flavoured yoghurt sells out every week. At the second branch, which sits near an office cluster that empties out on weekends, the same yoghurt stays on the shelf until someone pulls it into the expiry bin.
Both stores ordered the same item from the same distributor on the same day. One branch sold it and the other had to throw it away. Nobody noticed until the evening reconciliation, and by then all that was left to do was write it off.
If you run more than one store, you've probably seen this happen. The product isn't the problem. It's sitting in the wrong store.
Why one branch sells it and the other doesn't
Branches drift apart. Each one has its own neighbourhood, footfall and customers. One store gets families stocking up on Sunday, and the other gets students buying single packs. How fast an item sells at one branch tells you very little about how it'll sell at the other.
Ordering doesn't drift with them, though. The owner sets one order pattern for both stores, or the distributor's salesman drops the same quantity at every branch, or the second store copies the first store's indent because that's easier. So the slow branch gets stock at the fast branch's pace.
Then there's what each manager can see. Each one sees only their own shelf. The manager at branch B doesn't know branch A ran out of that yoghurt on Tuesday and turned customers away. The manager at A doesn't know there are cartons about to expire at B. The information that would fix this already exists. It's just split across two sets of stock records that nobody reads side by side.
A transfer fixes that. You aren't creating demand. You're moving stock to the branch where customers already want it.
The transfer math: units saved vs cost of the trip
Moving stock costs something. Someone drives, someone packs, and someone counts it out and counts it back in. Chilled goods also need an icebox or an insulated bag. So the question is simple: is the stock you save worth more than the cost of moving it?
Three things decide it:
- Units that won't sell where they are. That's not the whole stock, just the extra the slow branch can't sell before expiry.
- Units the other branch can actually sell in the days left. Take its daily sales, multiply by the days remaining, then subtract what it already has on hand.
- The cost of the move. That's fuel or auto fare, staff time and any packaging.
Worked example: say branch B holds 40 packs of a biscuit with 10 days to expiry. B sells about 1.5 a day, so roughly 15 will sell and 25 won't. Branch A sells 4 a day and has 12 on hand, so over 10 days it can take about 28 more. Moving 25 packs fits. If each pack cost you ₹30, the transfer saves ₹750 of stock that would have gone in the bin, plus your margin when it sells. If the trip costs ₹150 in fare and half an hour of a staffer's time, the transfer pays for itself several times over.
Say you've got 6 packs of a ₹20 item about to expire at B instead, and moving them means a separate ₹200 auto ride. That trip costs more than the stock is worth. Mark it down where it is.
Transfers get cheap when they go along on a trip someone's already making. Maybe a staffer goes between branches every morning with cash or bills, or your own vehicle does a regular loop. Then adding a crate costs almost nothing. Put transfers on that run instead of sending them on their own.
Not sure how much you're losing to expiry?
Run a free inventory waste audit, find your bleeding SKUs in 60 seconds. No sign-up required.
Run free auditWhen a markdown is the cheaper move
A markdown sells the stock where it already sits. There's no trip, no packing and no chance of miscounting. You give up some margin, but the stock still sells. A transfer wins when the other branch can sell at full price. A markdown wins when it can't, or when the trip would cost more than the discount.
Pick a markdown over a transfer when:
- The quantity is small and nobody is already travelling between branches.
- The other branch is already well stocked on the same item.
- The product is fragile or chilled, so extra handling risks damage.
- There isn't enough time left. By the time it reaches the other shelf and gets put out, it'll be too late to sell.
Often the answer is both. Move most of it to the fast branch and mark down the few packs left at the slow one. Our guide to dynamic markdown pricing for near-expiry products covers how to set the discount, and how supermarkets manage near-expiry products in India covers the other ways to clear it.
A one-page transfer checklist
When stock moves between branches, it usually goes wrong at the handover. Things get sent but not recorded, received but not counted, or put on the shelf behind newer stock. Before each move, the sending branch should check:
- Batch and expiry written on the transfer slip, so the receiving branch knows it has to go to the front.
- Count sent written down, and the receiving branch confirms the count the same day.
- Stock records updated at both ends. Take it out of B and add it to A. If only one side does it, both stores' records are wrong.
- Chilled items in an insulated box, with travel time kept short.
- Paperwork checked with your CA. Ask what a branch-to-branch movement needs, especially if your stores are in different states.
- Front-facing at the receiving end. If it goes behind fresher stock, you've just moved the expiry problem to the other store.
Our post on keeping expiry in sync across multiple stores goes deeper on keeping records straight at both ends. If you're worried about stock disappearing between stores, read the one on stock transfer fraud prevention.
Catching it while there's still time to move it
Transfers only work if you spot the problem early. A pack with two days left isn't worth the trip. You need to see the batch heading for expiry while the other branch still has time to sell it.
That means comparing batch-wise expiry records across branches regularly, not just finding the stock on the shelf walk. You can do it by hand. Export each branch's stock with batch and expiry dates, paste the exports into one sheet and sort by expiry. Then look for items where one branch has too much and the other is running low. The expiry-tracking spreadsheet template gives you the columns to start with.
Be honest about where this breaks down. The spreadsheet works fine in a quiet week. In a busy week, with festival stock arriving and a staffer on leave, the comparison gets skipped. Those are the weeks the slow branch fills its expiry bin. A notebook can record a transfer, but it can't tell you every morning which transfers you should be making.
Where a daily scan helps
This is where ShelfSense by ShelfLifePro fits. Once a day, it reads your stock, batch, cost and expiry records. It flags batches that are at risk days ahead and shows the units that won't sell in time, the projected loss and a recommended markdown. The list is ranked by money at risk, and the arithmetic is shown for every call. You decide what to do with it. That might be a markdown at the slow branch, or a crate on tomorrow morning's run to the fast one. It recommends and a person approves. It never changes a price on its own.
You can start with a CSV export of your stock and expiry dates. If your branches run Tally, export to CSV today; a direct connection is available on request. ShelfSense's free audit reads one CSV export, no account needed. The Watch tier is free forever at 30 SKUs — a daily scan and a health report. Try it on your slow branch's export at /shelfsense and see which batches it flags first.
ShelfLifePro Editorial Team
The ShelfLifePro editorial team covers inventory management, expiry tracking, and waste reduction for pharmacies, supermarkets, and retail businesses worldwide.
One question, optional
What would stop you from trying ShelfLifePro?
See what batch-level tracking actually looks like
ShelfLifePro tracks expiry by batch, automates FEFO rotation, and sends markdown alerts before stock expires. 14-day free trial, no credit card required.
Prefer to talk it through? Book a 30-min call
Get the monthly expiry brief
One short email a month, only when there is something worth reading. FEFO tactics, markdown math, and stories from Indian retailers. No spam.
No spam. Unsubscribe in one click. Email only, no WhatsApp spam.
Get expiry tips on WhatsApp
Leave your number and we say hello on WhatsApp, then share expiry-tracking tips for Indian retail now and then — FEFO, markdowns, monsoon stock. No broadcast lists; reply STOP any time.