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

Shopify Connector - Items with Sales unit of Measure other than Base UoM

(2) Share

Report

Posted on by JO-11011610-0

Hi,

We are trying to get our client's system to sync prices from Business Central to Shopify. Here are the background:

All items have a base UoM (eaches) and another default sale UoM (cases).
This is because most of the sales in the system is done in cases (B2B sales through other channels than Shopify).
In the Shopify webshop all sale is done in eaches - the base UoM of all items.
We have created a sales price list for the Customer Price Group that is set in the Shopify Connector settings in Business Central.
In this price list all prices are set in eaches which the base unit of measure and the unit we want to use for sales in Shopify.

How can we set the Shopify Connector to "understand" that we want to sync the price based on the item's base UoM, not the default sales UoM on the items?

Thanks in advance,

Jim

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Grigorios Mavrogeorgis 2,544 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello Jim,
This is a known limitation with how the Shopify connector reads prices. It does not really look at the price list UoM, it takes the price using the item's Sales Unit of Measure, so in your case it picks the case price, not the eaches price from your list, even if your price list is all in eaches.

There is no setting on the connector to tell it "use base UoM", the sync follows the item setup, not the price group.

Easiest fix is to set the Sales Unit of Measure on the items to eaches, but i think this will break your B2B case sales, so maybe not good for you.
If that is not acceptable, then a small AL customisation on the price sync event is the realistic solution, you override the price for Shopify so it always takes the base UoM price. B2B stays in cases, Shopify gets eaches.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards

Gregory Mavrogeorgis

Work: GMSOFT Limited
Blog: Inside Business Central
LinkedIn: www.linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, The following is the standard processing.

https://learn.microsoft.com/en-us/dynamics365/business-central/shopify/synchronize-items?wt.mc_id=DX-MVP-5004336#sync-prices-with-shopify

Your requirement seems to need to be customized.

Extend the Shopify Connector:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-shopify?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 17,681 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello Jim,
The standard Shopify connector does not have a setting to force price sync by Base UoM; Microsoft notes that the connector calculates prices by creating a temporary sales quote for quantity 1 and using standard BC price calculation, and newer connector behavior aligns Shopify order/pricing logic with the item’s Sales Unit of Measure when it exists. So if your Item Card has Sales Unit of Measure = CASE, the connector will tend to price as CASE, even if your Shopify price list lines are in EACH. The clean workaround is to make Shopify-specific items/variants or a customization, or leave Sales Unit of Measure blank / set it to EACH for items sold through Shopify and handle B2B case selling through price list lines, sales setup, or customer processes instead. If you must keep CASE as the item’s default sales UoM, then this is likely an extension/customization requirement around Shopify price calculation, not a connector setup option.
Regards, Oussama Sabbouh

Was this reply helpful? Yes No

Join the conversation

Community site session details

Shopify Connector - Items with Sales unit of Measure other than Base UoM

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Shopify Connector - Items with Sales unit of Measure other than Base UoM

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates