Real-time Shopify ↔ SYSPRO middleware
A UK manufacturer needed orders, stock, and fulfilment to flow automatically between their Shopify store and SYSPRO 8 ERP - with reliable handling of webhook drops, VAT-inclusive pricing, and idempotent order ingestion. The off-the-shelf connectors couldn't cope with the line-level VAT model or the ERP-specific business rules.
A bespoke Go middleware deployed on dedicated hardware, calling SYSPRO via the e.net REST business objects: SORTOI to post orders, INVQRY for stock pull, SORQRY for fulfilment write-back. HMAC-verified Shopify webhooks, two-layer deduplication (webhook ID + database constraint), batched processing every 5 minutes, and a 48-hour reconciliation sweeper as a safety net for missed events.
Live and processing real customer orders. Stock figures stay current every 15 minutes; fulfilment writes back inside 30 minutes; 200+ unit and integration tests cover the business logic and the SYSPRO contract. Boot-time crash recovery and Microsoft Graph email notifications round out the operational safety.