Menu

Free assessmentPortuguês

Custom system

Expiration date tracking (PVPS)

ClientIn production

An expiration date tracking system for a regional supermarket, with batches, alerts, and the first-expired, first-out rule. Approved by IT and loss prevention, it cut losses by 30%.

What I built
Batch expiration tracking with mobile barcode scanning, alerts and reports.
Outcome and current status
In use at a regional supermarket. Its loss-prevention team reported a 30% reduction in losses; the source and date are recorded below.

See the project

Dashboard of the Fonseca Supermercados expiry system: the head office priorities, the batches expiring in 7, 15, 30 and 60 days and the most urgent ones, with the products hidden
System screenshot, with the products hidden

Context

In a supermarket, an expired product on the shelf is a loss twice over: the loss itself, and the shopper’s trust. This system was built for a regional supermarket to control the shelf life of what it sells.

Challenge

Knowing, every day, what expires first and where it is, without relying on anyone’s memory — with a system that fits the store’s routine: barcode scanning, use on a phone, and reporting for management.

Solution

  • First expired, first out. Each entry becomes a batch with its own date, and the system orders removal by expiration date, not by arrival order.
  • Alerts before the problem happens, with an audit trail of who registered and cleared each batch.
  • Barcode scanning for EAN-13 and GS1 directly in the phone’s browser, and installation as an app, with no app store.
  • Spreadsheet import and Excel and PDF reports for management.

Result

The system is in production at the market, approved by the IT team and by the loss prevention inspector. According to loss prevention, losses fell by 30% with the app. The first version was built between April 21 and 23, 2026, and the second, between June 21 and 23.

Numbers

Fewer losses with the system
30%
Source: Measured by the supermarket's loss prevention team and reported by its inspector · measured on Nov 1, 2026

Contact

Want something like Expiration date tracking (PVPS)?

Tell me what you need, however you can put it. I reply personally, and the written assessment is free.

Taking new projects

Response time: 1 business day