Stockord: an inventory management system for local hardware stores/
Mary Angelene V. Balais, Alfredo C. Jr. Dacquel, April Joy L. Deang, Airysh Xander M. Espero, and Masayuki R. Retuerma.--
- Manila: Technological University of the Philippines, 2025.
- xiii, 233pages: 29cm.
Bachelor's thesis
College of Science.--
Includes bibliographic references and index.
Hardware Stores, also known as Ironmongers or DIY Stores, are commercial establishments that sell tools, building materials, and home improvement products. These establishments carry a wide variety of products. However, using manual processes to manage the inventory of a hardware store is intricate. In our modern era, it is good to use modern solutions as well. The study created an inventory management system, titled Stockord: An Inventory Management System for Local Hardware Stores, which would help in the operations of these types of stores. To develop the website, the system is built on various technologies such as Visual Studio Code for the IDE, Python as the programming language, Django (full stack) as the framework, HTML, CSS, JavaScript, Bootstrap for the front-end, PostgreSQL for the database, GitHub as version control, and Figma for UI Design. The system also utilized the ZXing library for barcode scanning, Plotly library for financial forecasting, Amazon Web Services (AWS) as cloud infrastructure, EC2 as web server, RDS as database, S3 for storage, and Cloudflare for domain/security. The system’s functionality and reliability were tested following the ISO/IEC 25010 for Software Quality Standards. The system demonstrated a strong functionality with a 100% pass rate for executed test cases in its 2nd cycle, while 100% of test cases passed on reliability testing. The system also achieved a high level of acceptance with an overall score of 3.73, which is categorized as “Highly Acceptable.” Local hardware stores can use Stockord because its features can help manage inventory, streamline operations, and improve business conditions. It is suggested that the system be further expanded, such as by implementing one-time passwords or OTP, improving the user experience, making the system more responsive to use on other devices, and using email to prevent unauthorized access to accounts.
Django Web application Inventory management system