Microsoft has built the Shopify connector into Business Central. We set it up so VAT, payments, shipping and stock add up, and test with real orders before go-live.
- Microsoft's own connector
- VAT per country (OSS)
- Payment and shipping mapped
- Tested with real orders
- Shop card
- VAT per country
- Payment and shipping
- Stock
Shopify integration for Business Central
Shopify and Business Central are connected with Microsoft's own Shopify connector. It is part of Business Central online, costs nothing extra and syncs products, stock, customers, orders, shipments and payouts. For most Danish webshops on Shopify it is the right choice.
But it isn't plug and play. Customer templates, VAT per country, payment and shipping methods and the stock calculation decide whether the bookkeeping gets less work or more. That setup is what we do.
Where it usually goes wrong
VAT for other EU countries
Sales to consumers in other EU countries must carry that country's VAT (OSS). That takes customer templates per country with the right posting groups.
One customer per web shopper
Decide whether every web shopper becomes a customer, or whether B2C orders go on one shared customer. Most bookkeepers prefer the latter.
Payments and shipping without mapping
MobilePay, card and Shopify Payments each need their own payment method, and GLS, PostNord and DAO each their own shipping agent. Otherwise the order stops at import.
Stock that sells what's sold out
Send calculated available inventory, not just the quantity on the shelf, and run the sync in the job queue every 15–30 minutes. Turn off "continue selling when out of stock".
B2B customers with a GLN
If the business customer has a GLN number, the invoice must go out as OIOUBL, not as a PDF.
A messy item catalogue
Most integration problems come from master data, not the connector. Spend a week tidying up before go-live.
How we set up the connector
Business Central owns items, prices and stock. Shopify gets what it needs to show.
- Prerequisites
Business Central online, admin access on both sides, and who owns product data.
- Shop card and mapping
Customer templates per country, payment methods, shipping agents, freight and fee accounts.
- Items and stock
Variants, prices per shop and currency, locations and calculation method.
- Test orders
Order, payment, shipping, return and credit memo with real data.
- Go-live
Automatic release switched off at first, so someone looks the orders over.
Good to know
- We use Microsoft's connector, not an app of our own. It is free, maintained by Microsoft and suits most Danish Shopify shops.
- The connector only exists in Business Central online. If you run on-premises, you move to the cloud first.
- If your shop runs WooCommerce, we have our own connector.
Packages that go with the shop
New to Business Central, or operations after go-live.
All prices exclude VAT. Business Central and Microsoft 365 licences come on top.
What people often ask us
Does the Shopify connector cost anything?
No. It is part of Business Central online and doesn't come from AppSource. What you pay for is setting up the templates, VAT and the order flow.
Does it work with Business Central on-premises?
No, the connector only exists in Business Central online.
Can we have several Shopify shops?
Yes. Each shop gets its own shop card with its own settings, such as a Danish and a German shop.
How is VAT for consumers in other EU countries handled?
With customer templates per country, so the order gets the right country's VAT under the OSS rules.
What happens to returns?
Returns and refunds become credit memos in Business Central.
Shopify that agrees with the books
Tell us about your shops, countries and payment methods. Then we look at what the connector needs to be set up for.
30 minutes on Teams with Sten or Lauge. You talk to the person who builds it.