web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Shopify Connector Item...
Small and medium business | Business Central, N...
Suggested Answer

Shopify Connector Items to Products and Variants

(6) ShareShare
ReportReport
Posted on by TW-27040945-0 12
Is there a best practice to start from a list of items in Business Central and end up with Products and Variants in Shopify that are synced back to BC?
 
We have all products and variants listed as individual items in Business Central.  We have added these to Shopify and they have created an equal number of Products in Shopify.
 
In Shopify I can manipulate the data to group variants under products as I need it but then I lose the sync with Business Central as I have to create new products with associated variants.
 
The only thing I can think of is to add all items from BC to Shopify, manipulate the data in Shopify, delete the data in the Shopify connector (not sure how I do this?), import products and variants from Shopify to BC, Try to find the product mappings based on SKU number.
 
Any help appreciated as I am sure we are not the first trying to do this. Thank you.
Categories:
Dynamics 365 Business Central
  • Groefte Profile Picture
    Groefte 70 on at
    Hello,
    Same here - did you find a solution to this?
  • Groefte Profile Picture
    Groefte 70 on at
    For others looking for information on keeping individual items in Shopify instead of products + variants and without losing sync.
     
    Found a Shopify App "Product Bundles by Mageworx" https://apps.shopify.com/grouped-products?locale=da  and used the function Bundle Products that makes it possible to handle individual products as Parent /child or grouped products.
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 8,220 Moderator on at
    the best practice is to use one data source to keep your items and syn to the other. I would recommend set up all items in BC and sync to shopify. It is possible to create items in BC and a corresponding one shopify and map those up. But this will add challenge to have items created in different places and do the mapping. If you are still testing, I would recommend you to delete items in shopify, create as many items as you need in BC and sync to shopify. 
  • Groefte Profile Picture
    Groefte 70 on at
    Totally agree, we sync items from BC to Shopify.
    All our items are individual items, so if you e.g. have a t-shirt in size S M and L it will be displayed as 3 different products in Shopify. If you for some reason want to keep the individual products but would like to have them displayed in Shopify as 1 product with 3 different options, you can use the "Product Bundles by Mageworx" App.
    In BC we created an additional item (we call it a parent item) for the 3 t-shirt sizes with picture description etc.
    Go to Shopify and to the "Product Bundles by Mageworx" App and add the parent product as a Bundle and then add the 3 products size S M and L as Bundle products, then you will see the product as one with 3 options in a list with one add-to-cart. 
    Before we found this app, I searched a lot about the possibility to keep our individual items and their sync from BC to Shopify but didn't find much - maybe this post can help others who are looking for the same :)
  • Suggested answer
    Assisted by AI
    CU18040800-1 Profile Picture
    CU18040800-1 16 on at

    To solve this properly while preserving data integrity, the industry best practice is to restructure your data inside Business Central first before pushing it to your storefront. You need to designate one main Item card as the parent in Business Central and move your flat, individual items into its native Item Variants sub-table, making sure each variant retains its exact, original SKU number.

    Once this ERP hierarchy is established, you can delete the fragmented standalone products in Shopify, clear the connector's old log mappings, and run a fresh sync. The connector will now automatically generate clean parent products with grouped variants on your storefront, mapping order data and inventory levels bi-directional without any data loss.

    If restructuring your entire Business Central backend database is too disruptive to your warehouse workflows, you can safely use a Shopify-First mapping strategy instead. Under this approach, you manually build your grouped products and variants inside Shopify ensuring every single variant's SKU string perfectly matches its corresponding BC Item Number and use the connector’s mapping feature to link them together.

    If you want to take your storefront customization even further without cluttering your newly synced variant database, you can pair this setup with a native 2.0 app embed like Misk Variant & Product Options. Our app allows you to overlay highly interactive color swatches, button groups, and custom file upload fields directly onto your product pages without creating extra variant records in Shopify, keeping your synced Business Central catalog perfectly clean, lean, and highly optimized for conversions.

  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    Grigorios Mavrogeorgis 3,363 Super User 2026 Season 2 on at
    Hi,
    yeah you are right, the mapping bit reads too clean and confident. Let me roughen it up:
    Hi, this is common pain with the Shopify connector. The way it is supposed to work is you set up Item Variants in BC first (size, color, whatever), and then when you push to Shopify the connector groups them under one Product with Variants underneath. So the structure has to come from BC side, not Shopify side.

    In your case the items were probably pushed as separate items without variant codes, so Shopify created a Product for each one. That is why grouping in Shopify breaks the sync — the connector still thinks each is a standalone item.

    Honestly the cleanest fix I have seen is to test the proper variant setup on a few items first against a Shopify sandbox store, just to confirm the mapping works the way you expect on your version of the connector. Then plan a cleanup on the live store, which usually means removing the wrong Products and pushing fresh from BC with variants done properly.

    No nice button to fix it after the fact, sadly.
    ✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.
     
    Regards
    Gregory Mavrogeorgis
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 674 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 362 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 359 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans