PHP-Based Stationery Sales Information System at Ufaira Printing Sigambal, Labuhanbatu

Abstract

Ufaira Printing in Sigambal, Labuhanbatu previously relied on manual records to manage stationery products, inventory information, customers, and sales related administration. This practice created inconsistent stock information, risk of lost records, delayed reporting, and operational decisions based on estimates rather than verified data. This study aimed to design, implement, and functionally test a PHP based stationery sales information system supported by a MySQL database. Development followed the waterfall model through requirements analysis, system and software design, coding, testing, and maintenance planning. Requirements were obtained through observation, literature study, and examination of the store's product and sales activities. The design was documented using a registration flowchart, context diagram, data flow diagram, entity relationship diagram, database tables, and interface plans. The implemented application provides customer registration, role based authentication, product and category administration, shipping expedition data, product catalog pages, and category specific displays for stationery, ink, office automation equipment, files, and furniture. Black box testing covered registration, login, logout, and product management access. All eight nonduplicative cases reported in the thesis produced the expected responses. The findings indicate that the system can organize product information and support more consistent catalog administration. However, the current evidence does not establish complete transaction processing, automatic inventory reconciliation, payment handling, security robustness, usability across users, or long term operational impact. Future work should complete these functions and evaluate data accuracy, task completion, and user experience after deployment.