Skip to main content
Post a question

Notifications

Announcements

No record found.

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

Shopify Integration in Business Central – Inventory & Pricing Sync from Incorrect Items

Like (4) ShareShare
ReportReport
Posted on 30 Jan 2025 09:41:55 by 15
Hello everybody!
 

Background

I am using the official Shopify connector in Business Central and have configured SKU mapping based on "Vendor Item No.". My goal is to sync only a specific subset of items to Shopify.

 

Setup Details:


  • SKU Mapping on Shop Card: Vendor Item No.

  • Add Items Report Filtering: I filtered items by Vendor No. = 100331 to ensure only these items are added to Shopify.

  • Sync Jobs: Successfully ran the “Add Items” job, which correctly created products in Shopify. Subsequently, both the Sync Inventory and Sync Prices job queues were executed.


  •  

Issue:

While items I filtered are added to Shopify, the inventory and pricing data in Shopify is being pulled from other Business Central items that share the same Vendor Item No., even though they have different Vendor Nos. and were excluded during the Add Items report filtering.

 

Example scenario:


  • Item 41053800711 (Vendor No: 100050, Vendor Item No: MB025295) - will not be in Shopify.

  • Item 41045200941 (Vendor No: 200567, Vendor Item No: MB025295 ) - will be in Shopify. So the expected Inventory and Price Values are "5" and "31,14" respectfully.
 
However, when I check on Shopify side, here is the results:
 


     

Even though only 2nd item should sync, Shopify is pulling inventory and pricing from 1st item because both share the same Vendor Item No. (ABC123).

 
 
Plus, when I click on "Show Product in Shopify" in the accurate item, I get this error message:
 
                                  
 

Question:

How can I ensure that inventory and pricing updates in Shopify only come from the filtered items during the Add Items Report (Vendor No: 100331) rather than from other items with the same Vendor Item No.?

I appreciate any insights on how to resolve this issue, whether through configuration changes, additional filtering, or a workaround within Business Central.

Thanks in advance!


  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,461 Super User 2025 Season 1 on 03 Feb 2025 at 00:33:51
    Shopify Integration in Business Central – Inventory & Pricing Sync from Incorrect Items
    Hi, It looks like it needs customization, I hope the following information can give you some hints
     
    Thanks
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 14,170 Most Valuable Professional on 02 Feb 2025 at 18:27:45
    Shopify Integration in Business Central – Inventory & Pricing Sync from Incorrect Items
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 8,227 Super User 2025 Season 1 on 01 Feb 2025 at 16:24:10
    Shopify Integration in Business Central – Inventory & Pricing Sync from Incorrect Items
  • Oguzhan Gok Profile Picture
    Oguzhan Gok 15 on 30 Jan 2025 at 09:51:47
    Shopify Integration in Business Central – Inventory & Pricing Sync from Incorrect Items
     
    Vendor Item No's are stored in Business Central and unfortunately, they are not unique. But as I said their Vendor No's or other values are different on item cards, so I was able to filter them out during the "Add Items" report while importing items from BC to Shopify. But that's not the case for Sync Inventory & and Sync Price reports.
     
    So items had not existed before in Shopify.
  • Sajjad Yousuf Anjum Profile Picture
    Sajjad Yousuf Anjum 42 on 30 Jan 2025 at 09:46:20
    Shopify Integration in Business Central – Inventory & Pricing Sync from Incorrect Items
    Hi,
    Are Vendor Item numbers are unique and where from you uploaded the Item.
    Uploaded them from Business Central to Shopify or Items were already exists in shopify?
     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,257 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,028 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading started