| Title: | OS1-5 Desktop-Based Expiry Date Application for Retailers Inventory Management |
|---|---|
| Publication: | ICAROB2025 |
| Volume: | 30 |
| Pages: | 40-46 |
| ISSN: | 2188-7829 |
| DOI: | 10.5954/ICAROB.2025.OS1-5 |
| Author(s): | Nur Hazwani Ahmad Halil, Suzi Seroja Sarnin, Nani Fadzlina Naim, Azlina Idris, Wan Norsyafizan Wan Muhamad, Darmawaty Mohd Ali, Md Nor Mat Tan, Mohd Rizal Dohad, Ros Shilawani S Abdul Kadir, Nur Syahirah Saipul, Zarina Baharudin Zamani |
| Publication Date: | February 13, 2025 |
| Keywords: | inventory management, desktop application, expiry data tracking |
| Abstract: | Inventory management is a complex process that requires constant evaluation and control. It is essential for retailers to perform inspections regularly to ensure that all goods are available for sale and in good condition to meet customer expectations. While many retailers are still dependent on manual paper-based method, it poses a high risk of human error and causes negative impact on inventory management and eventually the business. It is not only labor-extensive, but also time-consuming. This project is proposed to automate inventory management process by developing a realtime inventory monitoring system and notify user on low stock items and items close to expiration. The desktop-based inventory management application is equipped with a PC and a handheld scanner and involve three main inventory processes; scan incoming inventory, scan outgoing inventory during customer checkout and allow users to manage stock counts and update data if necessary. The desktop application is developed using Windows Forms form as user interface and SQL Server as the database engine which enables the users to monitor stocks in real-time. As a result, users can use the desktop application to monitor inventory levels and receive notifications when items need to be restocked or nearing their expiration date. As different item categories may need different reminder durations based on expiry dates, users entering the correct password are able to update the minimum quantity and minimum duration for each item category for notification purposes. With this system, issues related to inventory can be resolved quickly based on real-time data monitoring, less time spent for repetitive works while providing a better customer experience. |
| PDF File: | https://alife-robotics.co.jp/members2025/icarob/data/html/data/OS/OS1/OS1-5.pdf |
| Copyright: | © The authors. This article is distributed under the terms of the Creative Commons Attribution License 4.0, which permits non-commercial use, distribution and reproduction in any medium, provided the original work is properly cited. See for details: https://creativecommons.org/licenses/by-nc/4.0/ |
(c)2008 Copyright The Regents of ALife Robotics Corporation Ltd. All Rights Reserved.