How can I export the line item returned quantity by return status?

You can use the following formulas in the Calculated Fields to export the total returned quantity based on different return status:

Lineitem Returned Quantity (All Status)

get_total(to_list({{ line_items.returns.quantity }}))

Lineitem Returned Quantity (Open/In Progress)

get_total([i.quantity for i in load_json_data({{ line_items.returns }}) if i.status == "OPEN"])

Lineitem Returned Quantity (Closed)

get_total([i.quantity for i in load_json_data({{ line_items.returns }}) if i.status == "CLOSED"])

Lineitem Returned Quantity (Canceled)

get_total([i.quantity for i in load_json_data({{ line_items.returns }}) if i.status == "CANCELED"])

Lineitem Returned Quantity (Requested)

get_total([i.quantity for i in load_json_data({{ line_items.returns }}) if i.status == "REQUESTED"])

Lineitem Returned Quantity (Declined)

get_total([i.quantity for i in load_json_data({{ line_items.returns }}) if i.status == "DECLINED"])

App: EZ Exporter

Tags: shopify orders, shopify returns