Replaced a discontinued integration with an engineered Shopify to Xero sync that hasn't required intervention since launch.

01 / Situation

A retailer whose accounting integration was being shut down.

Modern Bungalow is a furniture retailer running Shopify on the commerce side and Xero on the accounting side. The integration between them had been handled by Cin7, which was being discontinued. The business needed product data flowing between commerce and accounting without a person in the middle. The deadline wasn't optional.

02 / The Problem

Off the shelf integration was about to disappear.

The platforms didn't talk to each other natively. The third party that handled the integration was sunsetting the product. Replacing it manually would have meant 60 hours per month of data entry, every month, indefinitely. The available off the shelf alternatives didn't fit the specific data shape the business needed. The fix had to be engineered, not bought.

03 / The Engineering

n8n workflow optimized for Xero's rate limits and Shopify's webhook reliability.

We engineered a custom n8n workflow that syncs Shopify draft products into Xero as inventory items. The naive implementation would have made 157 individual API calls per sync. We rebuilt it with bulk fetch optimization, reducing that to 2. Xero's rate limits required batched POSTs of 10 items every 5 seconds, which we architected into the system. SKU deduplication, character limit handling, and webhook race condition fixes all got built into the foundation. The architecture decision that mattered: handle the failure modes before they fail in production. APIs return errors. Webhooks fire twice. Rate limits hit. The system handles all of it without intervention.

04 / Outcome

60 hours per month returned. Zero intervention required since launch.

The system runs on its own. Product data flows from Shopify to Xero without anyone touching it. The retailer saved 60 hours per month of manual data entry, which is what the discontinued integration would have cost to replace manually. The system has not required intervention since launch.

05 / The Pattern

Custom integration earns its keep when off the shelf disappears.

Most businesses don't think about integration infrastructure until the integration disappears. By then, the cost of doing nothing is hours per month, indefinitely. The math test for custom engineering: does the cost of manual work over the system's lifetime exceed the cost of building the engineered alternative. When the answer is yes, the build pays for itself. Here, it did.