Exportable orders and customers to CSV/Excel

[andris-sevcenko]

Created by: Jeremy Timms (jeztimms@gmail.com) on 2016/03/09 22:53:30 +0000
Votes at time of UserVoice import: 30

---

As the title says, button with data ranges to export customer data and order data to CSV. Mostly for marketing and of course, accounts. Very very important indeed. Standard stuff.

[andris-sevcenko]

Created by: idol chan (idolchan@gmyle.com) on 2016/04/25 03:41:17 +0000

---

Quick ways to export customer / order data is almost a basic requirement for a success ecommerce app.

[andris-sevcenko]

Created by: Matt Murtaugh (hello@mattmurtaugh.com) on 2017/05/06 04:06:11 +0000

---

This is the only thing that is keeping me from migrating one of my stores over to Craft Commerce. Being able to export an order with the billing and shipping address is essential.

The large # of orders we receive make it much easier for us to export orders from our current store, format them and then print them on labels.

If this was a feature of Craft Commerce, I would without a doubt switch my store over. Unfortunately, I rely too heavily on this functionality now to do so.

[missmatsuko]

In the meantime, you may be able to use the Sprout Reports plugin:
https://sprout.barrelstrengthdesign.com/craft-plugins/reports

[lukeholder]

You can exports orders from the order index screen.

[rob-baker-ar]

Exported orders in CSV format (even in "expanded" mode) do not have address details in separate columns.

JSON / XML expanded exports do have the address detail. Unfortunately, we need an export file that can easily be opened in Excel by non-developer people.

So, I added this: #2007

[icreatestuff]

It looks like this is still a problem unless I'm missing something. Neither the Raw, Expanded or Order (Legacy) export options from the orders index screen will provide individual columns for the shipping and billing address fields.

Craft 4.3.6.1
Commerce 4.2.4

[terryupton]

What is the status of this? I have a customer with the same issue.
It wasn't clear if this was solved and merged as part of this comment? #222 (comment)
Which then leads to this:
#2132

Customer is currently on Craft 3 and Commerce 3.