Skip to content
Business Central

Business Central + Shopify Integration: Complete Guide [2026]

The native Shopify Connector in Business Central—available free with any SaaS license since 2022 Wave 2—provides bidirectional real-time sync of products, inventory, orders, and customers, supports unlimited multi-store deployments with independent per-store configuration, and succeeds best when organizations accept its cloud-only architecture and built-in limitations while evaluating third-party solutions for complex B2B, wholesale, or multi-currency requirements.

Last updated: June 19, 202618 min read12 sections
Quick Reference
AvailabilityFree with any BC SaaS license
Introduced2022 Wave 1 (GA May 11, 2022)
Deployment ModelCloud SaaS only (no on-premises support)
Multi-Store SupportUnlimited shops per company
Sync FrequencyNear real-time (seconds to minutes)
Inventory SyncBC to Shopify with location mapping
Price SyncAvailable since April 2023; presentment currency added April 2026
B2B SupportCompany sync, catalogs, and pricing added in Wave 1 2024
Setup ComplexityLow to moderate (1-2 days typical)
Current APIShopify API January 2026 (used in 2026 Wave 1)

Overview: Microsoft’s Native Shopify Connector

The Shopify Connector in Microsoft Dynamics 365 Business Central is a first-party integration built directly into the platform. Unlike third-party integrations that require ISV licensing or middleware platforms, this connector comes free with any Business Central SaaS subscription and provides out-of-the-box integration of core ecommerce workflows: product synchronization, order import, inventory management, customer creation, and payment/fulfillment handling.

Launched in May 2022 (Wave 1) as part of Microsoft’s strategy to position Business Central as a modern cloud ERP for mid-market ecommerce operations, the connector has evolved to include price synchronization, enhanced multi-store support, and deeper inventory location mapping. It represents Microsoft’s commitment to native integrations with leading SaaS platforms without requiring external middleware costs. As of 2026 Wave 1 (April 2026), the connector additionally supports custom Shopify collections, product options via item attributes, product variant image sync, Shopify POS order import, expanded B2B company/catalog features, and presentment-currency handling for Shopify Markets.

This guide covers the architecture, capabilities, configuration, and realistic limitations of the native connector, and explains when you should consider third-party alternatives like i95Dev, Celigo, or eOne Solutions instead.

How the Shopify Connector Works: Architecture & Data Flow

Connector Architecture

The Shopify Connector operates as a bidirectional synchronization engine running within the Business Central SaaS infrastructure. It authenticates to Shopify via OAuth 2.0 (not API keys), connects directly to Shopify’s GraphQL and REST APIs, and uses Business Central’s asynchronous job queue to manage sync operations without blocking user transactions.

Key architectural points:

  • Cloud-only: The connector requires Business Central Online. On-premises Business Central (Business Central Server) does not support the connector.
  • OAuth authentication: Secure token-based authentication that refreshes automatically; no API key storage required.
  • API-based sync: Uses Shopify GraphQL API (preferred) and REST API (fallback) for bidirectional data exchange.
  • Job queue processing: All sync operations run asynchronously through BC’s job queue system, allowing large syncs without UI blocking.
  • Entity-level isolation: Each Shopify store is represented as a "Shopify Shop" entity in Business Central, enabling multi-store independence.

Data Flow: From Shopify to Business Central and Back

Data Type Shopify → BC BC → Shopify Sync Frequency
Products No (BC is source of truth) Yes, including variants, images, descriptions Manual trigger or scheduled
Prices No (BC item card defines price) Yes (since April 2023) Scheduled or manual
Inventory No (BC is source of truth) Yes, per BC location to Shopify location Continuous or scheduled
Orders Yes (auto-import as sales documents) No (read-only from Shopify) Continuous polling (5-30 minute intervals)
Customers Yes (auto-create if not found) No (read-only from Shopify) With each order import
Payments Yes (imported with orders) No (informational) Continuous
Fulfillment No (BC ships, Shopify listens) Yes (BC shipment posts update Shopify) Continuous
Returns/Refunds Yes (Shopify returns pull as BC credit memos) Yes (BC returns sync back to Shopify) Continuous

Key principle: Business Central is the system of record for products, inventory, and pricing. Shopify is the sales channel and customer touchpoint. The connector synchronizes BC truth to Shopify, not the other way around.

Sync Architecture: Single Shop Entity Model

