How do I export the "Additional Information" data of the Shopify order?
The "Additional Information" section of the Shopfy Admin's order detail page provides additional fields that are required by certain countries on international orders.
Some examples:
- Cadastro de Pessoas Físicas (CPF) or Cadastro Nacional da Pessoa Jurídica (CNPJ) for Brazil
- People's Republic of China Resident Identity Card for China
- Personal Customs Clearance Code (PCCC) for South Korea
- Codice Fiscale (CF) and Posta Elettronica Certificata (PEC) for Italy
Here's an example of what this section looks like in the Shopify Admin:
To extract this data and include it in your Shopify order export, you can use the following formulas in the Calculated Fields:
Export Title & Value:
"\n".join([i.title + ": " + i.value for i in load_json_data({{ localized_fields }})])
Export Value Only:
get_attribute_value({{ localized_fields }}, "value")
Sample Output:
We also have a template you can use called "Open Orders with Additional Information (Last 30 Days)" which already includes this data and can be customized further.
Related Articles:
- How do I export the "Codice Fiscale (optional)" field of orders shipping to Italy?
- How do I export the "CPF/CNPJ" field of orders shipping to Brazil?
- How do I export the "Personal Customs Code" field of orders shipping to South Korea?
- How do I export the "Resident ID number" field of orders shipping to China?
App: EZ Exporter