Pharmacy Management in Odoo 19: Medicines, Batches and Daily Closing

Pharmacy management in Odoo comes down to three questions a pharmacy owner asks every day. What exactly is this product? Which batch expires next? And how did today's takings split between cash, card, credit and insurance? Standard Odoo 19 answers the second question well. The first and third need more than an ordinary product form and a sales report.

This guide sets out what a pharmacy needs from its system, how Odoo 19 Inventory handles batches and expiry dates, and how our free SBS Pharmacy Management module adds medicine master data and a daily closing report. It ends with the rollout steps our team follows when it sets up a pharmacy.

Running Odoo Enterprise, or planning to? Enterprise adds apps such as Barcode for scanning at receipt and Documents for licenses and supplier certificates, around the same Inventory setup, and our guide to Odoo Documents and approvals shows how the Documents side works. The pharmacy module is built and tested on Odoo 19 Community, so on Enterprise we try it on a staging copy first.

What a Pharmacy Needs from Its System

A pharmacy is a retailer with stricter master data. Before choosing modules, list what the system must do. A typical list looks like this:

• Medicine master data: active ingredient, strength, pack size, manufacturer, source and dispensing mode, recorded the same way every time.
• Batch and expiry control: every unit traceable to a lot, with its expiry date captured at receipt.
• First expired, first out: stock picked by expiry date rather than by arrival date.
• Daily closing: one figure each for cash, card, credit, insurance and branch, with the customer counts behind them.
• Reliable margins: cost of goods sold and closing stock that reflect real movements.
• Clear roles: counter staff who sell, and managers who see the closing figures.

Medicine Master Data on the Odoo Product Form

A standard Odoo product form has no place for an active ingredient or a dispensing mode. SBS Pharmacy Management adds an Is Medicine checkbox to the ordinary product. Tick it and a Medicine Details tab appears with the active ingredient, strength, pack size, manufacturer, import status and prescription requirement.

The values come from four small master lists that you maintain under the Inventory configuration menus:

• Active Ingredients: what the medicine contains, so you can find every brand of the same ingredient.
• Companies: the manufacturers, picked from a list rather than typed freely.
• Sources: local, imported or however you choose to classify supply.
• Dispensing Modes: over the counter, prescription only or controlled.

Each list can be archived rather than deleted, so an entry you stop using is hidden without being lost. Because staff pick values instead of typing them, the same ingredient is spelled the same way every time, which is what makes a search by ingredient reliable. The dispensing mode is recorded on the product, so keep your prescription checks in your dispensing procedure.

Batches and Expiry Dates with Odoo Inventory

Batch and expiry control is standard Odoo 19 Inventory, not part of the pharmacy module. It works on products tracked by lots, and Odoo's expiration dates documentation covers it in detail. The setup takes five steps:

1. In Inventory > Configuration > Settings, under Traceability, enable Lots and Serial Numbers, then Expiration Dates.
2. On each medicine's General Information tab, keep the product type as Goods and set Track Inventory to By Lots.
3. On the Inventory tab, tick Expiration Date and fill in the four dates, each in days: the Expiration Date after receipt, and the Best Before, Removal and Alert dates before expiry.
4. Set the removal strategy to First Expiry First Out (FEFO) on the stock location, or through Force Removal Strategy on the product category.
5. Name a Responsible user on the Inventory tab, so that person is given a to-do activity when a lot still in stock reaches its alert date.

From then on, a receipt cannot be validated until each line has a lot number, and the expiry date fills itself in from the product settings. For example, with an Expiration Date of 730 days and a Removal Date of 60 days, a lot received on 1 June 2026 expires on 31 May 2028 and should leave the shelf by 1 April 2028. When the date printed on the pack differs, overwrite it on the lot at receipt.

To review stock by expiry, open Inventory > Products > Lots/Serial Numbers, group the list by expiration date, and apply the Expiration Alerts filter to see the lots whose alert date has been reached. A weekly look at both is a habit worth building into the dispensary routine.