+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, runs on job queue entries and follows Microsoft's own mapping of Shopify objects to Business Central records. That is a strength: it is maintained with every release and costs nothing extra. It also means the connector decides the shape of the data, and 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. A finance team may need each payout split by store, gateway and fee type. None of that is exotic, but 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
Signs 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, how often, and what it deducts before the money lands: processing fees, refunds, chargebacks, adjustments and reserves.
- 2
Post a clearing account per gateway
Web sales post against a gateway clearing account rather than straight to the bank, so gross revenue and net deposits are both 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, leaving the clearing account at zero when everything balances.
- 5
Chase what is left
Anything sitting in clearing after a payout cycle is a real exception: a missed refund, a disputed charge or an order that never imported.
Shopify and Business Central integration questions
Should we replace Microsoft's Shopify connector with a third-party app?
Usually not, because extending the standard connector keeps you on a Microsoft-maintained base. A third-party connector or iPaaS makes sense when you also sell through channels the standard app does not cover, or when a platform already runs your other integrations. We test the specific gaps against your order data before recommending 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 are normally connected 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 identifying the channel, usually from order tags or source fields, so that fees, customers and revenue accounts are posted 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 ongoing 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, while marketing content usually belongs in Shopify. Splitting ownership by field, not by record, avoids the two systems overwriting each other. We write that field list down before any sync is switched on.
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.