3 easy ways to WooCommerce export orders as CSV file?

If you have been managing an online store for some time and the number of your orders has increased with the growth and development of your store, you probably need to WooCommerce export orders list. There are many reasons for WooCommerce export orders; for example, you may want to transfer data related to orders from the old site to a new one. Or maybe you decided to edit some features of the orders in the Excel file and import them to your website again. For whatever reason you need to WooCommerce export orders, the step-by-step guide in this post will help you do this task easily in the following three ways:

1. WooCommerce export orders without plugin to CSV file
2. WooCommerce export orders without plugin to XML file
3. WooCommerce export orders using a plugin

If you’re not sure which method is best for you, continue reading to get familiar with them in detail.

Method #1: WooCommerce export orders without plugin to CSV file

WooCommerce is a great solution for collecting and storing detailed order information. It is also possible to WooCommerce export orders as a CSV file or an XML file.

But WooCommerce export orders free is very limited – especially if your online store has a lot of orders.

Anyway, if you decide to use the WooCommerce export orders without plugin to CSV file method, go to the WooCommerce > Orders page and ensure some orders have registered in your store. Then, take a backup of your WooCommerce store database to restore data in case of any problems.

Now follow the steps below for WooCommerce export orders as CSV file:

Open the WooCommerce orders report page

Navigate to the following address in the WordPress Dashboard 

WooCommerce > Reports > Orders

Filter WooCommerce orders

In the WooCommerce orders reports page, you can just filter the orders based on date. You have to choose one of the below options:

• Year: To filter all orders registered in your store this year.
• Last month: To filter all the orders registered in your store in the last month.
• This month: To filter all the orders registered in your store in the current month.
• Last 7 days: To filter all orders placed in your store in the current week.
• Custom: To filter all orders registered in your store in the date range you need.

Once you set the filters, click on the Go button to see the orders report in the chart.

WooCommerce export orders

After generating the WooCommerce orders report, you can easily export them to a CSV file by pressing the Export CSV button on the top right corner of the page.

The CSV file is automatically downloaded and saved to your system.

Method #2: WooCommerce export orders without plugin to XML file

Now let’s review the steps to WooCommerce export orders as XML file together:

1. Go to the below address in the WordPress Dashboard:

Tools > Export

On this page, you can export various data, including posts, pages, products, etc.

For some of these data, such as posts and products, there are several options for filtering. Unfortunately, no filter option has been considered for the orders option.

Therefore, you can go to the next step without any additional tasks.

2. Mark Orders from the list.
3. Press the Download Export File button.

As soon as you click on the “Download Export File” button, all orders and related data will be downloaded as an XML file and saved in your system.

You are probably surprised that you cannot customize the output data by choosing the WooCommerce export orders without plugin method. Limited filters and the inability to select specific orders make these methods impractical for managing real orders on websites that receive a large number of orders.

For this reason, most WooCommerce site managers use the WooCommerce export orders plugin to export orders. If you want to know the best plugin to WooCommerce export orders as CSV file, continue reading.

Method #3: WooCommerce export orders using WooCommerce orders bulk edit plugin

If you want to filter and export WooCommerce orders in a customized way, the WooCommerce orders bulk edit plugin is your ultimate solution. With this plugin, you will be provided with all the necessary tools to edit and manage WooCommerce orders. Therefore, in addition to custom export orders, it is possible to bulk edit order status, address, customer name, order amount, and other WooCommerce order fields with one click.

Let’s review the steps for advanced order export for WooCommerce with this plugin.

Step 1: Download and Install WooCommerce orders bulk editing plugin

You must download and install the WooCommerce orders bulk editing plugin to your WordPress website in a few minutes. After activation, all WooCommerce orders are imported to the plugin, automatically and you need to navigate to the below address to see them in the order table of our plugin:

WordPress Dashboard > IT Bulk Editing > Woo Orders

In addition to the order table, we designed a comprehensive toolbar on the top of the table including all required tools for order management like bulk editing, filtering, exporting, and many more.

Step 2: Filter WooCommerce export orders list

As we mentioned in the first and second methods, filtering options of WooCommerce default export methods can not meet the store manager’s requirements. To solve this problem, the WooCommerce orders bulk editing plugin comes with a useful Filter Form that supports all WooCommerce order fields and custom fields. Getting help from this Filter Form lets managers limit the WooCommerce export orders list.

To use this form for filtering orders, you just need to open the Filter Form by pressing the related icon in the toolbar, as illustrated below.

Then you can open one of the tabs like General, Billing, Pricing, etc, and set as many filters as you need in the fields of filter form.

Finally, by pressing Get Orders, you can see the list of filtered products in the table.

Step 3: WooCommerce export orders 

After filtering the orders, to WooCommerce export orders with our plugin, click on the Import/Export button in the toolbar:

In the Import/ Export form, you can choose one of the options from Orders and Fields based on your needs as follows:

1. All orders in table / All fields
2. Only selected orders / All fields
3. All orders in table / Only Visible Fields
4. Only selected orders / Only Visible Fields

 then press Export Now to export orders as CSV file.

To help you choose the right option in Orders and Fields, let’s review them individually:

All orders in table / All fields

This option is useful when you need to export all WooCommerce orders that you have filtered before with the data related to all WooCommerce order fields. 

For example, suppose that you need to export the data of all fields related to the WooCommerce orders of customers whose their billing city is New York. So, to WooCommerce export orders and customers, try the below steps:

• Go to the Filter Form and open the Billing tab.
• Locate Billing City and choose Exact from the dropdown list of operators.
• Write New York in the textbox

• Click on the Get orders button.

Now, you can easily open the Import/Export form and mark All orders in table / All fields in the Orders and Fields sections, respectively. Press Export Now to download your filtered WooCommerce orders in CSV file.

Only selected orders / All fields

These options are helpful when you want to export some of the WooCommerce orders you have filtered before. 

Let’s try this option with the three first orders of the previous example. To make this happen, you just need to mark the first three orders in the table and then go to the Import/Export form. Now, by choosing Only selected orders / All fields and pressing Export Now, all data related to the selected orders will be exported in a CSV file.

All orders in table / Only visible fields

This option is practical when you want to export the data of some specific order fields related to the filtered orders in the table. 

For example, let’s try to export the below information for the customers we have filtered in the previous example:

• Order Date
• Status
• Order Total
• Billing First / Last Name
• Billing Phone

To make this happen, follow the below steps:

• Open the Column Profile form by clicking in the below icon of Toolbar.

• Mark the mentioned fields in the form.
• Press Apply to Table button.

• Open the Import/Export form and mark All orders in table / Only Visible Fields in the form.
• Press the Export Now button.

Only selected orders / Only visible fields

This option is almost the same as the previous one, except you can select some WooCommerce orders in the table to export some of their data in a CSV file.

For example, for WooCommerce export orders with custom fields, you can add custom fields to the orders table by using the column manager. Then, mark some of the orders in the table and try to export their data by selecting Only selected orders / Only Visible Fields in the Import/Export form.

Conclusion

In this post, we show you how to export WooCommerce orders with two methods. If you’re just looking for basic order information and don’t mind manually exporting reports whenever needed, use WooCommerce ‘s default export order methods.

However, If you’re looking for a quick and easy way to get customized order information, you can use the WooCommerce orders bulk edit plugin. In addition to the custom export orders feature, this plugin has other unique features for managing and bulk editing all fields of WooCommerce orders.