How can I put each cart attribute into its own column?

We support a function called search_attributes(data, attribute_name) which enables our users to do this.

For example, let's say you have a Cart Attribute called "Pickup-Date" that you want to include in your report as a separate column.

To do so, in the Calculated Fields section of the Order Data Settings, simply use this formula (note that "cart atributes" is also referred to as "note attributes" in the Shopify platform):

search_attributes({{ note_attributes }}, "Pickup-Date")

If you have other attributes you'd like to place into their own columns, simply repeat the formula above in additional Calculated Fields and replace "Pickup-Date" with the name of the other attributes.

For example:

EZ Exporter - Calculated Fields - Export Shopify Individual Cart Attributes

You can find the name of each cart attribute in the Shopify Admin's order detail page under the "Additional Details" section:

Cart Attributes examples from the Shopify Admin's order detail page under the section called "Additional Details"

Using the search_attributes() formula for the "Pickup-Date" and "Pickup-Time" attributes will output something like this in the CSV file:

Shopify CSV export of Cart Attributes from the order data

Also see our blog post for more info.

Related Articles:

App: EZ Exporter

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