Pharmaceutical Distribution: Traceability and Automated Compliance

A pharmaceutical distributor in northern Portugal faced a regulatory nightmare. With over 1,200 references of medicines and medical devices, traceability was managed in manual spreadsheets, temperature monitoring during transport relied on analogue recorders that nobody checked in real time, and preparation for INFARMED audits consumed entire weeks of work. An inspection nearly resulted in a serious sanction. After full digitalisation — electronic traceability, IoT sensors and automated reports — the company not only achieved total compliance but reduced operating costs by 41%.

The Scenario Before: Between Paper and Regulatory Risk

PharmaLog (real case — data altered under NDA) distributes medicines, supplements and medical devices to pharmacies, clinics and hospitals across the north and centre of Portugal. With 32 employees and a fleet of 12 refrigerated vehicles, the company handles approximately 4,500 orders per month and generates annual revenue of €8.7 million.

In the pharmaceutical sector, regulatory compliance is not optional — it is a matter of business survival. INFARMED requires complete traceability of every medicine batch, from reception from the manufacturer to delivery at the pharmacy. Good Distribution Practice (GDP) imposes rigorous requirements on storage, transport and documentation. And with the enforcement of the European Falsified Medicines Directive, each package needs to be individually verified and decommissioned.

PharmaLog was trying to meet these requirements with essentially manual processes:

Traceability in spreadsheets. Each batch received was manually recorded in an Excel spreadsheet, with batch number, expiry date, quantity and supplier. At dispatch, the operator manually recorded which client each batch was sent to. Any recall required someone to manually trawl through hundreds of rows to identify all recipients of a specific batch. The average time to complete a recall was 72 hours — unacceptable in a pharmaceutical context.

Analogue temperature monitoring. Refrigerated vehicles had paper temperature recorders. Records were collected weekly, visually checked and filed in folders. If a temperature excursion occurred during transport, nobody knew in real time. The anomaly would only be discovered days later — if someone remembered to check the chart.

Manual audit preparation. When INFARMED scheduled an inspection, the quality team went into emergency mode. Two to three people dedicated themselves for two weeks to compiling records, cross-referencing data, preparing dossiers and verifying documentation consistency. This period was marked by high stress, overtime and the constant fear that some record might be missing.

The Numbers Behind the Problem

The initial assessment revealed concerning data:

• Average recall response time: 72 hours.
• Error rate in manual traceability: 8.4% of records contained inconsistencies.
• Undetected temperature excursions: estimated 15 to 20 per month (discovered retroactively).
• Audit preparation time: 240 person-hours per inspection.
• Annual cost of non-conformities: €23,000 (returns, destroyed products, rework).
• Weekly hours dedicated to compliance: 68 hours (3 full-time staff).
• Risk of regulatory sanction: high (two critical observations in the last inspection).

The Solution: Digitalisation on Three Fronts

Front 1: Complete Digital Traceability

We implemented a digital traceability system based on barcode and DataMatrix scanning. At goods reception, each package is scanned individually — the system automatically captures the product code, batch number, expiry date and serial number (where applicable under European serialisation). The information is associated with the supplier's dispatch note and the certificate of analysis.

At dispatch, the same process occurs in reverse: each package is scanned before entering the transport container, automatically associated with the client order, the transport note and the delivery vehicle. The system verifies in real time whether the product is fit for dispatch — expiry date, quarantine status, active recall — and blocks dispatch if any anomaly is detected.

In the event of a recall, the system identifies in less than 30 seconds all recipients of a specific batch, automatically generates email and SMS notifications, and creates the regulatory report for submission to INFARMED.

Front 2: IoT for Real-Time Temperature Monitoring

We installed IoT temperature and humidity sensors in all refrigerated vehicles and in all warehouse zones (ambient, refrigerated 2–8 °C and frozen –20 °C). The sensors transmit readings every 60 seconds via cellular network, feeding a centralised dashboard accessible to the entire quality team.

The system generates automated alerts at three levels: warning (when temperature approaches the limits), alarm (when it exceeds the limit for more than 5 minutes) and critical (when the excursion persists for more than 15 minutes). Alerts are sent by SMS and push notification to the quality manager and the affected vehicle's driver.

Each temperature excursion is automatically recorded, including duration, amplitude, affected products and the decision taken (release, quarantine or destruction). This record directly feeds GDP compliance reports.

Sensor calibration is monitored automatically, with alerts for recalibration before the certification validity period expires. Calibration reports are archived digitally and associated with the specific sensor.

Front 3: Automated Regulatory Reports

The third front focused on eliminating the manual work of preparing regulatory documentation. We developed a module that automatically generates all reports required by INFARMED and Good Distribution Practice:

• Traceability report by batch: with the complete chain of custody, from reception to final delivery.
• Storage conditions report: with temperature and humidity charts by zone, documented excursions and corrective actions.
• Returns and recalls report: with complete chronology, notifications sent and responses received.
• Supplier qualification report: with compliance history, valid certificates and registered non-conformities.
• Annual activity report: automatic consolidation of all regulatory indicators.

All reports are generated in PDF format with a digital certificate, ready for submission to INFARMED. The system maintains a regulatory calendar that automatically alerts for submission deadlines, licence renewals and scheduled inspection dates.

Results After 6 Months: The Transformation in Numbers

The comparison between before and after is unequivocal:

• Recall response time: from 72 hours to 28 minutes (99.4% reduction).
• Traceability error rate: from 8.4% to 0.3%.
• Undetected temperature excursions: from 15–20/month to zero.
• Audit preparation time: from 240 person-hours to 8 hours (automated report generation and review).
• Annual cost of non-conformities: from €23,000 to €3,100.
• Weekly hours dedicated to compliance: from 68 to 18 (50 hours/week freed).
• Latest INFARMED inspection result: zero critical observations, two minor observations (vs. two critical and seven minor in the previous inspection).

Financial Impact and Return on Investment

The total project investment — traceability software, IoT sensors (42 units), report module development, training and ERP integration — was €52,000. The estimated annual saving, considering reduction of non-conformities, freed human resources, elimination of analogue recorders and reduction of losses from temperature excursions, stands at €127,000. Payback was achieved in less than 5 months.

But the most significant value is intangible: regulatory peace of mind. The quality team stopped living in a state of permanent anxiety. Audits went from moments of terror to demonstrations of competence. And the company gained a powerful commercial argument with its clients — digital traceability and real-time temperature monitoring are competitive differentiators in a market where trust is everything.

Conclusion

Pharmaceutical distribution is one of the most regulated and demanding sectors. Yet many Portuguese companies still try to meet 21st-century requirements with 20th-century tools. Digitalising traceability, environmental monitoring and compliance is not merely a matter of efficiency — it is a matter of regulatory survival and commercial competitiveness.

PharmaLog demonstrated that the transition is possible, measurable and financially sustainable. If your pharmaceutical distributor still relies on spreadsheets for traceability and paper recorders for temperature monitoring, every day that passes represents a risk that can be eliminated.