I want to export my order data as an excel file but when i do, it doesnt automatically repeat information for each order.
For example, in the below in order 3, i would want the payment type to also appear on the blue jeans line
|order number||payment type||item||price||shipping method|
|2||Credit Card||White Shoes||$50||Standard|
|3||Credit Card||White Shoes||$50||Standard|
I'm not aware of an option to do this with Shopify's standard order export.
However, if you're open to using an app, our app EZ Exporter will already do this by default (i.e. for each line item row, also repeat the information at the order level such as the payment gateway and shipping details).