Customer case study
Shopify Plus and Business Central Integration Staffing for Fernhill Home
Engagement summary
Fernhill Home added one full-time integration engineer from MS Dynamics Guys to its ecommerce team from February to July 2024. The engineer connected Shopify Plus and Business Central 23 for orders, inventory, returns and payouts, with acceptance on 19 July. Fernhill's finance workbook records 30 consecutive days of matching order totals, tax and discounts.
Engagement Facts
| Field | Detail |
|---|---|
| Client | Fernhill Home, 140 employees |
| Industry | Homeware ecommerce |
| Client and delivery locations | Bath, UK / Lisbon |
| Systems | Shopify Plus ↔ Business Central 23 |
| Roles | 1 Integration engineer (full-time) |
| Engagement dates | 19 Feb – 26 Jul 2024 |
| Overlap | 7 hours GMT |
| Reporting line | Client Head of Ecommerce |
Why the Client Added Capacity
Fernhill's ecommerce team was re-entering Shopify orders in Business Central and reconciling them a day later. The team knew Shopify and needed Business Central integration expertise. The Head of Ecommerce owned scope and release decisions, and Finance required a daily reconciliation.
Decision Rights
| Decision | Owner |
|---|---|
| Integration scope | Client Head of Ecommerce |
| Financial reconciliation | Client Finance Manager |
| Failure recovery design | Client IT lead reviews |
| Release authorisation | Head of Ecommerce |
Work Delivered
The engineer built order, inventory and return flows and carried out 34 reconciliation tests. They also built retry and replay handling for failed messages and tested it against 11 failure scenarios. Fernhill's IT lead reviewed the work, and the Finance Manager accepted the reconciliations.
| Role | Assignment | Accepted output | Reviewer | Approver |
|---|---|---|---|---|
| Integration engineer | Order, inventory and returns flows | Order sync, inventory sync, returns sync; 34 reconciliation tests | Client IT lead | Finance Manager |
| Integration engineer | Failure recovery | Retry and replay framework; 11 failure scenarios tested | Client IT lead | Head of Ecommerce |
Outcomes
Fernhill's operations log shows manual order-entry work fell from 22 to 1.5 hours a week in the 60 days after launch. The client's test record shows that all 11 failed-message scenarios recovered.
| Measure | Baseline | Result | Window | Source |
|---|---|---|---|---|
| Order reconciliation | Manual, 1-day lag | Automated, same-day, 30 consecutive days matched | Jul 2024 | Finance reconciliation workbook |
| Failed-message replay | — | 11 of 11 scenarios recovered | Jun 2024 | Client test record |
| Manual re-entry hours per week | 22 | 1.5 | 60 days post-launch | Client operations log |
| Inventory sync accuracy | — | 99.8% | 30 days | Client inventory report |
| First accepted integration | — | 12 business days | Onboarding | Client ticket record |
Client perspective
“Our Finance Manager signs reconciliation daily. Thirty days matched is the proof.”
Your next step
Discuss the capacity your team needs
Share the application, workstream and specialist allocation you need. Your team can define its own backlog, acceptance and release responsibilities.