Thailand

Setting Up FEFO in a WMS That Works: Minimum Remaining Shelf Life (MRSL) per Customer, Quarantined Lots and the Exceptions You Need

FEFO ships the lot that expires first, but in a real warehouse that is not enough. Each customer sets a different minimum remaining shelf life, some lots are still waiting for QC, and some retailers refuse a lot older than the last one they received. This guide explains how to set FEFO + MRSL rules in a WMS, from receiving to lot allocation, with Japan's one-third rule as an example.

Setting up FEFO in a WMS: allocate lots by expiry date together with each customer's minimum remaining shelf life (MRSL)

Short answer: FEFO (First Expired, First Out) ships the lot that expires soonest. A WMS that works in practice checks three more conditions before it picks a lot: 1) is the lot available to ship (not on QC hold or damaged), 2) does its remaining shelf life meet this customer's minimum (Minimum Remaining Shelf Life, MRSL), and 3) is it no older than the last lot this customer received (when the customer requires it). Among the lots that pass, the system picks the one that expires first.

For the basics of what a WMS does, see What Is a Warehouse Management System (WMS)? This article goes one step further: how to set FEFO rules so customers do not reject deliveries and expired stock does not pile up.

1/3
Japan's delivery rule: food must reach the retailer within the first third of its shelf life
1/2
The deadline Japan's Ministry of Agriculture (MAFF) is pushing for, to cut food loss
(17)
GS1 identifier for expiration date in a barcode; (15) is best before, (10) is the lot
3
Checks before FEFO picks a lot: status, remaining shelf life and date order

Why is FEFO alone not enough in a real warehouse?

“First expired, first out” works when every customer accepts the same stock. Real operations are not like that. Food, beverage, cosmetics and pharmaceutical warehouses run into four common problems:

  • The customer rejects the delivery because the remaining shelf life is shorter than the contract allows, even though the system picked correctly by FEFO
  • A lot still waiting for quality control (QC) or under recall is picked and shipped, because the system only looks at the expiry date
  • A lot with an earlier expiry date than the last one the customer received is shipped; some retailers refuse it because dates on their shelf would go backwards
  • Items carry both a production date and an expiry date, but only one is recorded, so remaining shelf life is calculated wrongly

Rule of thumb: FEFO tells you which lot to pick first; MRSL tells you which lots this customer can receive. A good system uses both at once.

What is minimum remaining shelf life (MRSL)?

MRSL (Minimum Remaining Shelf Life) is the number of days, or the share of total shelf life, that must remain on the day the goods reach the customer, for example “at least 120 days” or “at least two-thirds of total shelf life”. Each receiver tends to set a different figure: retailers are usually the strictest, wholesalers and food service more relaxed, and exports may follow the destination's own rules.

The clearest example comes from Japan's one-third rule: makers or wholesalers must deliver to retailers within the first third of a product's shelf life, and retailers sell it only for the first two-thirds (World Economic Forum). Japan's Ministry of Agriculture, Forestry and Fisheries (MAFF) illustrates a product with a six-month shelf life: the one-third rule gives two months to deliver, and MAFF is promoting a relaxed one-half deadline of three months to reduce stock that misses the window and is thrown away (MAFF). Japan's Consumer Affairs Agency describes the same change as a way to reduce unshipped disposal by manufacturers (Consumer Affairs Agency).

Same shelf life, different acceptance per customer. The system must know the receiver's rule before choosing a lot.
Rule typeExampleSuits
Minimum daysAt least 90 days remaining on deliveryItems whose lots all have similar shelf lives
Share of total shelf lifeAt least 2/3 remaining (one-third rule style)Ranges where shelf lives differ widely
Per customer or channelRetail 2/3 · wholesale 1/2 · food service 30 daysManufacturers and 3PLs shipping to many channels
No date reversalNo older than the latest lot this customer receivedRetailers that arrange shelves by date

Date reversal is not a small issue. MAFF lists the retail practice of refusing goods with an earlier best-before date than goods already received as one cause of business food loss (MAFF). If the warehouse does not keep a record of which lot went to which customer, it cannot check this condition at all.

How does a WMS allocate lots with FEFO + MRSL?

The system removes lots that cannot be shipped first, then sorts the rest by FEFO.
  1. Filter status: keep only available lots

    Exclude lots on QC hold, under recall, damaged or already expired. They must never be allocated, even if they expire soonest.

  2. Calculate remaining shelf life on arrival

    Use the delivery date, not the pick date. If transport takes three days, subtract three more days. Long-haul and export orders need a larger margin.

  3. Compare with the receiver's MRSL

    Take the rule from the customer or destination master data, or the item's default if none is set. A lot that falls short is not offered to this customer, but can still go to a customer with a lower threshold.

  4. Check date reversal (if required)

    Compare with the expiry of the latest lot shipped to this customer. The system needs lot-level shipment history.

  5. Sort by FEFO and create the pick list

    From the lots that pass, take the earliest expiry first. If the customer wants a single lot per line, look for one lot with enough quantity before splitting. Pickers scan the lot on a handheld, and a wrong lot triggers an alert immediately.

Set the rules once in master data (item + customer) and let the system decide every order. That beats relying on a supervisor to remember each customer's conditions, because memory is where mistakes happen most.

