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

Taxes from Shopify order lost when converting to Sales Order

(7) Share

Report

Posted on by BS-21061738-0

A client of mine is having an issue with taxes within the Shopify <> BC integration. Here's what they say:

Order coming in from Shopify to D365BC though integration includes Tax charged and collected through the Shopify platform. But when order is converted from a Shopify Order to a Sales Order – no tax on the order at all. This currently being added manually. Need to make sure the tax charges coming from Shopify to BC is transferred in Sales order.

Has anyone run into this issue? I need to dig more into it, but I thought I would post here to see. Of note, they are using Avalara for taxes on Shopify. Tax Are Priority field in Shopify card is set to Ship-to -> Sell-to -> Bill-to.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (3)

Report

Hope this can help - Set up taxes for Shopify connection - Business Central | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
BS-21061738-0 26 on at

Like (5)

Report

Yep, been through the setup, but they don't move in BC when you convert the Shopify order to a sales order.

Was this reply helpful? Yes No
Suggested answer

CU16040542-0 10 on at

Like (4)

Report

Hi,

I cam across the same issue and found a solution after debugging the system as follows,

This issue is resolved using standard Business Central functionality with the correct configuration. To ensure taxes from Shopify (including Avalara-calculated tax) appear on the Sales Orders in BC, follow these steps:

(1) Make sure the “Shpfy Tax Area” table (30109) is properly configured with the correct Tax Area Codes that match Shopify’s tax regions,

(2) Verify that the Customer Template used for Shopify order imports includes the right Tax Area Code and Tax Liable = TRUE, and

(3) Confirm that the Tax Area Priority on the Shopify Webshop Card is set to Ship-to > Sell-to > Bill-to.

With this configuration in place, tax amounts from Shopify orders will sync and apply automatically to the corresponding Sales Orders in Business Central.

Shpfy Tax Area.png

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

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

https://www.reddit.com/r/BusinessCentral365/comments/1dkc2ty/shopify_integration_issue_with_taxes/?rdt=60764

Was this reply helpful? Yes No
NAV2BC02 172 on at

Like (3)

Report

Did anyone get this to work yet?

I add the exact same tax region name as the tax area code in BC and tax did not come over.

Thoughts?

Nirav S.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 5,657 on at

Like (2)

Report

Hello,

Shopify does send tax, but BC recalculates tax when converting a Shopify Order → Sales Order.

If BC can’t determine a valid Tax Area Code (via Tax Area Priority + Customer Setup by Country/Region), BC ends up with 0 tax, even if Avalara calculated tax in Shopify.

So the fix is either:

Correct BC tax setup (Tax Areas, customer templates, Tax Area Priority), so BC can recalc tax properly, or

Build a small customization to copy Avalara’s tax amounts directly into the Sales Order instead of recalculating.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No