Product

Dynamics 365 Business Central – Shopify Connector

Description

The current Shopify integration in Business Central supports synchronization of Item Attributes to Shopify. In the current implementation, attribute values are inserted into the Shopify product description as an HTML table.

While this approach makes the attribute information visible on the product page, it does not align with how structured product data is typically managed in Shopify.

In Shopify, structured product data is commonly stored using Product Metafields, which are widely used by themes, apps, and storefront filtering mechanisms.

Because the current implementation inserts attributes into the product description as HTML, the data cannot be used for:

• Collection filtering
• Storefront search and filtering apps
• Theme-based dynamic product specifications
• Structured data integrations with other Shopify apps

As a result, the current attribute synchronization provides limited value for merchants using Shopify’s standard ecosystem features.

Current Behavior

When Item Attributes are synchronized from Business Central to Shopify:

• Attribute values are converted into an HTML table
• The HTML table is appended to the Shopify product description
• Shopify does not recognize these values as structured product data

Suggested Enhancement

To better align the Business Central Shopify integration with Shopify’s data model, support for Shopify Product Metafields could be introduced as part of the Item Attribute synchronization process.

A possible design could include the following components.

1. Synchronization of Shopify Product Metafield Definitions

Allow Business Central to retrieve Product Metafield definitions from Shopify.

These definitions could be exposed in Business Central through a list page showing information such as:

• Namespace
• Key
• Data type
• Description

This page could be read-only and intended primarily for reference and mapping purposes.

2. Attribute-to-Metafield Mapping

Extend the Item Attribute configuration to allow mapping between:

Business Central Item Attribute → Shopify Product Metafield

3. Metafield Synchronization During Product Sync

During product synchronization:

• Business Central reads the configured attribute mappings
• Attribute values are written to the corresponding Shopify product metafields
• The current HTML table generation in the product description could optionally remain for backwards compatibility

Benefits

Supporting Shopify Product Metafields would provide several advantages:

• Alignment with Shopify’s recommended approach for structured product data
• Ability to use Business Central attributes in Shopify filtering and search
• Improved compatibility with Shopify themes and apps
• More flexible storefront presentation of product specifications
• Increased value of Item Attributes within the Shopify integration

Summary

Adding support for Shopify Product Metafields would significantly improve the usefulness of Item Attribute synchronization between Business Central and Shopify, while maintaining compatibility with Shopify’s modern data model and ecosystem.