ECOMMERCE · · 10 min read

How to integrate Shopify with Microsoft Business Central in 2026.

Most off-the-shelf Shopify-to-Business-Central plugins break at scale. Here's the integration architecture we use for Gulf retailers running both at the same time.

NOVASOFT · ECOMMERCE

Most off-the-shelf Shopify-to-Business-Central plugins break at scale. Here's the integration architecture we use for Gulf retailers running both at the same time.

Why off-the-shelf plugins break

Most Shopify-to-BC plugins solve the easy path: catalogue sync and order creation. They fail at the hard things: real-time inventory accuracy across stores, partial fulfilment, returns, multi-currency, refund posting, gift cards, and the moment when Shopify and BC disagree about a stock level.

The plugins that work depend on a robust middleware pattern (event-driven, retryable) and proper SKU master-data hygiene on both sides.

The architecture pattern that works

One Source of Truth for each domain:

  • Inventory: master in BC, replicated to Shopify in near-real-time
  • Catalogue: master in BC (or PIM), pushed to Shopify on publish
  • Customers: master in Shopify for online accounts; mirrored to BC for billing
  • Orders: master in Shopify until fulfilment, then BC takes ownership
  • Pricing & promotions: master in BC, replicated to Shopify (especially for B2B)

Step 1 — Set up the BC sandbox tenant + Shopify Admin API credentials

Create a BC sandbox copy of production. In Shopify Admin, create a custom app with Admin API permissions: read products / write products / read inventory / write inventory / read orders / write orders / read customers.

Step 2 — Choose your connector

Three real options:

  1. Microsoft's Shopify Connector for BC (free, AppSource) — good for simple deployments
  2. Novasoft eCommerce middleware — handles multi-store, multi-currency, B2B pricing, gift cards
  3. Custom on Azure Logic Apps / Power Automate — for unique business logic

Step 3 — Map SKU master data

Most integration failures trace to SKU mismatch. Ensure:

  • Every BC item has a SKU that matches Shopify variant SKU exactly
  • UPC / barcode populated on both sides
  • Item Category in BC maps to Shopify Collection
  • Item attributes (size, colour) map to Shopify variant options

Step 4 — Configure inventory sync windows

Real-time sync is the goal but every sync has cost. Set:

  • Inventory level: push from BC → Shopify every 5 minutes (or on event)
  • Order creation: Shopify → BC immediately on order paid
  • Catalogue change: BC → Shopify on publish event
  • Customer profile: bidirectional reconciliation nightly

Step 5 — Test edge cases

The cases that bring down naive integrations:

  • Out-of-stock fulfilment (Shopify oversells when BC stock is at zero)
  • Partial fulfilment (BC ships 2 of 3 items; Shopify shows partial status)
  • Returns (Shopify customer returns; BC needs credit memo and stock-back)
  • Currency rate drift (Shopify caches rates daily; BC posts at point-in-time)
  • Gift cards (Shopify-only by default; bridge to BC GL)

Frequently asked questions

Can we use Shopify Markets with Business Central?

Yes. Shopify Markets exposes multiple currencies and regional storefronts; the integration replicates each market's inventory and orders into BC under separate location codes.

What about Shopify Plus?

Shopify Plus features (Flow, Scripts, Functions) integrate cleanly with BC. The B2B Catalogue feature in Plus is particularly strong with BC's price-list management.

How do we handle gift cards?

Two layers: Shopify manages issuance and redemption online; the BC GL receives a journal entry per gift-card movement so financial reporting stays accurate.

Can we connect multiple Shopify stores to one BC tenant?

Yes. Each Shopify store maps to a BC location code; consolidated reporting at chain level happens in BC.

What about Magento (Adobe Commerce)?

Same architecture. LS Central has an official Adobe Commerce connector for retail/F&B chains; BC supports both.

Do you offer a fixed-fee Shopify+BC integration?

Yes. Discovery + scope + fixed fee. Typical AED 60k–150k depending on multi-store, multi-currency and customisation depth.

Where to go next

Read the full overview of Business Central + eCommerce. For a deeper dive into related capability, see LS Central for retail. When you're ready to talk specifics, book a 30-minute call with a Novasoft consultant.

Link copied to clipboard
Chat with us