Why is Business Central integration showing variant codes instead of descriptions on Shopify?

[Anita2791]

Currently, we have implemented a typical integration setup between our Business Central platform and Shopify utilizing the Shopify connector. The synchronization process is functioning as intended, with one minor issue observed on the Shopify platform. Specifically, when navigating variant options, the displayed information pertains to the variant code-bc field (e.g., 108552) rather than the corresponding description (e.g., size 46, 47, 48). We are uncertain if the description is being properly synchronized and whether Shopify administrators need to configure and expose the necessary fields, or if this discrepancy stems from a synchronization error.

[ThePixelEdge]

Hello @Anita2791 

Based on the information provided, it appears that the issue with displaying variant options on the Shopify platform is related to the data synchronization process between Business Central and Shopify. Specifically, the displayed information shows the variant code-bc field (e.g., 108552) instead of the corresponding description (e.g., size 46, 47, 48) for the variants.

To resolve this issue, you should investigate the data synchronization process to determine whether the variant descriptions are being properly sent from Business Central to Shopify. Here are some steps to help you troubleshoot and resolve the problem:

1. Check Data Mapping: Verify the data mapping and configuration settings in the Shopify connector. Ensure that the correct fields from Business Central are mapped to the appropriate fields in Shopify, including the variant description field.

2. Shopify Variant Configuration: In Shopify, check if there are any settings related to variant display that may be affecting how the data is shown. Review the product variant settings in the Shopify admin panel to see if there are options to display variant descriptions instead of codes.

3. API Error Logs: Examine any error logs or synchronization logs that the integration setup provides. Look for any error messages or warnings related to variant information and see if they provide any clues about what might be causing the discrepancy.

4. Manual Data Check: Manually cross-check a few product variants between Business Central and Shopify to see if the variant descriptions match. This will help you identify if the issue is with the synchronization process or if it's a configuration problem on the Shopify side.
   
   If the above steps did not hep you. My services are paid.
    I can assist you with this by examining your theme code. Once you approve the collaboration, we can proceed with fixing the issue for you.
   
    

[D365BC_Shpfy]

Hi Anita,

I recently completed this migration myself and encountered the same issue.

One alternative was changing the “SKU Mapping” in Shopify Shop to “Bar Code” and adding the variant description in “Item References.” However, this approach removes the Item No. from the SKU in Shopify.

Instead, I created these variants as item cards and added a new field on the Item Card called “Parent Item.” Each variant has the “Parent Item” as the Parent/Master Item.

After setting this up, I did custom development in Business Central (BC) to adjust inventory for all variants if one of the variants was sold in Shopify. Additionally, I developed a feature so that if one of the variants sells, the parent item is used when the BC sales order is created.

For example:

- Item A (Parent Item): Not a Shopify product, used only for selling and tracking inventory.
- Item B (Variant 1): Shopify product with Item A as the Parent Item.
- Item C (Variant 2): Shopify product with Item A as the Parent Item.
- Item D (Variant 3): Shopify product with Item A as the Parent Item.
If any of the variants sell (Item B, Item C, or Item D), all variant inventory levels will be reduced accordingly in Shopify.

Hope this helps

Thanks
Jeremy