Web-Based Supply Chain Management Information System for Inventory and Distribution Control in Agricultural Trading MSMEs

Counts differ because each database indexes a different set of publications. We treat OpenAlex as the canonical count; Google Scholar is not shown (no API, and crawling it violates its ToS).

Agricultural trading micro, small, and medium enterprises (MSMEs) commonly manage their supply chain manually, leaving procurement, inventory, and sales records disconnected. At UD Tani Makmur, Batu Bara Regency, Indonesia, the supply of ten commodities between January and May 2026 reached 70,500 kg while sales reached only 65,500 kg, leaving 5,000 kg (7.09 percent) unsold and exposed to spoilage. This study designs, develops, and tests a web-based supply chain management information system for inventory and distribution control in such enterprises. Requirements were elicited through interviews, direct observation, and document study. The design was modelled with the Unified Modelling Language and an entity relationship diagram and implemented in PHP and MySQL for four user roles: administration, owner, sales, and supplier. The novelty lies in granting suppliers direct system access to approve or adjust purchase orders, submit product offers, and report price increases, so that information flows bidirectionally within a single centralised database. Black box testing of 33 test cases across eight functional classes returned an accepted status for all cases, confirming that the system meets its functional requirements. The effect of the system on unsold inventory has not yet been measured and requires post-deployment evaluation.