How do I export the "Additional Details" data of the Shopify order?

The "Additional Details" section shown in the Shopify Admin's order detail page is stored in a field called note_attributes (also known as "cart attributes") in Shopify's backend.

EZ Exporter - Shopify Admin - Order Detail - Export Additional Details

Our app EZ Exporter can export this data by selecting the note_attributes.name and note_attributes.value fields in the Data Settings:

EZ Exporter - Note Attributes Fields

This will place all the field names in one column and all the values in another.

A more common use-case is to extract each attribute and put it in its own column in the exported CSV or Excel file. This can be achieved by using the Calculated Fields feature and entering a formula like this:

search_attributes({{ note_attributes }}, "Name of the Attribute")

Screenshot of what this looks like in the app:

EZ Exporter - Export each cart attribute into its own column in the CSV

The output will look something like this:

EZ Exporter - Shopify Order Additional Details - Export to CSV


Related Articles:


App: EZ Exporter

Tags: faq, cart attributes, advanced features, note attributes