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

Tags: advanced features, shopify orders, calculated fields