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

Fernhill Home: engagement facts
FieldDetail
ClientFernhill Home, 140 employees
IndustryHomeware ecommerce
Client and delivery locationsBath, UK / Lisbon
SystemsShopify Plus ↔ Business Central 23
Roles1 Integration engineer (full-time)
Engagement dates19 Feb – 26 Jul 2024
Overlap7 hours GMT
Reporting lineClient 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

Fernhill Home: decision rights
DecisionOwner
Integration scopeClient Head of Ecommerce
Financial reconciliationClient Finance Manager
Failure recovery designClient IT lead reviews
Release authorisationHead 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.

Fernhill Home: work delivered
RoleAssignmentAccepted outputReviewerApprover
Integration engineerOrder, inventory and returns flowsOrder sync, inventory sync, returns sync; 34 reconciliation testsClient IT leadFinance Manager
Integration engineerFailure recoveryRetry and replay framework; 11 failure scenarios testedClient IT leadHead 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.

Fernhill Home: outcomes
MeasureBaselineResultWindowSource
Order reconciliationManual, 1-day lagAutomated, same-day, 30 consecutive days matchedJul 2024Finance reconciliation workbook
Failed-message replay—11 of 11 scenarios recoveredJun 2024Client test record
Manual re-entry hours per week221.560 days post-launchClient operations log
Inventory sync accuracy—99.8%30 daysClient inventory report
First accepted integration—12 business daysOnboardingClient ticket record

Client perspective

“Our Finance Manager signs reconciliation daily. Thirty days matched is the proof.”

Lucy Hartwell, Head of Ecommerce

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.