Odoo allows you to control the expiration dates of goods in your warehouse using a lot or serial number. This is especially important for food, pharmaceuticals, cosmetics, and any goods with a limited shelf life.
Step 1: Expiration Date Activation
Go to the "Settings" module:
In the "Warehouse" section, activate the following checkboxes:
- Tracking by batch or serial number
- Expiration date
Click "Save."
Step 2: Product setup
To track expiration dates, you must enable expiration date tracking when creating a product.
To do this, go to the "Warehouse" tab in the product card:
In the “Tracking” field, select “By unique serial number” or “By batches.” After that, you will see the “Expiration date” field:
Check the "Expiration Date" box and fill in the fields:
- Expiration date (expiration date) — for example, 30
- Best before date — for example, 20
- Removal date — when the item should be removed from the warehouse
- Warning date - when the system should warn about the expiration date
The specified values will automatically be applied to all new batches of the product.
Step 3: Adding batches as they arrive
When receiving goods into the warehouse, you will need to specify the batch number and, if necessary, adjust the automatically calculated expiration date.
Step 4: Checking the remaining quantities by batch and expiration date
Go to the "Warehouse" - "Reporting" - "Location" module:
In the list settings, add the columns "Expiration Date" and "Removal Date":
Then, using filters and groupings, you can find information about a specific product, display a list of products that are about to expire, a list of products that have already expired, etc.:
Also, when you try to issue an expired product from the warehouse, Odoo will issue a warning notification:
Step 5: Selection Priority (FEFO)
Please note that in the product category settings you can define the method of inventory disposal. If the FEFO (First Expired, First Out) strategy is selected, then during warehouse movements Odoo will automatically recommend issuing the batch with the closest expiration date. This allows you to effectively manage inventory and minimize the risks associated with expired products.
