How can I export the "Next Payment Due At" data from a Shopify order?

You can use the formula below in the Calculated Fields to pull out this data from the payment_terms field:

get_value_by_position(sorted([i.due_at for i in load_json_data({{ payment_terms.payment_schedules }}) if not i.completed_at]), 1)

The formula sorts the the payment schedules that haven't been completed in ascending order and then extracts the first entry.


App: EZ Exporter

Tags: shopify order export, payment terms