Skip to main content
Free 20-minute marketing audit
Limited spots available

Have a question?

We usually reply within 5 minutes.

WWhatsApp TTelegram

Expired Boxes Behind the Shelf: How to Set Up Batch and Expiry Date Tracking in Uzbekistan

Batch and expiry date tracking step by step: batch data at receiving, the FEFO rule, near-expiry alerts and write-off reports, plus the Uzbek rules that apply.

Expired Boxes Behind the Shelf: How to Set Up Batch and Expiry Date Tracking in Uzbekistan

It is stock-count day at your new warehouse in Tashkent. A storekeeper clears the bottom shelf, and three cartons of juice appear from behind it, pushed against the wall. They expired two months ago. Nobody remembers who received them or why they stayed there. The supplier was paid long ago.

Have you seen this in your own operation? It looks the same in a shop, a wholesale warehouse or a factory. The cause is rarely a careless employee; it is a missing process. This guide sets out a process that works in any industry: what to record at receiving, how to apply FEFO, when alerts should fire and how to write off expired stock properly. It also notes the Uzbek rules a foreign company should know.

This process is part of an ERP for a small business, but you can also launch it as a standalone module.

Batch, FEFO and FIFO: three terms, one logic

A batch (or lot) is a group of goods received or produced under the same conditions. Every unit in a batch shares one production date and one expiry date. For example, 40 packs of kefir delivered on one day form one batch. Another 40 packs delivered the next day form a different batch.

In basic stock records, a product sits on one line: "Kefir, 80 units". In batch tracking, it sits on two: "Kefir, batch of 18 November, 40 units" and "Kefir, batch of 19 November, 40 units". You can only control expiry dates in this form.

There are two picking rules:

  • FIFO (first in, first out): the stock that arrived first leaves first.
  • FEFO (first expired, first out): the stock that expires first leaves first.

Usually they give the same result. But a supplier sometimes ships an older batch after a newer one, so the latest delivery has the shorter shelf life. FIFO misses this; FEFO catches it. For any product with an expiry date, FEFO should be the default rule.

Receiving: the date is captured the moment goods arrive

Expiry tracking starts with the goods receipt. A date not recorded at receiving will not appear anywhere later.

Also read Profitable Company, Loss-Making Site: How to Run Project Accounting in an ERP in Uzbekistan Technology · 9 min

First, decide which products are tracked by batch. This is one flag in the item card: "batch and expiry required". Turn it on for food, beverages, cosmetics and household chemicals. Leave it off for tools and tableware.

Each receipt line should hold at least:

  • Batch number — Why it matters: The manufacturer's number or your own, to find stock in a recall
  • Production date — Why it matters: Taken from the packaging
  • Expiry date — Why it matters: An exact date. If the pack says "6 months", the system calculates it
  • Supplier — Why it matters: For returns and claims
  • Storage conditions — Why it matters: Room temperature, chilled or frozen

One more rule pays off at receiving: minimum remaining shelf life. This is the share of shelf life that must still be left for you to accept the goods. For example, you agree with the supplier that at least 70% of the shelf life must remain. The system blocks any batch that fails. Set the figure to match your sales velocity.

Uzbek law draws a line here too. Under Article 11 of the Law on Consumer Protection, medicines, medical devices, food and household chemicals must show a production date, an expiry date and storage conditions. Sellers may not accept or sell goods without a production or expiry date, or goods past their expiry date. Refusing to receive undated stock protects you.

The general flow of receipts, transfers and stock balances is covered in warehouse automation in Uzbekistan.

How FEFO works in the system and on the shelf

FEFO has to happen both in the software and on the shelf. Otherwise staff will still grab the nearest box.

When a sale or shipment is created, the system proposes the batch with the nearest expiry. If the storekeeper picks a different batch, they must enter a reason. These overrides stay in a log, and someone should review them once a week.

On the shelf, a simple rule applies: new batch to the back, old batch to the front. In a small shop, that is enough. In a large warehouse, each batch has its own location, and staff pick from the bin the system shows.

Hypothetical example. The warehouse holds two batches of cheese. The first arrived on 10 November and expires on 20 December. The second arrived on 15 November but expires on 5 December. Under FIFO, the older delivery would ship first and the second batch would expire on the shelf. FEFO ships the second batch first.

A scanner reduces errors further. If the barcode or marking code on the pack carries the batch and expiry date, nobody types anything by hand.

In a restaurant cold room, a chef moves older stock to the front

Alerts: when the signal should fire

Many systems set an alert with one number: "30 days left". For an item selling 50 units a day, that is plenty of time. For one selling two units a week, it is already too late.

Build alerts on two measures.

The first is the share of shelf life remaining. Split stock into three zones:

  • Green: more than half the shelf life left. No action.
  • Amber: 20% to 50% left. The item goes on a watch list.
  • Red: less than 20% left. Action every day.

Tune the thresholds by product group. Dairy and canned goods do not age at the same pace.

The second is whether the stock can sell in time. The formula is simple: stock on hand ÷ average daily sales = days to sell out. If that number is larger than the days left before expiry, part of the stock will be left over.

Worked example: you hold 300 packs of biscuits. On average, 8 packs sell per day. The batch expires in 25 days. In 25 days, about 200 packs will sell and 100 will remain. The system should flag those 100 packs today, not after they expire.

