In our e-commerce setup using Shopify and Dynamics 365 Business Central, we face a key integration limitation:

We use a 3D product configurator communicating with Shopify. It generates individualized configuration data per order (line). This data is stored in a Shopify order metafield in JSON format. The information is essential for downstream processes such as production, fulfillment, or customer service within Business Central.

Current limitation:

The standard Shopify connector for Business Central currently does not support the transfer of metafields within the Shopify Order and Order Lines. While metafield support for products and customers has been added recently, there is no capability to synchronize metafields.

Consequences:

• The configuration data is only available in Shopify after checkout
• There is no standard method to make this data available in BC
• Extending the relevant data is impossible because most of the functions and objects are "Internal"
• Workarounds require custom API development, adding cost and we would like to refer to standard routines

Proposed solution:

We propose enhancing the Shopify connector with the following capabilities:

1. Support synchronization of Shopify order metafields to Business Central.
2. Provide a flexible mapping mechanism to direct metafield values to sales order headers or lines in BC.

Business value:

• Enables seamless handling of configured products and custom order data.
• Reduces need for custom development or middleware.
• Improves operational efficiency across departments (sales, production, service).