Each Shopify store you connect is represented by one "Shopify Shop" record in Business Central. This record holds:

  • Shopify shop domain and OAuth credentials
  • Default customer template and posting groups
  • Inventory location mapping (BC location → Shopify location)
  • Price list assignment (if using dynamic pricing)
  • Tax rule mapping
  • Sync schedule and frequency settings

This design allows one BC company to manage multiple Shopify stores with completely independent configurations. Store A can map BC Location-A to its inventory, while Store B maps Location-B, with different pricing, payment terms, and fulfillment workflows.

Product Synchronization: Catalog Setup & Syncing

Product Sync Direction & Logic

Products flow Business Central → Shopify only. You create and maintain your product catalog in BC item cards. The connector publishes selected items to your Shopify store.

What Syncs to Shopify

When you trigger a product sync, the connector exports:

  • Item number & name (maps to Shopify product title)
  • Description (maps to product description in HTML format)
  • Item variants (BC dimensions map to Shopify variant options; e.g., Size, Color)
  • Images (from BC item card image field; multiple images supported)
  • Barcode/SKU (maps to Shopify SKU field)
  • Unit price (if price sync enabled; see pricing section below)
  • Base unit of measure (maps to Shopify variant option)

Product Sync Setup: Step-by-Step

To enable product sync:

  1. Open Shopify Connector Setup page in BC
  2. Create a new Shopify Shop record (enter shop domain; OAuth authentication completes automatically in the BC UI when you enable the shop)
  3. Configure Shopify Item Mapping: select which BC items sync to Shopify
  4. Assign product category mappings (optional; maps BC item category to Shopify collection)
  5. Choose sync frequency (manual, scheduled hourly/daily, or real-time on item changes)
  6. Test sync with a small product subset
  7. Run full product sync

Best practice: Start with 10-20 test products to verify variant mapping and image handling before syncing your full catalog.

Image & Description Handling

The connector exports HTML descriptions as-is, so you can include rich formatting, tables, and links. Images are uploaded to Shopify and linked in Shopify’s asset library. Large product catalogs (1000+) items can take 30+ minutes for initial sync due to API rate limiting.

Order Processing: Automatic Order Import & Fulfillment Sync

Order Import Workflow

When a customer completes checkout on Shopify, the order flows automatically to Business Central:

  1. Order created in Shopify (customer pays, receives confirmation)
  2. Connector polls Shopify for new orders (every 5-30 minutes, configurable)
  3. Order imported as BC Sales Order or Invoice (configurable per shop)
  4. Customer matched or created (using customer matching rules; see Customer Management section)
  5. Order lines created (item quantities, extended prices)
  6. Payment posted (Shopify payment method mapped to BC payment method)

Orders appear in BC as complete documents ready for fulfillment—no manual data entry required.

Payment Method Mapping

Shopify Payment BC Equivalent Notes
Shopify Payments (cards) Mapped to BC payment method (e.g., "Credit Card - Shopify") Single entry for all card types
Shop Pay Mapped to BC payment method Treated as credit card payment
PayPal Mapped to "PayPal" BC payment method If configured in Shopify checkout
Apple Pay / Google Pay Mapped to parent payment method (e.g., Credit Card) Wallet payments roll into card category
Manual payment methods Mapped to "Other" or custom payment method Requires custom mapping configuration

Fulfillment Sync: BC Ships, Shopify Updates

When you post a shipment in Business Central, the connector automatically updates the Shopify order:

  • Full fulfillment: When BC shipment qty matches order qty, order marked as fulfilled in Shopify
  • Partial fulfillment: When BC shipment qty < order qty, Shopify order remains in "Partially Fulfilled" status
  • Tracking info: If BC shipment has tracking number, it syncs to Shopify; customer receives tracking email
  • Return fulfillment: BC return shipments sync back to Shopify as return receipts

Real-world flow: Customer orders on Shopify Friday morning → Order imports to BC → You pick and pack → BC posts shipment Friday afternoon → Shopify order marked fulfilled, tracking updates → Customer receives notification with tracking link all automatically.

Customer Management: Auto-Creation & Matching

Customer Matching Rules

When an order is imported from Shopify, the connector attempts to match the Shopify customer to an existing BC customer using these rules (in priority order):

  1. Email match: If Shopify customer email exactly matches BC customer email, use existing customer
  2. Phone match: If email fails, try phone number match (normalized)
  3. Name + address match: If phone fails, fuzzy-match billing name and zip code
  4. No match: Auto-create new customer in BC using customer template

