Skip to main content
Case Study

How a Dubai Furniture Manufacturer Unified Odoo 19, Shopify and Power BI

ECOSIRE delivered an Odoo 19 implementation with a Shopify connector that keeps orders in 1:1 sync and auto-confirms them so manufacturing orders are produced automatically. The accounting backlog was worked down by correcting bank statement chains, eliminating bank-versus-card double bookings, and documenting a self-serve reconciliation procedure the in-house team can follow. A Power BI connector joins live Odoo data on a clean star schema, retiring the hand-maintained Excel master in favour of dashboards built directly on the system of record.

Key Facts

Location
United Arab Emirates
Industry
Manufacturing
Company Size
SME manufacturer + retailer
Implementation
Implementation complete + ongoing support
Apps Used
Odoo 19ManufacturingSalesShopify ConnectorPower BI ConnectorAccounting
Software Replaced
Disconnected Shopify admin + a hand-maintained Excel master

The Challenges

Shopify Orders Not Reaching Production

Online orders synced into Odoo but had stopped auto-confirming, so manufacturing orders were never raised. Drafts piled up and production fell behind the actual order book.

Reconciliation Backlog

Bank and card transactions were being double-booked, and payment-gateway credits posted with no residual to match against, leaving the ledgers out of step with the banks for months.

Reporting Trapped in Excel

Management ran the business off a manually updated Excel master rather than live system data, so every report was stale and reconciling it against Odoo was a recurring chore.

The Results

1:1 synced
Shopify Orders
Orders auto-confirm and raise manufacturing orders automatically, clearing the draft backlog.
Live Power BI
Reporting
Dashboards run on live Odoo data instead of a hand-maintained Excel master.
Self-serve
Reconciliation
Bank-vs-card double bookings resolved and a repeatable reconciliation procedure handed to the team.
Odoo + Shopify + BI
Systems
Three previously separate tools now share one system of record.

What's Next

Extending Power BI coverage and tightening payment-gateway reconciliation so month-end close runs entirely on live data.

Ready for Similar Results?

Join businesses across the region that have transformed their operations with ECOSIRE. Get a free consultation today.