A comprehensive management system built in PHP for parapharmacy operations. The application handles the full business workflow — product inventory with expiration tracking, supplier management, sales processing, and customer records. Designed to replace manual spreadsheet tracking with a reliable, centralized web-based system that the entire team can access.
Academic Project
PHP / MySQL / HTML / CSS / JavaScript / Bootstrap
Build a complete parapharmacy management platform that tracks inventory, processes sales, and manages supplier relationships from one centralized dashboard.
Parapharmacy products have unique requirements — expiration dates, batch numbers, regulated categories, and reorder thresholds. Building an inventory system that tracks all these attributes while alerting staff to expiring stock required a well-designed data model.
Different staff members need different access levels — cashiers process sales, managers handle suppliers and reports, admins control everything. Implementing a robust role-based permission system without overcomplicating the user experience was a key challenge.
Management needs clear visibility into sales trends, profit margins, and stock levels. Building a reporting engine that generates useful daily, weekly, and monthly reports from raw transaction data required solid SQL skills and clean data visualization.
Automated expiration alerts and reorder notifications mean nothing slips through the cracks. Staff are notified before products expire, keeping the shelves compliant and reducing waste.
Sales processing, inventory lookups, and supplier orders all happen through one clean interface. What used to take hours with spreadsheets now takes minutes, freeing staff to focus on customers.
Automatic reports give management instant visibility into sales performance, stock levels, and profit margins. Data-driven decisions replace guesswork, improving profitability and efficiency.