부산대학교 도서관

In this article, a retail management system (RMS) called Shopwell is developed which keeps track of the expiry date of products along with the total expenditure analysis through Python, MySQL, and Android Studio where customers can keep track of the budget utilized for buying the products like groceries, cosmetics, and medication and it alerts when the product expiry is near while shopping online or offline. The customers hardly keep track of expiry dates on products and sometimes it is hard to keep track of total spending over a while. The proposed system can be linked with any retail business and comes in handy in the form of an app that can be installed on mobiles, tablets, and laptops. Once the retail business ties up with Shopwell, the bill which is created after shopping generates a link which directly links to the app once clicked by the customer when shopping online otherwise the link is established once the cashier scans the QR code available in the customer's app after scanning the products over offline mode. Once the app has the required data of the purchased items, it assists the customers to keep a record of the purchase details chiefly on the expiration date and the total expenditure thus avoiding consumers to stop using out of date products while keeping the daily budgets within stipulated limits.