Skip to content
Hypamoon

For teams that run on Odoo

Odoo expiration date alert: a weekly list

Odoo works out expiration, removal and alert dates per lot from the product settings, and raises an alert on the lot. Seeing which lots expire soon across the warehouse, with quantity and location, means searching the lots yourself.

How it goes today

  1. Filter the lots on expiration date in the lots list.
  2. Look up the quantity and location of each lot.
  3. Write a list for the warehouse of what to sell first or take out.
  4. Repeat it each week.

How it can go

See each week which lots are close to their expiration date.

Each Monday the warehouse gets an email with the lots and serial numbers that reach their alert or removal date in the coming four weeks, with the product, quantity on hand, location and expiration date, sorted by date. Lots already past their removal date are at the top.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Odoo key in the portal, never in the chat.

Your request

With Hypamoon, every Monday, email our warehouse the lots and serial numbers in Odoo that reach their alert or removal date in the next four weeks. Show the product, the quantity on hand, the location and the expiration date, sorted by date. Put lots that are past their removal date at the top.

You create an Odoo API key yourself under Preferences, Account Security, for a user with the access you want to give. A key lasts at most three months, so you renew it in the portal. On Odoo Online and Odoo.sh this needs the Custom plan. It stays yours.

More for teams on Odoo