Pharmacy Management System

The Pharmacy Management System (PMS) is a desktop-based software application developed to automate the daily operations of a retail pharmacy, including medicine inventory management, sales processing, and expiry-date monitoring. Traditional, manual approaches to pharmacy management, which rely on paper registers and spreadsheets, are prone to significant limitations such as inaccurate stock records, delayed detection of expired medicines, inconsistent billing, and the absence of centralized, searchable records. These shortcomings can lead to financial losses, stock-outs of essential medicines, and, in more serious cases, the dispensing of expired or near-expired products. This project addresses these issues by designing and implementing a computerized system built using Python 3.11+, the PyQt6 graphical user interface framework, and the SQLite3 relational database engine. The system follows a three-tier architecture that separates the presentation layer, business logic layer, and database layer, allowing for a maintainable and extensible codebase. The core functionalities implemented include medicine registration and categorization, supplier and customer record management, real-time inventory tracking with automatic stock deduction upon sale, expiry-date monitoring with visual alerts, low-stock notifications based on configurable reorder levels, and a point- of-sale (POS) module that calculates itemized bills and generates transaction receipts. All data is persisted in a normalized SQLite3 database that enforces referential integrity through primary key and foreign key constraints, as well as data validation rules such as NOT NULL, UNIQUE, and CHECK constraints. The system was evaluated through a structured testing process covering database initialization, CRUD operations, sales transactions, stock deduction accuracy, expiry detection, low-stock alerts, and input validation. Test results confirm that the system performs its intended functions reliably and produces accurate calculations. The developed Pharmacy Management System demonstrates how a combination of an event-driven GUI framework and a lightweight relational database can be used to build a practical, functional application that reduces manual effort, improves data accuracy, and supports better decision- making in a small to medium-sized pharmacy setting.

Project Overview

System Name: Pharmacy Management System.
Tech Stack: Built as a local desktop application using PyQt6 for a responsive user interface and SQLite3 for lightweight data storage.
Institution: Developed by students at the University of Puthisastra.

Core Problem & Solution

The Problem: Traditional manual pharmacy management relies on vulnerable paper records, lacks real-time stock visibility, is prone to human calculation errors, and suffers from slow report preparation.
The Solution: A digital system that automates daily operations, tracks inventory in real time, automates sales calculations, and provides instant reporting.

Key Features

Medicine Management: Quick registration, pricing updates, and tracking of expiry dates and manufacturers.
Inventory Management: Real-time stock tracking with automatic low-stock alerts and reorder suggestions.
Sales Management: A point-of-sale checkout system handling discounts, secure transaction history, and instant receipt generation.

System Architecture

The application uses a layered architecture consisting of four parts: Pharmacy Staff (users) → PyQt6 GUI (UI layer) → Business Logic (inventory/sales handlers) → Data Access Layer (SQLite3 queries and database).

Measurable Impact

Time Saved: Saves roughly 60 seconds per transaction.
Accuracy: Achieves 99.9% inventory tracking accuracy and significantly cuts manual human mistakes.

Pharmacy Management System

មតិយោបល់ 0