ERP ↔ Shopify integrations for e-commerce.
ERP integration with Shopify for e-commerce in Spain: syncing catalogue, stock, orders and customers across complex architectures.
Proven experience in complex integrations, most notably connecting ERPs with Shopify, ensuring smooth synchronisation of catalogue, stock, orders and customers.
What it solves
- Synchronisation of catalogue, attributes and prices between the ERP and the Shopify store.
- (Near) real-time stock management to prevent overselling.
- Round-trip flow of orders and customers between Shopify and the back office.
- Integration with PIM/OMS and other systems in the client's ecosystem.
Each integration is designed around the reality of the existing ERP — there's no forcing a back-office redesign to fit the store.
How I approach it
The starting point is always the client's ERP, not Shopify. First I map the real data model — how it represents products, variants, per-channel prices, stock per warehouse and order states — and only then do I decide which system is the source of truth for each field. That decision (catalogue and stock from the ERP, orders from Shopify into the ERP) avoids the sync loops and write conflicts that break most improvised integrations.
The integration is built as a decoupled service between the two systems, not as a plugin inside Shopify nor as a process bolted onto the ERP. That way it can evolve, retry and be audited without touching either end.
Technical patterns
- Webhooks + reconciliation. Shopify events (order creation, inventory changes) are processed in near real time via webhooks, with a periodic reconciliation process that closes any gaps when a webhook is lost.
- Idempotency and retries. Every operation carries an idempotency key so that a retry doesn't duplicate orders or deduct stock twice.
- Explicit catalogue mapping. Typed attributes (category, size, colour, per-channel price) are mapped one-to-one between the PIM/ERP and Shopify, keeping the catalogue structured rather than scraped.
- Observability. An event queue, traces and alerts on stock divergences to catch problems before they cause overselling or stockouts.
The result is an integration the client can operate with confidence: the back office remains their working tool and the store reflects the reality of the business with no manual intervention.