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:
You can find the name of each cart attribute in the Shopify Admin's order detail page under the "Additional Details" section:
Using the search_attributes() formula for the "Pickup-Date" and "Pickup-Time" attributes will output something like this in the CSV file:
Also see our blog post for more info.
Related Articles:
- Can I export Shopify cart attributes?
- How do I export all the note attributes of a Shopify order in a single column in Name: Value format separated by a line break?
- How do I export custom order data that was entered by the customer during checkout using Zapiet's Store Pickup + Delivery app ?
- How do I export the "Additional Details" data of the Shopify order?
- How do I export the custom "Pickup Date" or "Delivery Date" note attributes from a Shopify order?
App: EZ Exporter