Multi-Channel E-Commerce and ERP Integration

In a fashion and apparel e-commerce operation, managing a single sales channel was no longer enough: the web store, marketplaces, accounting system, stock database and customer-facing mobile app needed to work in the same data flow. As Barlas Dijital, we brought these pieces together into a single, coherent digital ecosystem.

Problem

The operation was experiencing significant efficiency losses due to systems that were not integrated with one another. Inventory data was kept in the ERP while the web store ran on a different platform; synchronization between these two sources relied on manual processes. The marketplace channel was managed separately and order data was entered into the accounting system by hand. Product feeds were also prepared manually. On the customer side, there was no mobile app; users could only shop through a web browser.

Solution

The project’s architecture consisted of several layers connected by an API bridge. The e-commerce platform was integrated via its GraphQL API; product, order and inventory data were centralized through this API into a single flow point. Synchronization with the ERP was established at the MSSQL database level: stock changes in the ERP are automatically reflected in the web store, and approved orders are pushed to the ERP. Marketplace integration brought channel orders into the main system. Automatic XML feed generation was set up to run on scheduled tasks. For the mobile channel, an iOS and Android application was developed using the Capacitor framework; the same code base was published to both platforms. Analytics and conversion tracking infrastructure was also set up.

Key Features

• GraphQL Platform Integration: Product, order and inventory management was centralized into a single flow via the GraphQL API; platform updates and stock changes are synchronized in real time
• ERP – MSSQL Bridge: Bidirectional automatic data flow between the ERP database and the web store; order and inventory discrepancies were eliminated
• Multi-Channel Sales: Marketplace orders and inventory status were unified in a single management panel
• Automatic XML Feed Generation: Up-to-date product feeds are automatically generated and delivered via scheduled tasks
• iOS and Android Mobile App: A native app produced from a single code base with Capacitor; a brand-specific shopping experience
• Analytics Infrastructure: Conversion tracking, campaign performance and user behavior data became accurately measurable

Technical Infrastructure

At the core of the integration are GraphQL and REST API layers. GraphQL was preferred because its flexible query structure allows fetching complex data models such as product variants and order details with a minimal number of requests. Python scripts based on pyodbc run as scheduled tasks for ERP synchronization with MSSQL. Capacitor carries the mobile interface written with web technology to the native layer; this allowed publishing to the iOS App Store and Google Play in a single development cycle. Analytics tag management allows new event definitions to be deployed without requiring code changes.

Results

Once the integration was complete, order-stock synchronization, marketplace updates and feed generation processes that had previously been carried out manually became automated. The risk of operational errors decreased, customer complaints stemming from inventory discrepancies fell, and the sales side was able to redirect its time from system management toward growth-focused work. The mobile app offered customers a brand-specific shopping channel, increasing user engagement.