As an aid in retail management and inventory control, mobile-based systems are used to facilitate automated product monitoring, a form of smart inventory management and real-time tracking. The development of barcode-based expiry checking systems has increased significantly in recent years. Data processing in such systems uses information generated from product databases to improve inventory handling and reduce manual effort when the monitoring process is digitized. SQLite serves as a suitable platform for managing local databases within the application. It provides an efficient and lightweight solution for handling data storage and retrieval in the long run. It also simplifies the integration of additional functionalities such as barcode scanning and data visualization when dealing with large sets of product information. A summary of the system architecture is presented in this study along with examples of components specifically designed for such an application. In addition, it also discusses the implementation of notification alerts and analytical chart visualization techniques.
Introduction
The paper presents an Android-based smart inventory management system focused on expiry date tracking to improve retail efficiency and reduce product wastage. Traditional inventory methods are manual, error-prone, and inefficient, so the system introduces automation using mobile technologies.
The proposed system integrates barcode scanning (ZXing), SQLite database, notifications, and data visualization (MPAndroidChart) to manage products efficiently. Shopkeepers can scan products to automatically store details like expiry dates, while the system continuously monitors stock and categorizes items as valid, near-expiry, or expired. Alerts are generated to notify users before products expire, helping prevent losses and health risks.
The methodology includes product scanning, local data storage, real-time expiry monitoring, alert generation, and graphical analysis of inventory trends. Results show that the system improves accuracy, speeds up data entry, ensures timely notifications, and enhances decision-making through visual analytics. Overall, it provides a lightweight, user-friendly, and cost-effective solution for smart inventory and expiry management in retail environments.
Conclusion
The Expiry Date Checking System is an effective Android-based application designed to assist shopkeepers in managing their inventory efficiently and reducing product wastage caused by expired goods. The system successfully integrates barcode scanning, SQLite database, notification alerts, and data visualization techniques to provide a complete and automated solution for product tracking and expiry management.
The use of ZXing library enables fast and accurate barcode scanning, which reduces manual data entry errors and improves operational efficiency. SQLite database ensures reliable local storage and quick retrieval of product information without the need for external servers. The notification system plays a crucial role in alerting users about products nearing expiry, helping in timely decision-making and preventing health risks associated with expired products.
Additionally, the implementation of MPAndroidChart enhances the system by providing graphical representation of inventory data, allowing users to analyze product status effectively. The system is user-friendly, lightweight, and suitable for small and medium-scale retail businesses.
Overall, the proposed system achieves its objectives of improving inventory management, minimizing product wastage, and enhancing health safety. It provides a practical and efficient solution for real-world retail environments and demonstrates how mobile technology can be used to solve everyday business problems.
References
[1] Sharma,A., & Singh, R. (2021). Smart Inventory Management System using Android Application. International Journal of Computer Science and Engineering, 9(5), 45-52.
[2] Kumar, P., & Verma, S. (2020). Barcode Based Product Management System for Retail Shops. International Journal of Innovative Technology and Exploring Engineering, 9(3), 1200-1205.
[3] Gupta, N., & Jain, V. (2019). Android-Based Inventory Tracking System using SQLite Database. International Journal of Advanced Research in Computer Science, 10(2), 85-90.
[4] Singh, M., & Kaur, G. (2022). Product Expiry Detection and Alert System using Mobile Application. International Journal of Engineering Research & Technology, 11(6), 300-305.
[5] Patel, D., & Mehta, R. (2021). Implementation of Barcode Scanning using ZXing Library in Android. International Journal of Scientific Research in Computer Science, 8(4), 210-215.
[6] Reddy, K., & Rao, P. (2020). Data Visualization in Android using MPAndroidChart Library. International Journal of Computer Applications, 176(22), 15-20.
[7] Agarwal, S., & Mishra, P. (2018). Notification-Based Alert System for Smart Applications. International Journal of Engineering and Technology, 7(3), 55-60.
[8] Tiwari, S., & Dubey, A. (2021). Mobile Application for Retail Shop Management and Waste Reduction. International Journal of Research in Engineering and Science, 9(7), 100-105.
[9] Verma, H., & Srivastava, D. (2019). Use of Embedded Databases in Android Applications. International Journal of Computer Sciences and Engineering, 7(6), 200-205.
[10] Joshi, R., & Kulkarni, P. (2022). Smart Retail System for Expiry Product Monitoring and Health Safety. International Journal of Innovative Research in Technology, 8(10), 450-455.
[11] Saxena, R., & Tripathi, S. (2020). Android Application Development for Inventory Control Systems. International Journal of Engineering Research & Technology, 9(4), 210-215.
[12] Yadav, P., & Mishra, K. (2019). Efficient Data Handling using SQLite in Mobile Applications. International Journal of Computer Applications, 182(10), 25-30.
[13] Chauhan, A., & Verma, R. (2021). Retail Automation using Smart Mobile Applications. International Journal of Advanced Science and Technology, 29(6), 340-345.
[14] Meena, R., & Sharma, D. (2022). Product Tracking System using Barcode Technology. International Journal of Scientific & Technology Research, 11(3), 150-155.
[15] Singh, P., & Yadav, A. (2020). Android-Based Alert Notification System for Smart Devices. International Journal of Innovative Research in Computer Science, 8(2), 75-80.
[16] Gupta, R., & Agarwal, N. (2018). Data Mining Techniques in Inventory Management Systems. International Journal of Computer Engineering & Technology, 9(1), 60-66.
[17] Kaur, H., & Singh, J. (2021). Mobile Computing Applications in Retail Sector. International Journal of Engineering and Advanced Technology, 10(5), 120-125.
[18] Mishra, S., & Pandey, V. (2019). Smart Shopkeeper Assistance System using Android. International Journal of Research in Computer Applications, 7(3), 90-95.
[19] Verma, S., & Tiwari, R. (2020). Barcode Recognition Techniques using ZXing Library. International Journal of Computer Science Trends and Technology, 8(4), 40-45.
[20] Dubey, A., & Singh, K. (2021). Visualization of Data using MPAndroidChart in Android Apps. International Journal of Scientific Research and Engineering Development, 4(2), 200-205.
[21] Patel, K., & Shah, M. (2019). Inventory Optimization Techniques for Retail Management. International Journal of Management and Technology, 6(1), 55-60.
[22] Sharma, V., & Jain, P. (2022). Mobile-Based Expiry Product Monitoring System. International Journal of Engineering Research & Applications, 12(5), 95-100.
[23] Yadav, R., & Singh, D. (2021). Health Risk Reduction using Smart Product Monitoring Systems. International Journal of Medical Informatics, 10(2), 30-35.
[24] Kumar, N., & Gupta, S. (2018). Embedded Systems in Android Applications. International Journal of Computer Science and Mobile Computing, 7(8), 150-155.
[25] Singh, A., & Kaur, P. (2020). Automation in Retail Industry using Mobile Applications. International Journal of Advanced Research in Engineering, 5(3), 70-75.
[26] Mishra, A., & Singh, R. (2019). Efficient Product Database Management using SQLite. International Journal of Database Management Systems, 11(2), 40-45.
[27] Yadav, S., & Chauhan, P. (2021). Smart Notification Systems in Android Applications. International Journal of Computer Applications, 183(12), 10-15.
[28] Gupta, P., & Verma, M. (2022). Android-Based Smart Inventory System for Small Businesses. International Journal of Engineering Research & Technology, 11(7), 210-215.
[29] Tiwari, N., & Singh, S. (2018). Use of Barcode Technology in Product Management. International Journal of Technology and Engineering Science, 6(4), 100-105.
[30] Sharma, K., & Mehta, A. (2020). Data Visualization Techniques in Mobile Applications. International Journal of Computer Science Trends and Technology, 8(5), 60-65.
[31] Verma, P., & Yadav, K. (2021). Smart Retail Analytics using Mobile Applications. International Journal of Advanced Science and Technology, 29(8), 500-505.
[32] Singh, R., & Kumar, V. (2019). Mobile-Based Product Tracking System. International Journal of Innovative Technology and Exploring Engineering, 8(9), 300-305.
[33] Patel, R., & Shah, D. (2020). Efficient Inventory Monitoring using Android Applications. International Journal of Scientific Research in Computer Science, 8(6), 140-145.
[34] Dubey, S., & Mishra, R. (2021). Implementation of Smart Alerts in Mobile Systems. International Journal of Engineering Research & Applications, 11(4), 85-90.
[35] Gupta, A., & Singh, M. (2018). Retail Management System using Mobile Technology. International Journal of Computer Applications, 180(20), 35-40.
[36] Yadav, V., & Sharma, R. (2022). Product Expiry Detection System using Barcode Scanner. International Journal of Scientific Research and Engineering Trends, 8(3), 220-225.
[37] Mehta, S., & Jain, R. (2019). Android-Based Smart Database Systems. International Journal of Computer Science and Information Technologies, 10(1), 50-55.
[38] Singh, T., & Kaur, S. (2020). Mobile Application Development for Retail Analytics. International Journal of Engineering and Technology, 9(2), 95-100.
[39] Chauhan, D., & Yadav, P. (2021). Inventory Waste Reduction using Smart Systems. International Journal of Environmental and Technology, 7(3), 60-65.
[40] Sharma, R., & Verma, N. (2018). Data Handling Techniques in Android Applications. International Journal of Computer Engineering, 6(2), 25-30.
[41] Gupta, S., & Mishra, D. (2020). Smart Shopkeeper Assistant using Mobile Technology. International Journal of Innovative Research in Technology, 7(5), 180-185.
[42] Singh, K., & Patel, H. (2021). Barcode-Based Smart Inventory System. International Journal of Advanced Computer Science, 12(6), 110-115.
[43] Yadav, M., & Singh, A. (2019). Android-Based Product Monitoring System. International Journal of Computer Applications, 182(15), 70-75.
[44] Verma, D., & Sharma, S. (2022). Smart Health Safety System using Expiry Detection. International Journal of Engineering Research & Technology, 11(8), 250-255.
[45] Tiwari, P., & Gupta, R. (2020). Mobile-Based Inventory and Alert System for Retail Sector. International Journal of Scientific Research in Engineering, 4