Is there a way to export order shipping information into a CSV?
all I need it to do is export the order ID, name, address 1 & 2, city, state, zip, country and user email all in different columns.
I can get views to display all that and use the views exporter, but all the address info is in 1 column instead of a column for each section.
thanks for the suggestion, but it still opened the same as it was before, with all the address info in 1 column.
how does the file look like?
Are the fields delimited by comma, semicolon, TAB or what?
What happens, if you vew it in notepad or alike?
Add a relationship of Commerce Order : Shipping information. You will then have a field named: "Commerce Customer profile: Address
Appears in: commerce_customer_profile:billing, commerce_customer_profile:shipping." available. Now you can REWRITE RESULTS for each specific field. address, city, state and so forth individually.
I tried your way cruzeazy and the fields returned blank. Will it not render for existing orders?
Comments
I suppose, you opened with excel.
If you save it to a file with .txt extension, and you open excel first, and the open the file with excel, it will be imported ok.
Just try, and let us know.
I would also be very interested to know, how to export all orders made in a CSV file