Tags/topics: 
5
Answers
Vote up!
0
Vote down!

export shipping info into csv?

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.

Asked by: robotsguide
on July 19, 2012

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.

- ronald on July 19, 2012

I would also be very interested to know, how to export all orders made in a CSV file

- commercestudy on July 23, 2012

5 Answers

Vote up!
0
Vote down!

thanks for the suggestion, but it still opened the same as it was before, with all the address info in 1 column.

Answer by: robotsguide
Posted: Jul 19, 2012
Vote up!
0
Vote down!

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?

Answer by: ronald
Posted: Jul 20, 2012
Vote up!
0
Vote down!

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.

Answer by: cruzeazy
Posted: Jul 24, 2012

Comments

Vote up!
0
Vote down!

I tried your way cruzeazy and the fields returned blank. Will it not render for existing orders?

Answer by: robotsguide
Posted: Aug 9, 2012