Customer Template & Posting Groups

You configure a default Customer Template in the Shopify Shop setup. When a new customer is auto-created, the template defines:

  • Customer posting group (for GL account mapping)
  • Default payment terms
  • Default currency
  • Default sales pricing type
  • Tax treatment (taxable vs. non-taxable)
  • Credit limit (optional)

This allows Shopify customers to be auto-created with proper GL mapping without manual intervention.

B2B vs. B2C Customer Handling

The connector works equally well for B2C (consumer) and B2B (business) Shopify stores, but with important caveats:

  • B2C stores: Auto-create works perfectly; most small/medium BC companies run B2C Shopify.
  • B2B stores: Auto-create is less ideal because Shopify B2B customer email is often company email (used across multiple orders). Consider disabling auto-create and manually matching B2B customers to BC customer records. Alternatively, use the "customer account mapping" feature to link Shopify B2B accounts to BC customers.
  • Wholesale portals: Shopify B2B storefronts without the native connector support are not directly supported; third-party solutions recommended.

Inventory Synchronization: Bidirectional Stock Sync

Inventory Architecture

Inventory flows Business Central → Shopify. BC is the source of truth for available quantities. The connector continuously publishes BC item availability to Shopify so the storefront always reflects accurate stock levels.

Location Mapping: BC Locations to Shopify

The connector maps BC warehouse locations to Shopify locations:

BC Location Shopify Equivalent Example
Physical warehouse location Shopify location (physical store or fulfillment center) BC "Main Warehouse" → Shopify "Primary Fulfillment Center"
In-transit location (optional) Not synced (internal BC tracking only) BC "In-Transit" → not published to Shopify
Returns location (optional) Not synced BC "Returns" → internal only
Multiple locations Aggregated into Shopify "total available" BC Warehouse A (50 units) + Warehouse B (30 units) = 80 available on Shopify

Stock Buffer & Safety Stock Settings

You can configure inventory buffers to prevent overselling:

  • Reserve quantity: Hold back N units from Shopify visibility (e.g., keep 10 units for backorders, show only 40 of 50 available)
  • Safety stock: Minimum quantity to maintain before item shows as out-of-stock on Shopify
  • Lead time compensation: Add buffer for items with long lead times (e.g., made-to-order products)

Example: Item has 100 units in BC Main Warehouse. You set reserve quantity of 20 (for backorders) and safety stock of 5. Shopify shows 75 available. When stock drops to 5, Shopify marks item as out-of-stock (or shows "limited availability" depending on Shopify theme).

Sync Frequency: Continuous, Scheduled, or Manual

Configure how often inventory updates publish to Shopify:

  • Continuous: Every item change (shipment, receipt, adjustment) immediately syncs. Best for high-velocity stores with frequent stock changes. May hit Shopify API limits on very large catalogs.
  • Scheduled: Every 15/30/60 minutes. Balanced approach; reduces API calls while keeping stock relatively fresh.
  • Manual: Trigger inventory sync only when you request it. Useful for slow-moving inventory or testing.

For most mid-market BC companies, scheduled sync every 30 minutes is optimal.

Multi-Store Support: One Company, Multiple Shopify Shops

Multi-Shop Architecture

The native connector allows you to manage unlimited Shopify shops from a single Business Central company. Each shop is configured independently with its own:

  • OAuth authentication (consent granted per shop via the BC UI; no manual token management)
  • Product selection (shop A syncs items 1-1000, shop B syncs items 1000-2000)
  • Inventory location mapping (shop A uses Location-A, shop B uses Location-B)
  • Pricing rules (shop A uses price list "Retail", shop B uses "Wholesale")
  • Customer template and posting groups
  • Tax rules and currency
  • Order import schedule

Real-World Multi-Shop Examples

Scenario A: Brand Portfolio

Company operates 3 brands (Acme, TechGear, EcoProducts). Each brand has its own Shopify store on separate domains. One BC company maintains all three:

  • Shop A (acmebrands.com): Uses Item Category "Acme", Location-A inventory
  • Shop B (techgear.shop): Uses Item Category "Tech", Location-B inventory
  • Shop C (ecoproducts.store): Uses Item Category "Eco", Location-C inventory
