Design and Implementation of a Custom ERP Framework for a Drilling Equipment Manufacturer

Abstract

This study presents the design and implementation of a web-based Enterprise Resource Planning (ERP) system tailored for a small-to-medium-sized enterprise (SME) operating in the manufacturing sector. With a focus on GEO Sondaj Makine İmalat LTD. ŞTİ, the system was developed to digitize and streamline core operational workflows, including sales order processing, production scheduling, inventory management, procurement, and coordination between customers and suppliers. Built using the Django web framework, the ERP platform provides modular functionality with real-time data integration across departments. Unlike generic ERP packages, this custom-built solution mirrors the company’s actual business processes and addresses typical challenges faced by SMEs, such as limited IT infrastructure, absence of digital records, and resistance to organizational change. The internally developed modules led to enhanced traceability, operational efficiency, and data-driven decision-making. The system also includes a simulation module to support production visualization and planning, although advanced features like bottleneck identification and dynamic queue tracking remain under development. The findings demonstrate that a cost-effective, scalable ERP system can be successfully deployed in resource-constrained environments when grounded in business-specific needs. The system was evaluated based on internal testing, interdepartmental workflow validation, and observed improvements in operational efficiency and traceability. This project offers a practical reference for other SMEs seeking to modernize their operations through digital integration. © 2025 Elsevier B.V., All rights reserved.