+1 480 485 7373
Microsoft Teams
What syncs, and in which direction
Decisions to make on the Shopify shop card
Who owns products
If Business Central is the source, descriptions, images and prices are maintained there. If Shopify is, items are created from Shopify products on import.
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
Orders can be imported on a schedule and converted to sales documents automatically, or held for someone to release.
Location mapping
Each Shopify location maps to one or more Business Central locations, which decides where available stock is counted from.
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.
The order flow once everything is running
- 1
Shopper checks out
The order, payment and tax are captured in Shopify.
- 2
Import job runs
A job queue entry pulls new orders into Business Central's Shopify order list, with customer, lines, shipping and discounts.
- 3
Sales document created
Matched orders become sales orders or invoices automatically; unmatched ones wait with a clear error for someone to fix.
- 4
Warehouse ships
Your team picks and ships in Business Central; the posted shipment sends tracking back to Shopify and the customer is notified.
- 5
Money reconciled
Payouts import with their fees, and finance matches them to the bank deposit.
Where connector projects stall
- ✓SKUs in Shopify that do not match item numbers or item references, so orders fail to map.
- ✓Variants built one way in Shopify and another in Business Central, for example size and color as separate items on one side and variants on the other.
- ✓Shipping charges and discounts with no G/L account assigned, so imported orders stop at conversion.
- ✓Gift cards treated as revenue at sale instead of a liability until redeemed.
- ✓Stock sync counting every location, including quarantine or returns bins, and overselling as a result.
- ✓Nobody watching the error queue during the first weeks, so orders sit unconverted.
When the standard connector is not enough
The connector covers a single-brand Shopify store selling stock items very well, and handles several shops and Shopify B2B companies too. It is less suited to marketplaces beyond Shopify, subscription billing, heavy product bundling logic, or stores that need custom metafields driving business rules.
Because it is an AL app from Microsoft, it publishes events that an extension can subscribe to. That lets us add a mapping rule or a custom field without replacing the connector. If you sell on Amazon, eBay or several storefronts, a multichannel connector from AppSource may be the better fit, and we will tell you so.
Shopify connector questions
Do we need a third-party connector to link Shopify and Business Central?
Usually not. Microsoft's own connector covers products, stock, prices, customers, orders, refunds, payouts and shipments. Third-party connectors earn their place when you sell across several marketplaces or need logic the standard app does not offer. We check your channels before recommending either.
How often does stock update in Shopify?
Stock sync runs through a job queue entry that you schedule, and it can also be triggered manually. Choose a frequency that matches how fast your stock moves and how much risk of overselling you accept. Available quantity can be calculated from projected available balance or free inventory, depending on the shop setting.
Can we use it with Shopify POS in our retail store?
Point of sale orders flow into Business Central alongside web orders, and they can be mapped to their own location. Retail teams usually want them posted as invoices rather than orders, since the goods left the store at the counter. Payment and cash reconciliation needs its own setup, which we plan with finance.
Will it handle our B2B customers with their own price lists?
Shopify companies, used for B2B on Shopify plans that support them, can be synced to Business Central customers, and catalogs can take prices from Business Central. Customer-specific terms and credit limits then apply in Business Central. We test a few real B2B accounts end to end before switching on the rest.
What happens if an order fails to import?
The order stays in the Shopify order list in Business Central with an error explaining 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.