+1 480 485 7373
Microsoft Teams
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.
The order flow once the Business Central Shopify connector runs
- 1
Shopper checks out
Shopify captures the order, payment and tax.
- 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 then sends tracking back to Shopify, and the customer gets a notice.
- 5
Money reconciled
Payouts import with their fees, and finance matches them to the bank deposit.
Where Business Central Shopify connector setup stalls
- ✓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 are 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 Business Central Shopify connector is not enough
The connector covers a single-brand Shopify store selling stock items very well. It handles several shops and Shopify B2B companies too. It fits less well with marketplaces beyond Shopify, subscription billing or heavy product bundling logic. The same goes for 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 fit better. If so, we will tell you.
Business Central 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. They also help when you need logic the standard app lacks. We check your channels before recommending either.
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.
Will it handle our B2B customers with their own price lists?
Shopify companies handle B2B on Shopify plans that support them. You can sync them 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. 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.