+1 480 485 7373
Microsoft Teams
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.
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.
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.
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.