The list should reach a named person every morning: the storekeeper, the buyer or the store manager. A signal that belongs to nobody is soon ignored.

Industry specifics are covered separately. In manufacturing, raw material batches are linked to finished goods, as explained in ERP for dairy and meat processing. Serial numbers, drug marking and the cold chain are covered in pharmacy ERP in Uzbekistan.

What to do with stock in the amber and red zones

Each zone needs actions agreed in advance, ordered from cheapest to most expensive:

  1. Move it into view. Shift the item to the front row or next to the till. This costs nothing.
  2. Transfer to another outlet. Stock that moves slowly in one branch may sell quickly in another. Factor in the transport cost.
  3. Return or exchange with the supplier. Many supply contracts include a return or exchange clause. Suppliers usually take goods back only well before expiry, so this step belongs in the amber zone.
  4. Discount. Near-expiry stock goes on a separate shelf with a clear marker. Discounts work best in the red zone.
  5. Wholesale or bundle sale. To clear a large volume quickly.

More ways to clear slow stock are described in clearing dead stock. That guide uses a marketplace setting, but the logic carries over to physical retail.

One line is fixed: on the expiry date, the product leaves the sales floor. For digitally marked goods, the till now enforces this too. Under Presidential Resolution PQ-296 of 6 October 2025, from 1 March 2026 sales of such goods past their expiry date are automatically restricted through the Asl Belgisi system: when the code is scanned, the online till does not issue a receipt. Check which product groups fall under mandatory marking at aslbelgisi.uz, as the list is expanding in stages.

A supermarket manager stands beside a separate shelf of near-expiry products

Write-off report: how expired stock is closed out

A write-off report (in local practice, an "act") is a document confirming why, in what quantity and at what cost goods were removed from stock. Without it, goods simply "disappear". You then cannot tell shrinkage or theft apart from expiry.

The report should include:

  • the product, batch number and expiry date;
  • quantity and value at cost;
  • a reason code: expired, damaged, storage conditions breached;
  • a committee of at least two people, ideally including one who is not financially responsible for the stock;
  • photos and where the goods went next (destruction, recycling, return to supplier).

Until the report is approved, the stock balance should not change. Approval rights belong to a manager or the accountant, not the storekeeper. Destruction procedures and tax treatment depend on the type of goods, so confirm them with your local accountant.

At month end, summarise all write-offs by product, supplier and outlet. The cause often sits in purchasing: more stock was bought than sales velocity allows.

A typical scenario: losses found once a month

Hypothetical example. The owner of a neighbourhood grocery store collects expired goods by hand at the end of each month. Nobody keeps a list; the goods are simply thrown away. The owner considers the losses "minor".

Now record every written-off item on a report for one month. The picture changes. Most of the loss comes from three or four items, all bought in large batches from one supplier. The fix is to order those items more often in smaller batches and to check remaining shelf life at receiving.

The process matters more than the software; the software just enforces it daily.

Rollout: a 7-step checklist

  1. List the products with an expiry date and set the "batch required" flag in their item cards.
  2. Add batch, production date and expiry date fields to the goods receipt.
  3. Agree minimum remaining shelf life and return terms with suppliers in writing.
  4. Have the system propose the batch by FEFO on every sale and shipment.
  5. Set green, amber and red thresholds for each product group.
  6. Assign an action and an owner to each zone.
  7. Write off stock only with a report and review the results monthly.

Steps 1, 2 and 7 alone quickly show where money is leaking. If you have no ERP yet, you can start them in a plain spreadsheet: product, batch, expiry date, quantity and write-off reason.

Conclusion

Expired stock is a sign of a missing process, not a careless employee. Batch tracking shows when each box runs out. FEFO ships it on time. Two-measure alerts give you time to act. The write-off report makes losses visible and corrects the next purchase order. Start today: for the next month, record every written-off item with its batch and reason.

Frequently asked questions

Does every product need batch tracking?

No. Turn it on only for items with a limited shelf life or where traceability matters: food, beverages, cosmetics, household chemicals, medicines. For nails, tableware or tools, batch fields only slow people down.

What is the difference between FEFO and FIFO?

Under FIFO, the stock that arrived first leaves first. Under FEFO, the stock that expires first leaves first. A later delivery can carry a shorter shelf life, so FEFO is the safer rule for perishable goods.

How many days before expiry should an alert fire?

There is no single number. Look at two things: what share of the shelf life is left, and whether the stock can sell in time. If current sales velocity will not clear the stock before it expires, the alert should fire now.

Can expired goods be sold at a discount in Uzbekistan?

No. Article 11 of Uzbekistan's Law on Consumer Protection prohibits sellers from accepting or selling goods past their expiry date. For digitally marked goods, the till simply will not issue a receipt. Discounts apply only to stock that has not yet expired. Expired goods are written off with a formal report.

Setting up stock control for perishable goods in Uzbekistan?

We can review how batches are recorded at receiving, whether you have expiry alerts and how much stock is written off each month, and discuss which step is worth starting with.

Discuss your stock control →

Let's work out where to start

Free consultation with a DORA specialist

Message on Telegram

Let's discuss your project

Leave your number and a specialist will get in touch.

Send a request via Telegram

Your details are used only to contact you.