Hi everyone,
I'm looking for guidance on syncing color information from Acumatica to Shopify using the native Shopify Connector on 2026 R1.
The requirement
In Acumatica, product color is stored as a descriptive name. On the Shopify side we're populating a Color metafield, which expects a hexadecimal value rather than the name:
- Black →
#000000 - White →
#FFFFFF - Smoke →
#808080 - Dark Smoke →
#4A4A4A
What I've tried
- Created a Substitution List mapping the Acumatica color names to their hex values, and referenced it in the Shopify Entity Mapping. The substitution was not applied and no hex value was exported.
- Changed the Acumatica color field to store the hex value directly (for example,
#000000) and re-synced the product. The Shopify color metafield still was not populated. - Tried the following expression in the entity mapping:
=SubstituteListed([shopify.color-pattern], 'Metacolor')— the expression editor returns an error that the function is undefined.
My questions
- Is there a supported way to translate a field value ("Dark Smoke" → "
#4A4A4A") during export without customization? - Has anyone successfully mapped Acumatica color names to Shopify hex color metafield values using the native connector?
- Is the recommended approach to store both the display color name and the hex value in Acumatica, or is there a better practice for this scenario?
At this point I'm trying to determine whether this is a limitation of the native connector, a mapping configuration issue, or whether there's a known approach for Shopify metafields that require hex values.
Any guidance, examples, or best practices would be much appreciated. Thanks!