01 Starting point
Irrigation technology is project business in shop clothing. What gets bought is rarely a single item but components that have to fit together: nominal diameters, connecting threads, pressure ratings, flow rates and sprinkler ranges decide whether an order works in the end.
Then there is the data. Item master, prices and stock sit in the ERP system, and the shop needs the same information up to date. Maintain both separately and discrepancies appear between offer and availability, and sales is left with the rework.
02 Solution
The shop runs on Magento. The attribute model reflects the technical characteristics of the range, so filters and navigation work along real selection criteria and not only along category names. Variants, quantity pricing and accessory references are part of the data structure.
The second focus is the interfaces. Item master, prices and stock come from the system of record, and orders run back to it from the shop. The transfers are built as scheduled jobs with logging and retry logic, so a single failure does not block the whole sync.
Operation rests on PHP 8 and MariaDB, Redis for sessions and cache, and Elasticsearch for product search. Delivery is containerised with Docker from our own servers in Germany, including updates, backups and monitoring.
03 Result
Shop and ERP work from one set of data. Prices and stock are maintained in one place and the shop picks them up automatically. Double entry and the discrepancies that follow from it disappear.
The range can grow without rebuilding the structure: new item groups inherit the existing attribute and filter model. Sales and customer see the same data, which cuts down queries about availability and terms.