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:


App: EZ Exporter

Tags: additional information, localization extensions, localized fields