How can I add a column in the Shopify order export to determine whether a customer is "new or returning"?
The Shopify Order API endpoint doesn't have a field for "new or returning customer".
However, there's a field called customer.orders_count
which will return the current total order count for the customer at the time of export. So we can use this data to determine whether a customer is new or returning.
In EZ Exporter, you can use the following formula in the Calculated Fields to create a custom column with a "Yes/No" value:
"Yes" if {{ customer.orders_count }} > 1 else "No"
App: EZ Exporter