You may have different reasons for exporting data about your orders from WooCommerce. Some users just need this once when they’re migrating to another platform or online store. Others would like to export WooCommerce data recurrently for reporting or analytical purposes. In this blog post, we’ll talk about how to export WooCommerce orders and what formats and destinations are available.
How to export WooCommerce orders TL;DR
There are a few ways to export WooCommerce orders depending on what and where you need to get your data:
- Export orders as CSV – you can download a CSV file with information about your WooCommerce orders for a specified period of time.
- Export orders as XML – you can download an XML file with information about all your WooCommerce orders.
- Automate exports of orders to a spreadsheet – you can schedule exports of WooCommerce orders to Google Sheets or Microsoft Excel.
- Automate exports of orders to a database – you can schedule exports of WooCommerce orders to Google BigQuery.
Another option to export orders from WooCommerce that you may consider is using the WooCommerce API. However, this requires coding skills since you’ll need to write a script, deploy it as a web app, and connect to WooCommerce via a webhook. We’re no-code enthusiasts, so let’s not focus on this option below.
How to export orders from WooCommerce as CSV
- On the menu panel of WooCommerce, go to Analytics => Orders.
- Specify the date range for your orders. By default, you’ll export all orders for the specified period. However, you can also apply advanced filters to filter out orders, for example, by status.
- Scroll down to the list of orders and click Download. A CSV file with the information about your WooCommerce orders will be downloaded to your computer.
You can open it in Microsoft Excel or upload it to Google Sheets or another spreadsheet app. Here is what it looks like:
WooCommerce export orders as XML file
Let’s try another native method to export WooCommerce orders but in XML this time.
- On the menu panel of WooCommerce, go to Tools => Export.
- Tick Orders, then click Download Export File. An XML file containing information about your WooCommerce orders will be downloaded to your computer.
That’s it for the built-in options to export orders from WooCommerce. Now, let’s see the more advanced solution.
Set up a WooCommerce auto export of orders
You can export orders from WooCommerce automatically using Coupler.io. This is a data integration tool that allows you to schedule exports of data from different sources to Google Sheets, Excel, and BigQuery. This means you can have your WooCommerce orders automatically updated in your Google spreadsheet every day or at another custom schedule. Do the following to make this happen:
- Sign up to Coupler.io, click Add importer, and select WooCommerce as a source app. As a destination app, you can choose from Google Sheets, Excel, and BigQuery. In this example, we will export WooCommerce orders to Google Sheets.
Now, configure each of the apps accordingly.
- Connect your WooCommerce account.
- Select Orders as a data entity for export. Alternatively, you can import Orders with line items or an Order totals report.
Optionally, you can filter the exported orders from WooCommerce by the data range, status, or even a search string.
- Connect the account of the chosen destination app.
- If your destination app is Google Sheets or Excel, you’ll need to choose a spreadsheet and a sheet to export data to. For BigQuery, you need to specify a data set and a table. You can create a new sheet/table by entering a new name.
Optionally, you can specify the first cell or range to import your data and change the import mode (replace or append).
If you click Save and Run, information about your orders will be loaded to your spreadsheet or table right away. But we need to export orders from WooCommerce automatically – in this case, enable the Automatic data refresh and set up the desired schedule.
And this is what the exported WooCommerce orders look like in Google Sheets:
Compared to the WooCoomerce orders exported as CSV, here you have much more information, including taxes, billing and shipping address, payment method, etc.
Can I export WooCommerce orders with custom fields this way?
Yes! Coupler.io allows you to export orders from WooCommerce including their custom fields. Here is an example of an order with two dummy custom fields.
And this is what they looked like when we exported WooCommerce orders with Coupler.io:
How to export all WooCommerce orders
All of the described methods allow you to export all WooCommerce orders, but with a proviso:
- To export orders as CSV, it’s required to specify the data range. So, to get all your WooCommerce orders, make sure that this range covers the period from the very first order.
- If you export WooCommerce orders as XML or with the help of Coupler.io, you’ll get information about all your orders by default. With Coupler.io, you can filter orders by the date range, status, and even a search string.
Which option is the best to export WooCommerce orders from a database?
The choice of method depends on the purpose of exporting orders from WooCommerce. If you need to do this once, for example, to migrate to another eCommerce platform, then it’s better to use the built-in functionality.
However, for recurring exports, say for the purpose of doing proper WooCommerce analytics, Coupler.io is the best you can have. The reason is quite simple: you can automate data export from WooCommerce to your spreadsheet app and even database on a schedule. So, for example, you can automate WooCommerce export orders to Excel, and your workbook will automatically get the updated data every Sunday at 9:00 PM.
Besides, this tool lets you get an enhanced set of exportable data, which is not available with the native exporting functionality. Nevertheless, it’s up to you to make a choice, and we’re sure that it will be right for you. Good luck with your data!Back to Blog