How do I export South Korea provinces in Korean characters from my Shopify order data?
The Shopify Order API will return South Korea province names in Latin characters. For example, it will return "Seoul" instead of "서울특별시".
You can export the province names in Korean characters with EZ Exporter by utilizing the get_attribute_value() function in Calculated Fields. Basically, you just provide a key/value mapping where the "key" part is the value coming from Shopify, and the "value" part is the equivalent in Japanese characters.
The API also has a province_code field which is shorter and probably more reliable in case the province names have different variations in spelling.
The formula below will output the province names in Korean by looking up the value of shipping_address.province_code.
get_attribute_value('{"KR-26": "부산광역시", "KR-43": "충청북도", "KR-44": "충청남도", "KR-27": "대구광역시", "KR-30": "대전광역시", "KR-42": "강원특별자치도", "KR-29": "광주광역시", "KR-41": "경기도", "KR-47": "경상북도", "KR-48": "경상남도", "KR-28": "인천광역시", "KR-49": "제주특별자치도", "KR-45": "전라북도", "KR-46": "전라남도", "KR-50": "세종", "KR-11": "서울특별시", "KR-31": "울산광역시"}', {{ shipping_address.province_code }})
Source of the above mapping:
Related Articles:
App: EZ Exporter