INVENEASE - Inventory Management System
Course Instructor
Daniel Cliburn
Abstract
InvenEase is a desktop application designed to streamline inventory tracking and order management for small businesses. The system provides a centralized interface for monitoring product stock levels, processing orders, and viewing dashboard analytics such as total inventory value and recent order activity. The client application is built using Python and CustomTkinter, featuring a modern dark-themed graphical user interface (GUI). A navigation sidebar allows users to access key views, including the dashboard, inventory, products, orders, and settings. The application communicates with a MySQL database through a parameterized query layer, ensuring protection against SQL injection. Additionally, a TCP server component enables remote LAN clients to authenticate and query the database using a socket-based JSON protocol. Key features include secure password-authenticated login using PBKDF2-SHA256 hashing, real-time low-stock alerts based on configurable thresholds, full CRUD (Create, Read, Update, Delete) operations for products and orders, and multi-language support. The system follows a modular page architecture that separates concerns effectively, allowing each view to be developed and tested independently. InvenEase demonstrates the practical integration of a desktop GUI, relational database, and lightweight network server, resulting in a functional and extensible inventory management solution. Future enhancements may include role-based access control, advanced reporting features, and a web-based frontend.
INVENEASE - Inventory Management System
InvenEase is a desktop application designed to streamline inventory tracking and order management for small businesses. The system provides a centralized interface for monitoring product stock levels, processing orders, and viewing dashboard analytics such as total inventory value and recent order activity. The client application is built using Python and CustomTkinter, featuring a modern dark-themed graphical user interface (GUI). A navigation sidebar allows users to access key views, including the dashboard, inventory, products, orders, and settings. The application communicates with a MySQL database through a parameterized query layer, ensuring protection against SQL injection. Additionally, a TCP server component enables remote LAN clients to authenticate and query the database using a socket-based JSON protocol. Key features include secure password-authenticated login using PBKDF2-SHA256 hashing, real-time low-stock alerts based on configurable thresholds, full CRUD (Create, Read, Update, Delete) operations for products and orders, and multi-language support. The system follows a modular page architecture that separates concerns effectively, allowing each view to be developed and tested independently. InvenEase demonstrates the practical integration of a desktop GUI, relational database, and lightweight network server, resulting in a functional and extensible inventory management solution. Future enhancements may include role-based access control, advanced reporting features, and a web-based frontend.
