Small and medium business | Business Central, N...

Shopify prices including vat

(3) Share

Report

Posted on by Mateusz Przybylski

Hello,

I've setup connector to our customer's store. Customer is selling on two markets therefore I've setup two Customer Template. Both of them are having customer template with Price Including VAT = Yes.

I do not sync any prices; they are in Shopify and BC gets them in the moment of Order Import.

I followed guide from here:

https://learn.microsoft.com/en-us/dynamics365/business- central/shopify/setup-taxes

Especially with this sentence:

/When you import orders from Shopify, the setting for the Prices including VAT field comes from the Customer Template on the Shopify shop card, or the customer template per country/region. Even if you use the default customer for imported orders, you must fill in the Customer Template Code./

This is what I did, in fact customer is created with Price Including VAT = Yes, but once I click Create Sales Order from shopify order the sales order gets value of Price Including VAT = No... no idea why.

And because of that bug I have Total sales order difference vs Shopify because of vat mismatch. On shopify order there is even boolean VAT Included = true. But it does not matter, sales order is created with false value for some reason.

When I want to manually create standard BC order for newly created customer I get Sales Header with Price Including VAT = Yes and all works okay, this is issue with Shopify connector creating sales order from shopify order. We are having newest version of shopify.

Any advise?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Jeffrey Bulanadi 6,939 on at

Like (0)

Report
Shopify prices including vat

Hi Mateusz,

I can see why it’s frustrating. Based on your setup, it sounds like everything is configured correctly: both Customer Templates have “Prices Including VAT = Yes,” and you’re not syncing prices directly. Yet the Sales Header ends up with “Prices Including VAT = No” after importing the order.

This behavior is typically caused by a mismatch between Shopify’s order payload and how the connector interprets the VAT flag. Even though the Shopify order includes VAT Included = true, BC may still default to “No” if the connector doesn’t correctly resolve the Customer Template or if the VAT logic is bypassed during order creation.

Here’s what I’d recommend:

Double-check that the Customer Template Code is filled in on the Shopify Shop Card and matches the template assigned per country/region. This field is critical — if it’s missing or misaligned, BC won’t inherit the VAT setting correctly.

Confirm that the Customer Card created from the template has “Prices Including VAT = Yes” and “Tax Liable = Yes.” If Tax Liable is off, BC may suppress VAT logic during import.

If you’re using the latest version of the connector, test whether the VAT flag from Shopify is being respected. You may need to extend the connector slightly to enforce the VAT setting from the template explicitly during order creation.

As a workaround, you can add a post-processing step that updates the Sales Header’s “Prices Including VAT” field based on the originating template or market logic.

This issue has surfaced before, especially in multi-market setups where Shopify’s tax logic varies by region. You’re not alone in running into it.

Helpful references:
Set up taxes for Shopify connection – Microsoft Learn
Synchronise Pricing and Discounts with Shopify – Simply Dynamics

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,152 Super User 2025 Season 2 on at

Like (1)

Report

Shopify prices including vat

did you check the customer tax related set up in BC?

vat related set up in BC

tax liable should set to Yes on customer card. If not, BC might remove the tax when the import happens

Jun Wang

Was this reply helpful? Yes No
AJ-06051326-0 on at

Like (1)

Report

Shopify prices including vat

I have same problem. No idea how to fix it....

Was this reply helpful? Yes No
Mateusz Przybylski on at

Like (2)

Report

Shopify prices including vat

Thanks for your response.

I've set this field to Yes but it did not help. I think this is related to export prices anyway :(

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 90,244 Super User 2025 Season 2 on at

Like (2)

Report

Shopify prices including vat

Hi, is the following setting on Shopify Shop Card also Yes?

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No