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!
