Medical Laboratory ERP

Overview

A pricing system for a network of laboratories: one shared analysis catalogue, an independent price list per lab against the same test, and Excel import instead of manual entry.

01The challenge

The same test carries a different price at each lab and with each contractor, and the lists arrive as Excel files that are updated periodically. Entering them by hand took days and introduced copy errors, and comparing two labs meant opening two files side by side.

02What we built

We separated the test from its price: the test is one entity in a shared catalogue, and a price is a row linking a test to a lab. Adding a new lab means adding a price list — not duplicating the whole catalogue.

We built an Excel import that reads the file, matches it against the catalogue and updates prices in one pass, turning a full list update into a few minutes of work. The interface runs on DataTables with search, sorting and direct export.

03The outcome

Price updates stopped being a long manual task, and comparing labs became one screen instead of parallel files — with a single reference catalogue that is not duplicated for every new lab.