Each shop pulls from the same BC item master but operates independently for pricing, inventory, and customer management.

Scenario B: Regional Storefronts

Company sells across North America with US, Canada, and Mexico Shopify stores:

  • Shop A (us.store.com): USD pricing, US location inventory, US tax rules
  • Shop B (ca.store.com): CAD pricing, Canada location, GST/QST rules
  • Shop C (mx.store.com): MXN pricing, Mexico location, VAT rules
Independent per-shop currency, location mapping, and tax configuration ensures proper GL posting for each region.

Consolidation & Reporting Across Shops

Orders from all shops flow into BC with a shop identifier. You can use BC reporting to consolidate across shops:

  • All Shops Revenue (USD): Sum sales across all shops, converted to base currency
  • Per-Shop P&L: Filter orders by shop source for shop-specific profitability
  • Multi-Shop Inventory Report: View stock levels by location/shop
  • Customer Consolidation: BC keeps customer records separate by shop (or consolidated if you merge matching customers)

Returns & Refunds: Processing Return Orders & Credit Memos

Return Workflow: Shopify to BC

When a customer initiates a return in Shopify (or admin manually marks as return), the connector can pull the return into Business Central:

  1. Return initiated in Shopify (customer uses return portal or admin creates return)
  2. Connector detects return (continuous polling or scheduled sync)
  3. Return imported as BC return order or credit memo (configurable)
  4. Inventory restored in BC (return quantities added back to stock)
  5. Refund processed (depends on Shopify/BC configuration; may require manual refund posting)

Refund Sync

Shopify refunds can flow back to BC as credit memo lines, reducing original invoice amounts and restoring inventory. The refund amount can be automatically calculated based on returned quantities and item prices.

Complex Return Scenarios

  • Partial refund: Customer returns 2 of 5 items. BC creates credit memo for 2 items, inventory restored for 2 items. Remaining 3 items stay invoiced.
  • Full refund: Customer returns all items. Full credit memo created, all inventory restored, customer fully refunded.
  • Return rejection: Return initiated but merchant denies. Manually cancel return in BC; no credit memo created.
  • Damaged goods: Customer returns damaged item. Item counted as return but could be marked as scrap (requires custom BC logic).

Key limitation: The native connector does not deeply integrate with Shopify’s return management system. Complex returns involving restocking fees, condition assessments, or RMA workflows may require manual override or third-party solutions.

Business Central for Professional Services Firms [2026]

Master project accounting, time & expense tracking, and billing models in Business Central for consulting, accounting, law, and engineering firms.

Read More

Limitations: What the Native Connector Does NOT Support

Cloud-Only Constraint

Limitation: The Shopify Connector requires Business Central Online. It does not work with Business Central Server (on-premises).

Impact: If your organization requires on-premises deployment for regulatory or legacy reasons, the native connector is unavailable. You must use a third-party integration platform.

Shopify POS: Supported with Configuration Requirements

Update (as of 2024–2025): The native Shopify Connector does import Shopify POS orders into Business Central, the same way as online store orders. POS orders already fulfilled in Shopify import as Sales Invoices. Key nuances:

  • Customer matching: POS orders often lack a full customer address. The connector requires at least one address to create a BC customer record; for anonymous POS transactions, configure a default customer on a dedicated POS Shopify Shop record in BC.
  • Order archiving: Disable “Automatically archive the order” in Shopify General settings — archived Shopify orders cannot be imported.
  • Device licensing: Some POS configurations (indirect access or multiplexing) may require a Business Central Device license. Review the Dynamics 365 Licensing Guide for your setup.

Impact: POS integration is supported natively but requires intentional setup. For high-volume multi-location retail with complex POS workflows, third-party solutions may still offer deeper automation.

B2B & Wholesale: Enhanced Native Support

Update (2024 Wave 1, GA April 2, 2024): Native B2B support has expanded significantly. The connector now supports:

  • Company sync: Bidirectional synchronization of Shopify B2B companies and contacts with BC customer records; smart matching by tax/registration number.
  • Catalogs & per-company pricing: Assign product catalogs to B2B companies or Shopify Markets; define per-catalog price lists and discounts in BC and sync them to Shopify.
  • Company locations: Map Shopify company locations (B2B) to specific sell-to/bill-to customers in BC. Shopify Plus merchants can connect catalogs to company locations.
  • B2B order import: Orders from Shopify B2B storefronts import using company/location mapping rather than D2C customer matching.

