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: March 15, 202618 min read12 sections
Quick Reference
Availability
Free with any BC SaaS license
Introduced
2022 Wave 2 (April 2022)
Deployment Model
Cloud SaaS only (no on-premises support)
Multi-Store Support
Unlimited shops per company
Sync Frequency
Near real-time (seconds to minutes)
Inventory Sync
Bidirectional with location mapping
Price Sync
Available since April 2023 update
Setup Complexity
Low to moderate (1-2 days typical)

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 April 2022 (Wave 2) 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.

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 (shop domain, OAuth token from Shopify)
  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 token and API credentials
  • 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.

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.

No Shopify POS / In-Store Sales Sync

Limitation: The connector syncs only Shopify online store orders, not Shopify POS transactions (in-store/physical point-of-sale).

Impact: If you operate physical retail locations with Shopify POS, those sales do not automatically import into BC. Workaround: Use Shopify’s POS sync to Shopify online orders manually, or use third-party solutions that capture POS data.

Limited B2B & Wholesale Features

Limitation: The connector supports basic B2B order import but does not deeply integrate with:

  • Shopify B2B storefronts (quote management, custom pricing per company)
  • Wholesale portal features (tiered pricing, minimum order quantities)
  • Company account hierarchies (parent/subsidiary relationships)
  • Purchase orders (BC PO purchase orders from B2B customers)

Impact: B2B/wholesale operations should evaluate third-party connectors (i95Dev, eOne Solutions) that have deeper B2B feature support.

Multi-Currency Complexity

Limitation: Multi-currency scenarios are possible but complex:

  • Each shop can use one currency
  • BC automatically converts shop currency to BC base currency for posting
  • However, if a single Shopify store accepts multiple currencies (e.g., USD + CAD), the connector cannot differentiate; all orders are treated as shop default currency
  • Complex multi-currency pricing rules require custom setup

Impact: Global organizations with complex multi-currency requirements should test thoroughly before rollout or consider third-party solutions with deeper multi-currency support (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 Basic Advanced (tiered pricing, minimums) Advanced (quote-to-cash) Advanced (B2B portal, credit accounts)
Multi-Currency Limited (manual mapping) Full (dynamic currency conversion) Full (real-time rates) Full (FX management)
POS Integration No 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 use Shopify POS or other Shopify sales channels (not just online store)
  • 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://eone.nl/): BC partner with deep D365 expertise and Shopify connector. Strong in EMEA region. 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 private app credentials — you’ll generate API key and access token from Shopify admin
  • 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: Create Shopify Private App & Get Credentials

  1. Log into Shopify admin dashboard
  2. Go to Settings → Apps and Integrations → Develop Apps
  3. Create a new app for Business Central
  4. Grant API scopes: read/write products, read/write orders, read/write inventory, read customers, read fulfillment
  5. Generate API credentials (API key, access token, shop domain)
  6. Note the shop domain (e.g., "mystore.myshopify.com")

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 shop domain and API token
  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) | API token valid? (regenerate if expired) | 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, no POS, no B2B depth: Understand the constraints: no on-premises, no Shopify POS support, limited B2B features. Evaluate third-party solutions if these are critical.
  • 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 monthlyNative Shopify Connector
Cloud vs. On-PremisesCloud SaaS onlyCloud and on-premisesThird-Party Solution (i95Dev, Celigo, eOne)
Setup Time3-7 days typical2-4 weeks with consultingNative Shopify Connector
B2B/Wholesale SupportBasic (standard orders only)Advanced (quotes, tiered pricing, minimums)Third-Party Solution (i95Dev, Celigo, eOne)
Real-Time Inventory SyncNo (scheduled 15-60 min)Yes (sub-minute)Third-Party Solution (i95Dev, Celigo, eOne)
Shopify POS IntegrationNoYesThird-Party Solution (i95Dev, Celigo, eOne)
Custom Metafield SyncLimitedFull (any custom field)Third-Party Solution (i95Dev, Celigo, eOne)
Subscription/Recurring RevenueNoYes (subscription apps supported)Third-Party Solution (i95Dev, Celigo, eOne)
Multi-Currency HandlingLimited (manual mapping)Advanced (real-time conversion)Third-Party Solution (i95Dev, Celigo, eOne)
Multi-Channel EcommerceShopify onlyMultiple channels (Amazon, eBay, WooCommerce)Third-Party Solution (i95Dev, Celigo, eOne)
Dedicated ISV SupportMicrosoft support (limited for connectors)Expert partner supportThird-Party Solution (i95Dev, Celigo, eOne)
Ease of Use (Non-Technical)High (few configuration options)Medium (extensive customization options)Native Shopify Connector

Frequently Asked Questions

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&rsquo;s service on the Shopify side.

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.

No. The native connector syncs only Shopify online store orders, not Shopify POS (point-of-sale) transactions. If you operate physical retail with Shopify POS, those in-store sales must be imported manually or through a third-party solution.

Yes, basic B2B order import works. However, the connector does not deeply support Shopify B2B features like quote management, tiered pricing per company, or company account hierarchies. For advanced B2B, evaluate third-party solutions like i95Dev or eOne Solutions.

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.

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.

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.

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.

Yes, since April 2023. You can enable price sync so BC unit prices publish to Shopify, keeping your online storefront pricing in sync with your cost/pricing structure. This is optional; if disabled, you manage Shopify prices independently.

The connector handles multi-currency at the shop level (each shop can use one currency). However, if a single Shopify store accepts multiple currencies (via Shopify Markets), the connector treats all orders as the shop&rsquo;s default currency. Complex multi-currency scenarios may require third-party solutions or custom development.

Shopify will allow the order even if inventory sync is paused. BC won&rsquo;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.

For a straightforward setup (500-2000 products, single or dual shops, standard configuration): 3-7 days. This includes 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 for Distribution &amp; Wholesale: Complete Guide [2026]
Next
Business Central Extensions &amp; AppSource: Complete Guide [2026]

Related Reading

From the Blog & Resources