+1 480 485 7373
Microsoft Teams
Business Central Shopify integration for stores that have outgrown a simple setup.
A Business Central Shopify integration starts with Microsoft's free connector, and for many single-brand stores that is where it should end. This page covers everything around it: several storefronts in different currencies, wholesale buyers on Shopify B2B, and Amazon or Walmart orders arriving through Shopify. It also covers metafields that drive business rules and payouts finance can tie to the bank. If you only need the standard app configured, the sync table and shop card decisions below cover that part too.
Where the standard app stops and integration design begins
Microsoft's connector is an AL app that sits inside Business Central and runs on job queue entries. It follows Microsoft's own mapping of Shopify objects to Business Central records. That is a strength: Microsoft updates it with every release, and it costs nothing extra. It also means the connector decides the shape of the data, so your business has to fit it.
Trouble appears when the shape does not fit. A brand with a US store, a Canadian store and a wholesale store may need different price sources, stock pools and customer rules for each. A company selling bundles may need one Shopify product to explode into several components for picking. Finance may need each payout split by store, gateway and fee type. None of that is exotic. Still, each one is a design decision rather than a checkbox.
What the Business Central Shopify connector syncs, and in which direction
Business Central Shopify connector setup: decisions on the shop card
Who owns products
If Business Central is the source, you maintain descriptions, images and prices there. If Shopify is, the import creates items from Shopify products.
Customer handling
Retail stores often post to a single default web customer. Wholesale stores usually create or match a real customer by email or phone.
Order automation
The connector can import orders on a schedule and convert them to sales documents on its own. Or it can hold them for someone to release.
Shopify location mapping in Business Central
Each Shopify location maps to one or more Business Central locations. That mapping decides where the connector counts available stock.
Tax treatment
Shopify calculates tax at checkout. Business Central must accept that amount rather than recalculate it, which needs deliberate tax area setup.
Fees and payouts
Shopify Payments fees and payout deposits need G/L accounts, so bank reconciliation matches real deposits rather than gross sales.
Fulfillment and tracking
Posting a shipment can create the fulfillment in Shopify with its tracking number. So you map shipping agents to the carriers customers see.
Returns and refunds
The connector can import refunds for review or turn them into credit memos on its own. You choose whether returned goods go back to a sellable location.
Three integration patterns, and when each one fits
Extend Microsoft's connector
Keep the standard app and add an AL extension that subscribes to its events.
- ✓Custom mapping rules for SKUs, bundles or customer matching
- ✓Extra fields copied from metafields onto sales documents
- ✓Stays inside Business Central, with no extra platform to run
Middleware or iPaaS
An integration platform sits between Shopify, Business Central and your other systems.
- ✓Suits a 3PL, a marketplace hub and a CRM all in the loop
- ✓Central monitoring, retries and alerting
- ✓Adds a subscription and a flow owner on your side
Custom API integration
Purpose-built code calling Shopify's Admin API and Business Central's APIs directly.
- ✓Full control over timing, batching and transformation
- ✓Handles logic no connector models, such as allocation rules
- ✓You own the code and its upkeep as both APIs change
Design choices for multiple stores and wholesale buyers
Do you need more than a configured connector?
- ✓Marketplace orders from Amazon, eBay or Walmart flow into Shopify first and must post with their own fees
- ✓Bundles or kits sold as one Shopify product but picked as separate components
- ✓A third-party logistics provider ships some orders and your own warehouse ships others
- ✓Subscriptions or preorders that should not reserve stock the moment they are placed
- ✓Order volumes in sales peaks that need batching and careful retry handling
- ✓Several gateways such as Shopify Payments, PayPal and buy-now-pay-later providers settling separately
Designing payout reconciliation finance can sign off
- 1
Map every money movement
List each gateway, what it deposits and how often. Then list what it deducts before the money lands: processing fees, refunds, chargebacks, adjustments and reserves.
- 2
Post a clearing account per gateway
Web sales post to a gateway clearing account, not straight to the bank. That way both gross revenue and net deposits stay visible.
- 3
Book fees at their true amount
Each payout's fees and adjustments go to their own G/L accounts, split by store where management reporting needs it.
- 4
Match the deposit
The net payout clears against the bank statement line in bank reconciliation. When everything balances, the clearing account sits at zero.
- 5
Chase what is left
Anything left in clearing after a payout cycle is a real exception. It may be a missed refund, a disputed charge or an order that never imported.
What do merchants ask about a Shopify and Business Central integration?
Should we replace Microsoft's Shopify connector with a third-party app?
Usually not, because extending the standard connector keeps you on a base Microsoft maintains. A third-party connector or iPaaS makes sense when you sell through channels the standard app does not cover. It also fits when a platform already runs your other integrations. We test the gaps against your order data before we suggest a switch.
Can Business Central handle several Shopify stores?
Yes, several stores can connect to one Business Central company, each with its own settings. The design work is deciding how prices, stock locations, customers and G/L postings differ between them. Stores that belong to separate legal entities normally connect to separate companies instead.
How do marketplace orders sold through Shopify reach Business Central?
They arrive as Shopify orders, so they follow the same import path as web orders. The extra work is finding the channel, usually from order tags or source fields. Then fees, customers and revenue accounts post per marketplace. Without that, marketplace margin disappears into web sales.
Is a custom API integration worth it for Shopify?
Only when your rules are specific enough that no connector models them, such as allocation across warehouses or complex bundles. Custom code gives full control but brings upkeep as Shopify and Business Central release changes. The scoping call is where we weigh that against extending the standard app.
Product data, stock and failed orders in the Shopify integration
Where should product data be mastered?
Operational data such as item numbers, costs, weights and stock belongs in Business Central. Marketing content usually belongs in Shopify. Splitting ownership by field, not by record, stops the two systems overwriting each other. We write that field list down before anyone switches on a sync.
How often does stock update in Shopify?
During Business Central Shopify connector setup, you schedule a job queue entry that runs the stock sync. You can also trigger it by hand. Match the frequency to how fast stock moves and how much overselling risk you accept. The shop setting decides whether available quantity comes from projected available balance or free inventory.
Can we use it with Shopify POS in our retail store?
Point of sale orders flow into Business Central alongside web orders. You can map them to their own location. Retail teams usually post them as invoices, not orders, since the goods left at the counter. Payment and cash reconciliation needs its own setup, which we plan with finance.
What happens if an order fails to import?
The order stays in the Shopify order list in Business Central with an error. It names what did not match, such as an unknown item or missing account. Someone fixes the mapping and converts it again. We set up a simple daily check so nothing waits unnoticed.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.