Remaining gaps: Quote management, minimum order quantity enforcement, and complex purchase-order-from-customer workflows remain outside the native connector’s scope. For these requirements, third-party solutions (i95Dev, eOne Solutions) still provide additional depth.

Multi-Currency Complexity

Update (2026 Wave 1, GA April 1, 2026): Multi-currency support has improved. A new “Currency Handling” setting on the Shopify Shop Card lets you select:

  • Shop currency (default): BC creates sales documents in the shop’s base currency, as before.
  • Presentment currency: BC uses the currency and amounts the customer paid during checkout (e.g., via Shopify Markets), reducing reconciliation discrepancies for stores selling in multiple currencies on a single Shopify storefront.

Each shop still operates with one base currency; BC converts to the BC base currency for GL posting. Complex multi-currency pricing across multiple legal entities may still require custom setup or third-party solutions.

Impact: Stores using Shopify Markets for multi-currency selling now have materially improved native support. Highly complex FX scenarios involving multiple legal entities may still warrant third-party solutions (Celigo, etc.).

No Real-Time Inventory Reservation

Limitation: The connector publishes BC inventory to Shopify on a schedule (15-60 minute intervals or continuous). Between syncs, there is a small window where Shopify could sell items that are about to be reserved in BC.

Impact: With very high-velocity sales (1000s of orders per hour), there is a tiny risk of overselling during sync lag. For most mid-market businesses, this is negligible, but high-volume retailers should test.

Limited Discount & Promotion Sync

Limitation: Shopify discounts/coupons are not automatically reflected in BC. Discount amounts are imported with orders but not mapped to BC discount codes or promotional pricing rules.

Impact: You must manually reconcile Shopify discount amounts in BC or use custom logic to re-create promotions in both systems.

No Subscription or Recurring Revenue Support

Limitation: If you use Shopify subscription apps (e.g., Subbly, Bold Subscriptions), those recurring orders are not natively supported. Each subscription cycle generates a new Shopify order, but BC does not understand the recurring nature.

Impact: Subscription businesses need custom reporting/logic to track recurring revenue or should use third-party solutions with subscription support.

Custom Field Sync Limitations

Limitation: The connector syncs standard Shopify fields (product name, description, price, inventory). Custom Shopify metafields are not synced to BC without custom development.

Impact: If you use Shopify custom fields (e.g., "Product Origin", "Lead Time"), that data does not flow to BC automatically. Manual mapping or custom code required.

Third-Party Alternatives: When to Choose a Different Solution

Comparison: Native Connector vs. Third-Party Solutions

Feature / Requirement Native Shopify Connector i95Dev Celigo eOne Solutions
Cost Free (included with BC license) $1K-$3K setup + monthly maintenance $2K-$5K setup + monthly fees $1.5K-$4K setup + monthly support
Cloud/On-Premises Cloud only Cloud & on-premises Cloud & on-premises Cloud & on-premises
B2B/Wholesale Substantial native support (2024 Wave 1): company sync, catalogs, per-catalog pricing, B2B order import Advanced (tiered pricing, minimums) Advanced (quote-to-cash) Advanced (B2B portal, credit accounts)
Multi-Currency Improved (2026 Wave 1): presentment/checkout currency via Shopify Markets; single-entity scenarios well-supported Full (dynamic currency conversion) Full (real-time rates) Full (FX management)
POS Integration Yes (Shopify POS orders import natively, with configuration) Yes (Shopify POS + Clover) Yes (multiple POS systems) Yes (Square, Toast, others)
Custom Fields Limited Yes (metafield sync) Yes (custom field mapping) Yes (flexible mapping)
Subscription Support No Yes (Subbly, Bold, etc.) Yes Yes (subscription apps)
Inventory Real-Time Near real-time (15-60 min scheduled) Real-time (seconds) Real-time (seconds) Real-time (seconds)
Setup Complexity Low (1-2 days) Medium (1-2 weeks) Medium (1-2 weeks) Medium (1-2 weeks)
Support Microsoft support (limited) ISV support (dedicated) Celigo support (24/7 options) eOne support (expert consulting)

Decision Framework: Native vs. Third-Party

