BC <> Shopify Integration Docs & Inventory Posting Group Question

(2) Share

Report

Posted on by Jeel P

Hi everyone,

I'm currently working on a Business Central <> Shopify integration, and I'm looking for detailed documentation that covers:

Standard integration setup

Field mappings

Inventory sync

Test cases and edge scenarios

If anyone has such documentation, I’d really appreciate it if you could share it — please DM me on LinkedIn to discuss further. - https://www.linkedin.com/in/jeel-paun/

I also have a couple of specific questions related to inventory and posting group mappings:

Item Template Limitation:

I have two different General Product Posting Groups, but from what I’ve seen, the Shopify Connector only allows mapping one Item Template.
How can I manage items that require different posting groups under this limitation? Any workarounds or best practices?

Customer Posting Group Handling:

I use two Customer Posting Groups — Domestic and International. I noticed you can map multiple Customer Templates, but:
How does BC decide which Customer Template to apply when creating a customer from Shopify? Is it based on country, tags, or something else?

Any guidance, documentation, or examples would be a huge help. Thanks in advance!

Categories:

Dynamics 365 general

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Mansi Soni 8,887 Super User 2025 Season 2 on at

Like (2)

Report

BC <> Shopify Integration Docs & Inventory Posting Group Question

Hello,
The standard Business Central–Shopify connector provides built-in integration for syncing customers, items, inventory, and orders. Microsoft’s official documentation outlines how to set up the connection, map standard fields, and manage synchronization settings. Once the connection is established, sales orders from Shopify flow into Business Central, and item/inventory data is synced back to Shopify. This setup typically uses job queues and standard templates defined in the connector setup.

Regarding field mappings and inventory sync, the connector supports synchronization of key fields like SKU, quantity, price, and descriptions. Inventory is updated based on the Projected Available Inventory in Business Central and reflects stock at the mapped Shopify location. You can test edge cases such as partial stock availability, SKU mismatches, or Shopify orders for non-sellable items. The connector handles basic syncing well, but more complex needs such as multiple warehouses or custom pricing logic often require customization.

One limitation you’ve encountered is with Item Templates. The connector currently allows only one item template to be mapped for creating new items. This becomes restrictive when you have items requiring different General Product Posting Groups. A common workaround is to build a custom AL extension that dynamically applies the correct posting group based on item attributes (like product category or tags). Another approach, available in newer versions of BC (2023 Wave 1+), is to leverage improved templating features that provide better control over item setup rules.

For Customer Posting Groups, while the connector supports multiple customer templates, Business Central by default doesn’t auto-select them based on geography or tags. However, you can implement this behavior by subscribing to Shopify customer integration events and writing logic in AL to assign a template based on the Shopify customer’s country or custom tags. This allows you to apply different posting groups for example, Domestic vs. International based on business rules.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Verified answer

Mansi Soni 8,887 Super User 2025 Season 2 on at

Like (3)

Report

BC <> Shopify Integration Docs & Inventory Posting Group Question

Also for resources we have the Microsoft Learn Documentation and additionally providing you the relevant resources links:

https://archerpoint.com/business-central-shopify-connector-limitations/
https://community.dynamics.com/forums/thread/details/?threadid=2db36c2c-4205-f011-bae1-7c1e52199c3e
https://community.dynamics.com/forums/thread/details/?threadid=2db36c2c-4205-f011-bae1-7c1e52199c3e
https://community.dynamics.com/forums/thread/details/?threadid=2db36c2c-4205-f011-bae1-7c1e52199c3e
https://www.prisma-informatik.com/newsroom/2023/10/business-central-2023-wave-1-and-2-further-improvement-of-the-shopify-connector/
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-shopify
https://learn.microsoft.com/en-us/dynamics365/business-central/shopify/synchronize-items

Hope this resources will help you as well!

Regards,

Mansi Soni

Was this reply helpful? Yes No