Medicine Storage Management System: A Digital Approach for Efficient Healthcare Inventory

Medications are a key part of healthcare service delivery, but their storage and handling still pose issues in both small-scale and institutional levels. Storage by manual means usually leads to inefficiencies like improper tracking of stocks, unmonitored medicines expiration, wastage, and billing errors through human oversight. Available digital solutions, though present, are usually costly, have non-user-friendly interfaces, and do not offer real-time notifications. In order to solve these problems, this paper introduces the design and development of a Medicine Storage Management System (MSMS) that incorporates digital stock management, expiry and refill reminders, billing, and sales tracking on one platform. Built on Python Flask for backend processes, SQLite for database management, and HTML/CSS/JavaScript for the front end, the system offers a cost-effective and scalable solution for homes, pharmacies, and hospitals. The MSMS guarantees secure access via role-based authentication, keeps records centralized and correct, and triggers timely reminders on medicines approaching expiry or that are low in stock. Testing and evaluation confirm gains in efficiency, wastage reduction, and user satisfaction. This effort proves how digital transformation of medicine management can improve safety, lower costs, and deliver better healthcare outcomes.