Lot sell-by and eat-by date alerts

The module reads the dates of the lots in stock and warns you in time, in three places. It also checks the validation of shipments.

The dates watched

They are Dolibarr’s own, under its own labels, in each user’s language:

For each lot, the module keeps the nearer of the two dates. A date disabled in the setup of the Product Lots module is ignored.

The home page widget

“Lots to watch (sell-by, eat-by dates)”: the lots in stock whose date falls within the chosen delay (30 days by default) or is already past, most urgent first. For each: the product, the lot, the type of date, the date and a badge — “Past for 3 d”, “Today”, “In 2 d”.

The full list

Under Products“Lots to watch (dates)”: the same selection, with filters — delay in days, warehouse, “Past dates only” —, the quantity in stock, both dates and the due date. The product, the lot and the warehouse link to their cards.

The daily email

A scheduled job sends the list to the addresses of your choice. It is created disabled: you enable it in Admin ToolsScheduled jobs. Nothing is sent when there is no lot to report. The “Send the email now” button on the setup page lets you check sending right away.

The shipment check

When a shipment is validated, the module looks at each shipped lot. If its date is past, it applies the setting chosen for that type of date:

A date is past from the next day on: on the sell-by date itself, the lot can still be shipped.

The screenshots come from a demo grocery, on Dolibarr 24.0.1, on 14 October 2026, with the French interface.

A shipment validation refused: lot L2610-07 of YAOURT-NAT has a sell-by date (DLC) of 11/10/2026, past for 3 days. The module’s message appears at the top, and the shipment stays in “Draft” status.

The list of lots to watch, due within 30 days: five lots, two of them past — an eat-by date for 10 days, a sell-by date for 3 days —, then three lots due in 2, 6 and 25 days.

The setup page is reserved for administrators.

• One dedicated permission, “See the lots to watch (sell-by, eat-by dates)”: without it, no widget and no list.
• The shipment check applies to all users, whatever their permissions.
• When blocked, nothing is saved: Dolibarr cancels the whole validation, stock movements included.
• Setup reserved for administrators, with an anti-CSRF token.
• No outside connection: the email goes through Dolibarr’s email sending.

The dolixdlc folder, in readable PHP, under the GPL v3 or later licence: the module descriptor, the calculation and sending class, the widget, the trigger for the shipment check, the list, the setup page, the icons.

• Languages: French (fr_FR), English (en_US) and German (de_DE).
• A README.md describing how it works and its limits.
• A ChangeLog.md.

• No table is added. The module reads the lots, their dates and their stock per warehouse.
• Nothing is written to lots, products, stock or shipments.
• The only writes are the settings of the setup page, stored as Dolibarr constants: DOLIXDLC_DAYS, DOLIXDLC_SHIP_SELLBY, DOLIXDLC_SHIP_EATBY and DOLIXDLC_MAIL_TO. Enabling the module also adds a widget and a scheduled job.
• The email contains the list of lots to watch: product, lot, warehouse, quantity and dates.
• No Dolibarr file is modified. No outgoing connection apart from Dolibarr’s email sending.