Exporting orders to CSV - add a way to have full address details in separate columns

[rob-c-baker]

What are you trying to do?

Export a CSV, for use in Excel, that includes order details and crucially, address details. Currently, the CSV gets columns labelled billingAddressId and shippingAddressId which are not useful in this context. There are columns labelled billingAddress and shippingAddress but these contain a JSON string with the address details that content managers and users (non developers) cannot expand into useable data in Excel.

What's your proposed solution?

When exporting a "expanded" CSV, include the columns from the address tables instead of just the shipping / billing address ids, or allow include an export option that allows a user to choose what fields to export.