Context
Sigmatherm is a retail company operating a physical store, a warehouse, and a well-developed online sales ecosystem. Over 50% of sales are generated through the physical store using Microinvest Warehouse PRO, while the remaining sales come from five different online channels:
eMAG (Bulgaria, Romania, Hungary)
The Greek marketplace Skroutz
A proprietary online store built on Magento
Until the start of the project, inventory management was handled manually through Excel files and XML imports. This process caused delays, errors, and duplicated work across teams.
Challenge
The core challenge was the lack of centralized synchronization of inventory levels and pricing. A sale in one channel required manual updates across all others, which led to:
Frequent inventory mismatches
Losses from canceled or rejected orders
High administrative overhead
Sigmatherm needed a fully automated process to ensure real-time, accurate data across all sales channels and the warehouse system.
Solution
The Ludogorie Soft team developed a custom web-based synchronization platform that provides:
Two-way integration between the Microinvest warehouse system and all online sales channels
Support for multiple data exchange formats: Excel, XML, JSON, and APIs
A crawler module for collecting prices and stock availability from six distributors
A centralized “master table” containing products, suppliers, images, and pricing formulas tailored for different markets
Automated cron jobs and webhooks for near real-time synchronization (e.g., Skroutz)
Notifications when stock levels reach predefined minimum thresholds
From a technical standpoint, the solution uses JWT-based authentication and is designed to be easily extensible with new stores or suppliers.
Technical Challenges
Different API standards
eMAG: Excel files with three separate sheets
Skroutz: XML feeds and API integration
bol.com: proprietary API specification
Approach:
An abstraction layer was built to support flexible, reusable connectors for each platform.
Promotional campaigns
Different pricing rules for Black Friday, seasonal campaigns, and discounts required dynamic pricing logic.
Approach: Pricing formulas were implemented to support automated, rule-based price calculations.
Product variations
Products with multiple sizes and internal codes created inconsistencies across platforms.
Approach: Variations were unified under a single master product with structured variants.
Results
100% automation of inventory and price updates
Over 70% reduction in time spent on manual product administration
Significant decrease in errors and canceled orders
Ability to add new products centrally and publish them to all sales channels instantly
Improved control over promotional campaigns and pricing strategies
Conclusion
The project provided Sigmatherm with a competitive advantage through a centralized, reliable platform for inventory and price management. The solution enables scalable growth and seamless integration of new online channels and marketplaces, supporting the company’s continued expansion.
