Pharmacy POS & Inventory

Cumilla Diabetic Association's pharmacy carried over three thousand medicine and injection variations. Stock levels and expiry dates lived in a staff member's head. Billing was a handwritten slip, which meant management had no view of daily movement and no way to spot a line going out of date until it already had.

This is the ordinary shape of small-institution software failure: not an absence of systems, but an absence of anything that survives the person who runs it leaving the room.

The binding constraint was data entry. A pharmacy counter cannot afford a four-field form per sale — if finding the right item takes longer than writing a slip, staff will write the slip and the system becomes a very expensive paperweight.¹

So structuring three thousand variants so the correct one surfaces in two keystrokes mattered more than any other decision in the build. Everything else — the reporting, the expiry logic — was downstream of getting that one interaction under the threshold where it beats paper.

Point-of-sale and billing replaced the handwritten slip at the counter. Inventory and expiry tracking gave staff live visibility across the full catalogue rather than a periodic stock-take. A reporting layer turned daily sales and stock movement into summaries management could act on, which was the first time that data had existed in a readable form.

The full medicine and injection database was structured and then maintained as the catalogue grew — along with day-to-day administration, troubleshooting and process work, as the pharmacy's single technical point of contact.