Hi I’m in trouble now in translating “shopify–color-pattern” output in option1 value to normal color name like “black” in exported CSV from Shopify Admin. Is there any mapping table for these shopify–color-pattern and color name somewhere? This could be typical question but cannot locate right place to find answer myself.
Greatly appreciated if anyone could help.
Topic summary
A user is struggling to convert Shopify’s shopify--color-pattern values from exported CSV files into readable color names (specifically needing English translations from Japanese color names represented as hexadecimal codes).
Initial Problem:
- Shopify exports product variant colors using internal format like
shopify--color-pattern--black - User seeks a mapping table to translate these patterns to standard color names
Proposed Solution:
- Another user suggests using an Excel formula to extract color names:
=RIGHT(A1,LEN(A1)-FIND("--",A1,FIND("--",A1)+2)) - This formula strips the
shopify--color-pattern--prefix to reveal the color name
Remaining Challenge:
- The original poster’s color names appear as hexadecimal codes (e.g.,
shopify--color-xxxxxx) in Japanese - Still needs a method to translate these hex codes into standard English color names
Status: Unresolved - the Excel formula helps with standard pattern extraction, but doesn’t address the hexadecimal/Japanese-to-English translation issue.
Hi,
Hope this will help
Shopify uses special “internal option values” for product variants in themes or metafields.
shopify – color-pattern – color-name
Example
shopify–color-pattern–black means (color pattern is black)
Below formula can help in excel sheet
=RIGHT(A1,LEN(A1)-FIND(“–”,A1,FIND(“–”,A1)+2))
Hi greatly appreciated. As much as I appreciate my color name is in Japanese so the suffix looks in hexadecimal Shopify—color-xxxxxx where I still need the way to translate from this codes to standard color name in English.
thx