Business Central and Shopify integration
Keep products, prices, inventory, orders and customers in step between Microsoft Dynamics 365 Business Central and your Shopify Plus store. Unity builds the integration, runs it and supports it, so ecommerce and operations work from the same records.
Your ERPBusiness Central- Items
- Price lists
- Inventory
- Sales Orders
Your storeShopify- Products and variants
- Inventory by location
- Orders
- Customers
Unity connects Business Central and Shopify Plus through each system's own API: the Business Central API on one side and the Shopify Admin API on the other. Products, prices and inventory flow from Business Central to Shopify, orders and new customers flow back to Business Central, and shipments and tracking numbers update the Shopify order, all in near real time. Every write to Business Central passes Business Central's own validation. On-premises Business Central installs connect through a lightweight Intelligrate agent, so no inbound firewall ports are opened. Our Unity team builds, monitors and supports the integration.
What syncs between Business Central and Shopify
Products are matched by SKU to the Business Central item number, and Unity stores the Business Central customer number on each Shopify customer, so updates change the existing record instead of creating a new one. Changes sync in near real time.
| Business Central | Shopify | Direction |
|---|---|---|
| Products and inventory | ||
| Items | Products and variants | Business Central → Shopify |
| Price lists | Variant prices | Business Central → Shopify |
| Inventory by location | Inventory at each Shopify location | Business Central → Shopify |
| Orders and customers | ||
| Sales Orders | Orders, with line items, shipping address and discounts | Shopify → Business Central |
| Customers | Customers | Shopify → Business Central |
| Fulfillment | ||
| Posted shipments and tracking numbers | Fulfillments, with carrier and tracking number | Business Central → Shopify |
How Unity connects Business Central and Shopify
Unity uses the supported API on each side and never writes straight to either database.
Business Central API
Unity reads and writes Business Central through Microsoft's standard API (v2.0), so every record passes Business Central's own validation. Online, Unity signs in as a registered Microsoft Entra application with OAuth 2.0, so no user passwords are shared. No extra Business Central license is needed for the integration.
Shopify Admin API
Unity connects to your Shopify Plus store as a custom app you approve, with only the access scopes it needs. It picks up new orders as they're placed and sends product, price, inventory and fulfillment updates through the Shopify Admin API, pacing its calls to stay inside Shopify's rate limits.
Online or on-premises
Business Central online needs nothing installed. For on-premises Business Central, a lightweight Intelligrate agent runs inside your network and connects out, so no inbound firewall ports are opened. Unity can run against a sandbox first, so the integration is tested before it touches production.
Monitored and supported
Unity watches every sync and tells you about an outage or lost connection before you notice it. When a record fails, Unity raises a case with the exact Business Central or Shopify error, and our team fixes it and keeps the integration working through Business Central and Shopify updates.
Business Central and Shopify problems we've already solved
These are the issues that stall do-it-yourself Business Central and Shopify integrations, and how Unity handles each one.
Shopify sells stock you don't have
When inventory updates run once a night, Shopify keeps selling items that are already gone. Unity sends Business Central quantity changes to each Shopify location in near real time, so the store shows what you can actually ship.
One ERP item per size and color
Shopify groups sizes and colors as variants of one product, while Business Central usually keeps each as its own item. Unity maps each item to a variant by SKU and groups them under the right Shopify product.
An order for a customer Business Central doesn't know
Business Central rejects an order whose customer isn't set up yet. Unity's dependent maps create the customer from the Shopify order first, then post the order, which prevents missing-customer errors.
A flash sale floods the integration
Shopify throttles API calls, and a busy sale can bring in hundreds of orders at once. Unity's connectors manage Shopify's rate limits and batch sizes for you, so every order reaches the ERP without being dropped.
Unity is a managed integration service built on the Intelligrate integration platform. We build your Business Central and Shopify integration, monitor it, fix errors and handle upgrades, so your team doesn't have to. See all pre-built ERP integrations.
Business Central and Shopify integration questions
Does Unity work with Business Central online and on-premises?
Yes. Online, Unity connects through Microsoft's Business Central API with OAuth 2.0 through Microsoft Entra ID. On-premises, the same APIs are available once they are enabled on your Business Central server, and a lightweight Intelligrate agent connects out from your network.
Which Shopify plans work with the integration?
Shopify Plus. The standard Unity integration is built for Shopify Plus stores.
Do we need an extra Business Central license for the integration?
No. Unity connects to Business Central as a registered Microsoft Entra application, and the integration doesn't need any extra Business Central licensing.
Does the integration sync refunds and returns?
Not in the standard scope, which covers products, prices, inventory, orders, customers and fulfillment. If you need refunds or returns in Business Central, we can scope them as an addition.
Is the integration managed or self-service?
Fully managed. Our Unity team builds the maps, tests them with your data, monitors every sync and fixes errors. If you have a question, you can reach Unity support by phone or email at no extra charge.
Can Unity map our Business Central custom fields and Shopify metafields?
Yes. Unity maps Business Central custom fields to Shopify product, variant or order metafields without code, set up for how your teams work.
How long does a Business Central and Shopify integration take?
Most go live in four to six weeks, including mapping, testing with your data and training. Adding another system later is quicker, since your Business Central connection is already in place.