Choose the Native Shopify Connector if:

  • You are running Business Central Cloud SaaS
  • You operate pure B2C ecommerce (no B2B/wholesale)
  • Your Shopify store uses standard Shopify features (no custom apps)
  • You do not need real-time inventory sync (30-min delay acceptable)
  • Your organization prefers to minimize ISV costs and use built-in Microsoft solutions
  • You have simple multi-currency needs (separate shops per region)
  • You want quick (1-2 day) setup with minimal configuration

Choose a Third-Party Solution if:

  • You run Business Central Server (on-premises)
  • You operate B2B/wholesale with Shopify B2B storefronts
  • You need real-time inventory synchronization (sub-minute latency)
  • You need advanced Shopify POS automation beyond what the native import supports (e.g., deep multi-location retail workflows, complex POS-specific reporting)
  • You use Shopify subscription apps or custom metafields
  • You need deep integration with other sales channels (Amazon, eBay, WooCommerce)
  • You require dedicated ISV support and custom development
  • You have complex multi-currency or multi-legal-entity requirements

Popular Third-Party Connectors at a Glance

i95Dev (https://www.i95dev.com/): Focused on NAV and BC integrations with strong Shopify support. Best for mid-market with B2B needs. Good for on-premises BC. Support-heavy consulting model.

Celigo (https://www.celigo.com/): iPaaS (Integration Platform as a Service) offering pre-built Shopify-to-BC connectors plus extensive customization. Best for large/complex integrations. Good for multi-channel ecommerce.

eOne Solutions (https://www.eonesolutions.com/): BC partner with deep D365 expertise and SmartConnect Shopify integration. Good for enterprise-grade requirements.

Setup & Configuration: Getting Started with the Native Connector

Prerequisites

Before setting up the connector, ensure you have:

  • Business Central Cloud (SaaS) — at least the Essentials or Premium license tier
  • Shopify Plus or Standard plan — Starter plan supported but not recommended for high-volume stores
  • Admin access to both BC and Shopify
  • Shopify store URL — your store’s myshopify.com domain; the connector authenticates via OAuth in the Business Central UI (no separate private app or API key creation is required)
  • Product master data in BC — items should be set up with descriptions, prices, units of measure
  • Customer master setup — at least one customer template created in BC for auto-created Shopify customers
  • Inventory location mapping — if multi-location, define which BC locations map to Shopify locations

High-Level Setup Steps

Step 1: Prepare Your Shopify Store

  1. Log into your Shopify admin and note your store URL (e.g., mystore.myshopify.com).
  2. Ensure you have Shopify admin access (owner or staff with full permissions) to approve the OAuth consent request Business Central will initiate.
  3. No separate private app or API key creation is required — the connector uses OAuth and Shopify’s consent screen appears automatically when you enable the shop in BC.

Step 2: Configure Shopify Connector in BC

  1. Open Business Central
  2. Search for "Shopify Connector Setup"
  3. Click "+ New" to add a Shopify Shop
  4. Enter your Shopify store URL (e.g., mystore.myshopify.com)
  5. Test connection (BC will validate against Shopify API)
  6. Configure default customer template
  7. Set inventory location mapping (BC location → Shopify location)
  8. Choose sync frequency (schedule or manual)

Step 3: Configure Product Mapping

  1. Select which BC items sync to Shopify (by item category, item number, or all items)
  2. Optionally map BC item categories to Shopify collections
  3. Configure price list (if using dynamic pricing)
  4. Test sync with 5-10 products
  5. Once verified, run full product sync

Step 4: Test Order Import

  1. Place test order on Shopify store
  2. Verify order appears in BC within sync interval
  3. Check customer was created/matched correctly
  4. Verify order lines and prices are accurate

Step 5: Test Fulfillment Sync

  1. Post a shipment in BC for test order
  2. Verify Shopify order marked as fulfilled within minutes
  3. Check customer notification email sent

Step 6: Go Live

  1. Run full product sync (all items)
  2. Enable order import scheduling
  3. Enable inventory sync scheduling
  4. Monitor first week of live orders for issues
  5. Adjust sync frequency and buffers as needed

Typical Timeline

For a mid-market business with 500-2000 products and standard requirements:

  • Days 1-2: Prerequisites, credential setup, connector configuration
  • Day 3: Product sync test, troubleshoot image/description issues
  • Day 4: Full product sync, order import testing
  • Days 5-7: Live testing, monitoring, sync frequency tuning
  • Total: 1 week to full production

For simple stores or experienced teams: 2-3 days. For complex multi-store setups with custom fields: 2-4 weeks.

Best Practices & Troubleshooting

Inventory Management Best Practices

  • Reserve quantities: Always reserve a small buffer (e.g., 5-10 units) to prevent overselling during sync lag
  • Location discipline: Enforce strict location accounting in BC; Shopify sync accuracy depends on location integrity
  • Warehouse transfers: Use BC transfer orders to move stock between locations; this triggers inventory sync and keeps Shopify current
  • Physical cycle counts: Conduct regular cycle counts to reconcile BC inventory with actual stock; discrepancies break sync reliability
  • Receiving discipline: Post purchases and production immediately in BC; delays cause stock visibility gaps

Order Processing Best Practices

  • Daily order review: Check newly imported orders daily for customer matching issues or data anomalies
  • Fulfillment timing: Post shipments in BC immediately when items ship physically; delays cause fulfillment sync lag
  • Return handling: Process Shopify returns promptly; delays slow refund processing and inventory restoration
  • Payment reconciliation: Reconcile Shopify payment deposits against BC invoices monthly to catch posting errors

Common Issues & Fixes

Issue: Orders not importing from Shopify

Check: Connector running? (verify job queue not paused) | OAuth connection healthy? (re-enable the shop in BC to re-authorize if connection errors appear) | Sync schedule enabled? (check Shopify Shop record) | BC user has permission to create sales orders? (verify role setup)

Issue: Inventory not syncing to Shopify

Check: Inventory sync enabled? | BC items have quantities? | Location mapping correct? (verify BC location exists in Shopify locations setup) | API quota exceeded? (Shopify rate limits may pause sync temporarily)

Issue: Customer duplicates or matching failures

Check: Customer template configured? | Email addresses in Shopify valid? | BC customer email case-sensitivity issue? (BC email matching is case-insensitive, but verify no hidden spaces) | Manual override: disable auto-create and manually match problem customers

Issue: Price sync shows wrong amounts in Shopify

Check: Price list assigned to shop? | Unit price field populated in BC items? | Price includes/excludes tax correctly? | Currency conversion accurate? (if multi-currency) | Sync price sync scheduled/manual?

Key Takeaways

  • Native connector is free, built-in, and cloud-only: Choose the native option for cloud SaaS BC with standard B2C ecommerce needs and accept its limitations.
  • Real-time bidirectional sync: Products, inventory, orders, and fulfillment flow automatically between BC and Shopify without manual intervention once configured.
  • Multi-store capability unlocks brand/region strategies: One BC company can manage unlimited Shopify shops with independent pricing, inventory, and customer rules.
  • Business Central is source of truth: Products, inventory, and pricing are created in BC and published to Shopify, not synced from Shopify backwards.
  • Cloud-only; POS and B2B now natively supported: No on-premises support remains the primary constraint. Shopify POS orders import natively (with setup). Substantial B2B capabilities were added in 2024 Wave 1. Evaluate third-party solutions only for on-premises, subscription apps, deep POS automation, or complex multi-entity requirements.
  • Setup is fast but monitoring is ongoing: Initial setup 1-2 weeks; long-term success requires discipline in inventory management, order processing, and sync monitoring.
  • Third-party alternatives exist for complex scenarios: i95Dev, Celigo, and eOne Solutions provide deeper integrations, on-premises support, and specialized B2B/POS features at higher cost.

Native Shopify Connector vs. Third-Party Integration Solutions

FeatureNative Shopify ConnectorThird-Party Solution (i95Dev, Celigo, eOne)Winner
CostFree (included with BC license)$1K-$5K setup + $300-$2K monthly
Cloud vs. On-PremisesCloud SaaS onlyCloud and on-premises
Setup Time3-7 days typical2-4 weeks with consulting
B2B/Wholesale SupportSubstantial native (2024+): company sync, catalogs, per-catalog pricing, B2B orders; gaps remain for quotes/MOQsAdvanced (quotes, tiered pricing, minimums)
Real-Time Inventory SyncNo (scheduled 15-60 min)Yes (sub-minute)
Shopify POS IntegrationYes (native import with configuration; same flow as online orders)Yes (plus multi-POS systems)
Custom Metafield SyncLimitedFull (any custom field)
Subscription/Recurring RevenueNoYes (subscription apps supported)
Multi-Currency HandlingImproved (2026 Wave 1): presentment currency via Shopify Markets; complex multi-entity may still need custom setupAdvanced (real-time conversion)
Multi-Channel EcommerceShopify onlyMultiple channels (Amazon, eBay, WooCommerce)
Dedicated ISV SupportMicrosoft support (limited for connectors)Expert partner support
Ease of Use (Non-Technical)High (few configuration options)Medium (extensive customization options)
Native Shopify Connector4|Third-Party Solution8

Frequently Asked Questions

1Is the Shopify Connector included with Business Central, or is it an extra cost?

The Shopify Connector is included free with any Business Central SaaS license (Essentials or Premium tier). No additional ISV licensing or monthly fees apply. You only pay for Shopify’s service on the Shopify side.

2Does the connector work with Business Central on-premises (Server)?

No. The Shopify Connector requires Business Central Cloud (SaaS). It does not support on-premises Business Central Server deployments. If you run on-premises BC, you must use a third-party integration platform.

3Can I sync Shopify POS sales to Business Central automatically?

Yes, as of 2024–2025. The native connector imports Shopify POS orders into Business Central the same way as online store orders (they arrive as Sales Invoices since POS orders are typically already fulfilled). However, POS requires specific setup: you may need a dedicated BC shop record with a default customer for anonymous POS transactions, and you must disable auto-archiving in Shopify’s General settings.

4Can I use the connector with Shopify B2B storefronts?

Yes, with substantial native support added in 2024 Wave 1 (GA April 2, 2024). The connector now supports bidirectional company sync, per-catalog pricing for B2B companies and Shopify Markets, company location mapping, and B2B order import. Gaps remain for quote management and minimum order quantities; large-scale wholesale operations with these requirements should evaluate third-party solutions.

5How quickly does inventory sync from Business Central to Shopify?

The native connector supports scheduled sync (every 15–60 minutes) or continuous sync (within minutes of inventory changes). True real-time (sub-minute) sync is not available with the native connector. Third-party solutions offer real-time inventory sync.

6Can I manage multiple Shopify stores from one Business Central company?

Yes, absolutely. The connector supports unlimited Shopify shops per BC company. Each shop is configured independently with its own inventory locations, pricing rules, customer templates, and sync settings.

7Does the connector automatically create customers in Business Central when orders are imported?

Yes. By default, the connector matches incoming Shopify customers to BC customers by email, phone, or address. If no match is found, a new customer is auto-created using the customer template you define in the Shopify Shop setup.

8How are Shopify discounts and coupons reflected in Business Central?

Discount amounts are imported with orders and shown on BC sales documents, but Shopify discounts are not automatically mapped to BC discount codes. You must manually reconcile or use custom business logic to re-create promotional pricing in both systems.

9Is price synchronization from Business Central to Shopify supported?

Yes, since April 2023. You can enable price sync so BC unit prices publish to Shopify. As of 2026 Wave 1 (April 2026), unit cost is also synced alongside price and compare-at-price. This is optional; if disabled, you manage Shopify prices independently.

10Can the connector handle multi-currency transactions (e.g., one store selling in USD and CAD)?

Yes, with improved support as of 2026 Wave 1 (GA April 1, 2026). A new “Currency Handling” setting on the Shopify Shop Card lets you choose “Presentment currency” so BC creates sales documents using the currency the customer paid in (via Shopify Markets), rather than the shop default. This significantly reduces reconciliation discrepancies. Complex multi-currency scenarios across multiple legal entities may still require custom setup.

11What happens if an order is placed in Shopify while Business Central inventory sync is paused?

Shopify will allow the order even if inventory sync is paused. BC won’t see updated inventory on Shopify, so overselling is possible. Resume inventory sync immediately to prevent backorders. For high-volume operations, use continuous or frequent scheduled sync to minimize this window.

12How long does it take to set up the Shopify Connector for a typical mid-market business?

For a straightforward setup (500–2000 products, single or dual shops, standard configuration): 3–7 days. This includes OAuth credential setup, product sync, order import testing, and live monitoring. Complex multi-shop or multi-currency setups may take 2–4 weeks.

Previous
Dynamics 365 Business Central Pricing Guide [2026]
Next
Dynamics 365 Business Central: The Complete Guide [2026]

Related Reading