Get expiry dates right at receiving: read them from GS1 barcodes

FEFO is only as accurate as the expiry dates captured at receiving. When staff type dates from the label, mistakes are easy: day and month swapped, or the Thai Buddhist year entered instead of the Gregorian year. Scanning a GS1-128 or GS1 DataMatrix barcode is more reliable, because each data field carries its own prefix called an Application Identifier (GS1 UK).

One scan captures the product code, expiry date and lot number. No dates typed by hand.
AIMeaningFormat
(01)GTIN, global product code14 digits
(10)Batch or lot numberUp to 20 characters
(11)Production dateYYMMDD
(15)Best before dateYYMMDD
(17)Expiration (use by) dateYYMMDD

For packaged food sold in Thailand, labelling falls under Ministry of Public Health Notification No. 367 (B.E. 2557 / 2014), which sets how the date is shown on the label. A WMS should therefore store both an expiry date and a best-before date, and define per item which one drives FEFO. If goods arrive without a barcode that carries the date, print an internal label at receiving and use it throughout the warehouse. For 1D and 2D barcode basics, see What Is a Barcode?

Stock statuses you must keep separate

StatusMeaningCan it be allocated?
AvailablePassed receiving checks, normal shelf lifeYes, by FEFO + MRSL
QC holdWaiting for lab results or import documentsNo, until released
Near expiryRemaining life below the item's alert thresholdOnly to customers with a low enough MRSL, or with approval
Expired / blockedPast expiry or under recallNo; move to disposal or return area
Damaged / claimDamaged packaging or waiting for a supplier claimNo

The key is that status is tied to the actual lot and location in the warehouse, not a mark in a spreadsheet, and that every status change records who changed it and when. That history is what GMP and ISO auditors ask for.

Exceptions that need an approval step

Good rules leave a way out for special cases, but that way out must be approved and recorded, not decided on the floor. Common cases:

Customer accepts a shorter shelf life

For example in exchange for a discount, or for immediate use. The system should let an authorised person approve per order and record the reason.

Clearing near-expiry stock

Send a near-expiry report to sales in advance so they can run a promotion or find a channel with a lower threshold before the stock becomes waste.

Single lot per order line

Some customers want one lot per line to simplify recalls. The system must look for a lot with enough quantity instead of splitting.

Export orders

The destination country or importer may require more remaining life than the domestic market, plus time for sea freight.

KPIs to track after setting FEFO rules

KPIHow to calculateWhat it tells you
Value of expired write-offsValue written off due to expiry, per monthWhether FEFO and stock clearance are working
Rejections due to shelf lifeOrders or lines refused because shelf life fell shortWhether customer MRSL data is complete and correct
Average remaining life at shipmentAverage % of shelf life remaining on shipped goodsHow fresh customers' goods are, and whether stock sits too long
Value of near-expiry stockValue of stock below the alert thresholdThe risk of write-offs in the near future

How does ci.Himalayas/GLOBAL help?

ci.Himalayas/GLOBAL, the cloud WMS implemented and supported by C.NET (Thailand), has more than 210 standard functions, including lot and expiry control that applies directly here.

  • Lot control with expiry dates, and allocation by FIFO or FEFO
  • Blocks shipments whose expiry date does not meet each receiver's conditions
  • Near-expiry alerts, plus lists of expired stock and stock past its ship-by limit
  • Lot scanning on handhelds running both Windows Mobile and Android, with an immediate alert on a wrong lot
  • Works in cold storage, with movement history that shows which lot went to whom

To see how the system can be used as standard or customised item by item, read ci.Himalayas/GLOBAL: standard or customised.

FAQ: FEFO and minimum remaining shelf life

What is FEFO?

FEFO stands for First Expired, First Out: the lot that expires soonest is shipped first, regardless of when it was received. It suits food, beverages, pharmaceuticals and cosmetics with expiry dates.

What is MRSL?

Minimum Remaining Shelf Life is the shelf life that must remain when goods reach the customer. It can be set in days, such as at least 90 days, or as a share, such as at least two-thirds of total shelf life.

What is Japan's one-third rule?

A Japanese food industry practice where makers or wholesalers must deliver to retailers within the first third of shelf life, and retailers sell only for the first two-thirds. Japan's Ministry of Agriculture is promoting a relaxed one-half deadline to reduce food loss.

Should FEFO use the expiry date or the best-before date?

It depends on the item and what is printed on the label. The system should store both and define per item which one to use. In GS1 barcodes, expiration date is AI (17) and best before is AI (15).

Will a lot waiting for QC be picked?

It should not. The system must keep QC hold separate from available stock and never allocate that lot until it is released, even if it expires first.

Can Excel handle FEFO + MRSL?

In a small warehouse with few items and customers, yes. With hundreds of lots and many customers with different rules, checking every order by hand becomes error-prone. A WMS selects the lot and enforces a scan at picking.

Sources

Updated November 2026 by the C NET (Thailand) team · MRSL figures in the tables are examples; actual rules depend on each customer's contract.

Talk to our WMS specialists

Tell us what is happening in your warehouse and we will recommend a system that fits your size and budget, free of charge.

LINE QR code

Scan to add us on LINE