Smart Inventory and Sales Management System for Perishable Farm Products using a Web-based ERP Framework

Mohd Habeeb; Osman Ahmed Baamar; Mohd Arshad; Dr. Mohammed Jameel Hashmi

doi:10.62647/IJITCE2025V13I2sPP131-138

Authors

Mohd Habeeb Dept. of Computer Science and Engineering, ISL Engineering College, Osmania University, Hyderabad, India Author
Osman Ahmed Baamar Dept. of Computer Science and Engineering, ISL Engineering College, Osmania University, Hyderabad, India Author
Mohd Arshad Dept. of Computer Science and Engineering, ISL Engineering College, Osmania University, Hyderabad, India Author
Dr. Mohammed Jameel Hashmi HOD-CSE, Associate Professor, Dept. of Computer Science and Engineering, ISL Engineering College, Osmania University, Hyderabad, India Author

DOI:

https://doi.org/10.62647/IJITCE2025V13I2sPP131-138

Keywords:

SaaS, Multi-tenancy, ERP, Inventory Management, Perishable Products, Django, React, PostgreSQL, SME, Digital Transformation

Abstract

The wholesale sector, particularly for perishable agricultural products, faces significant operational challenges due to manual processes and lack of digital infrastructure. This paper presents the design and methodology for a Smart Inventory and Sales Management System tailored for perishable farm products, leveraging a web-based ERP framework with a multi-tenant Software-as-a-Service (SaaS) architecture. The system aims to empower Small and Medium Enterprise (SME) wholesalers by providing secure, scalable, and affordable tools for inventory, sales, purchase, and customer/vendor management. The architecture utilizes modern technologies such as Django, React, and PostgreSQL, with a schema-per-tenant approach for robust data isolation. The paper details the requirements, design, implementation methodology, and expected impact, aligning the solution with broader digital transformation initiatives in emerging economies.