How to Export Orders in WooCommerce

Are you looking for an easy way to export your WooCommerce orders? In this guide, we will show you how to easily export orders from your online store and keep your data safe.

Why Export WooCommerce Orders?

There are a couple of situations where you may need to export your WooCommerce orders:

  • When saving the data to local storage
  • If you’re migrating an existing store to a new one
  • When changing your hosting service

Having a backup of your customer orders is always a good idea. Orders contain essential information such as customer name, email address, order ID, billing and shipping address, and so on. So, instead of relying on your web server, you can always download a copy of this data to your local computer or any third-party cloud services like Dropbox or Google Drive.

Alternatively, when you are moving your store to another domain or hosting company, you’ll need to export your orders. Once you have installed and set up WooCommerce on your new site, you can import the orders from the old store and keep everything up and running.

Exporting WooCommerce orders isn’t hard but it’s a delicate process that involves valuable information, so it’s important to do it well from the start. The good news is that you don’t need to hire a developer for it. In this tutorial, we’ll show you how you can export WooCommerce customer orders safely in less than five minutes.

How to Export WooCommerce Orders

To export orders from your store, you’ll need a dedicated WooCommerce plugin. In this section, we’ll show you how to export orders step-by-step using two different plugins, but there are many other tools that you can use. For more information, check out our guide on the best plugins to export orders in WooCommerce.

1) Advanced Order Export For WooCommerce

First, install and activate the Advanced Order Export plugin on your WooCommerce store. Since this is a freemium plugin, you can get the free version from the WordPress repository or one of the premium plans from their official site. To export orders, you only need the free version so that’s what we’ll use for this tutorial.

Installation and Activation

In your WordPress dashboard, go to Plugins > Add New and search for Advanced Order Export for WooCommerce. Install the plugin and then activate it.

install advanced order export plugin - export orders in woocommerce

After that, navigate to the WooCommerce settings and press Export Orders.

export orders

Plugin Configuration

The plugin comes with many features. At the top of the screen, you’ll see some options to filter orders by order or modification date, as well as paid and completed date.

export orders in woocommerce - filter orders by

Additionally, you can also filter the orders based on custom dates. This is a great feature when you need to export certain orders from your store.

export orders in woocommerce - order based on date range

You can also choose the format of the file you’ll export.

  • XLS
  • CSV
  • XML
  • JSON
  • TSV
  • PDF
  • HTML

export format

On top of that, you can filter your store orders based on different options such as:

  • Product
  • Customer
  • Coupon
  • Billing
  • Shipping
  • Item and metadata

filter orders

Finally, you can also sort the orders in different ways. Once you have configured the tool to export the order you need, press Export.

export woocommerce order

The plugin will generate a report for you that may take more or less time depending on the number of orders you have.

order export file

That’s it! Now you can open the file with all your exported orders.

2) Order Export & Order Import For WooCommerce

Another excellent plugin to export WooCommerce orders is Order Export & Order Import. It has a free version with basic features and three premium plans that start at 69 USD per year.

Installation and Activation

First, you need to install and activate this tool on your site, so in your WordPress dashboard, go to Plugins > Add New and look for Order Export & Order Import for WooCommerce. Then, install it and activate it.

Order Export & Order Import for WooCommerce installation

After that, you will see some new settings under WooCommerce in the sidebar.

Plugin Configuration

To export your customer orders, go to the Order Im-Ex.

order import export settings

From here, you can export/import your customer orders. In this section, we’ll show you how to export orders, so choose the date range you want and press Export Orders.

export order CSV

The plugin will create a custom CSV file with your WooCommerce orders that you can use. As you can see, this tool doesn’t have as many options as Advanced Order Export but it’s easy to use and gets the job done.

woo customer orders

After you export orders from your WooCommerce store, you’ll probably need to import them to another store. Let’s see how to do that.

How To Import Orders in WooCommerce

To import orders, you’ll need the Order Export & Order Import plugin, so first, log in to your store and install it. As you’ll import orders, you’ll need to use the import function, so click Import Orders.

import woocommerce orders

Then, choose the CSV file you have downloaded in the previous step, and press Upload file and import.

upload and import

The plugin will start importing your orders and once it finishes, it will show you the detail of the orders it imported. If you have many orders, this may take a few minutes, so be patient.

order import finished

After that, let’s verify that everything went well, so go to WooCommerce > Orders and see if the orders appear there.

orders imported

You have successfully imported all your WooCommerce orders. This way, you can easily export and import orders to your eCommerce store.

How To Export WooCommerce Products

If you’re migrating your store, apart from exporting your orders, you’ll probably have to export your products too. Let’s see how to do it in a few steps. For this demonstration, we’ll use the built-in WooCommerce exporter.

In your WordPress admin dashboard, go to Products > All Products and click Export.

You’ll be able to export products based on columns, product types, and categories. Once you configure what you want to export, simply press Generate CSV and that’s it.

For more information about details on this process and the plugins, you can use, check out our full guide on how to export products in WooCommerce.

How To Export Customers in WooCommerce

Another important element when migrating your store is to export your WooCommerce customers. To do this, you’ll need a plugin, so let’s see the process using Import and Export Users and Customers.

First, install and activate the plugin on your WooCommerce store.

import and export woocommerce customers - install plugin

After that, you will have a new section called Import and export users and customers under the Tools section. Go there and navigate to the Export tab.

import and export woocommerce customerse - export customers

Select the roles and dates you want and press Download to create a CSV file with all your customers.

Additionally, this plugin also allows you to import your users. For a detailed step-by-step guide, check out our tutorial on how to import and export customers in WooCommerce.

How To Autocomplete Orders

One interesting option to increase your conversion rates is to autocomplete orders on your store and avoid having pending orders for hours. This is an excellent alternative especially for stores that sell virtual and downloadable products. Let’s see how you can autocomplete WooCommerce orders and increase sales.

The easiest way to do it is by using a plugin. For this demonstration, we’ll use AutoComplete WooCommerce Orders

First, in your WordPress dashboard, go to Plugins > Add New and search for this plugin. Then install it and activate it.

Then go to WooCommerce > Settings > Autocomplete orders. There, you will be able to select the type of order you want to autocomplete:

  • Paid orders of virtual products only
  • All paid orders of any product
  • Any order (paid or unpaid)

plugins to autocomplete woocommerce orders -autocomplete orders settings

To complete the configuration, you’ll need a PayPal token, so set up a PayPal data transfer token here. It will help the plugin mark the verified orders. You need to use a PayPal business account.

Go to the PayPal settings and seller tools and choose the Business preferences option. Turn on the auto-return feature and scroll to the bottom where you will see the personalized identity token. Additionally, turn on the data transfer from the same screen. Now copy the token and place it somewhere handy. 

After that, you need to set up the PayPal data transfer token on your WooCommerce store, so go to the Payments tab. You will see the PayPal payment processor there. Click Manage, paste the PayPal identity token in the appropriate field and save the settings.

That’s it! From now on, the plugin will take care of the rest and automatically complete the orders.

For a more detailed explanation of the process, check out our guide on how to autocomplete WooCommerce orders.

autocomplete woocommerce orders - autcomplete preview

Conclusion

All in all, there are a few situations where you may have to export orders in WooCommerce:

  • When you want to save the data to a local storage
  • If you’re migrating an existing store to a new one
  • When you’re changing your hosting company

The easiest way to do this is by using a dedicated order export plugin. In this guide, we’ve shown you how to export orders using two different tools:

  1. Advanced Order Export for WooCommerce
  2. Order Export and Order Import

Both plugins make exporting orders quite simple. Once you install the plugin, you can start exporting custom orders based on your interests. Both are freemium tools and have different pros and cons. Advanced Order Export has more options to filter the orders you want to export but doesn’t allow you to import orders. The Order Export and Order Import plugin, on the other hand, doesn’t offer as many options but includes features to import orders in a few clicks.

If you want to have a look at other tools to export WooCommerce orders,  check out our list of the best plugins.

We hope you enjoyed the post and found it helpful. Please consider sharing it on social media and keep an eye on our blog for more useful content.

Have you ever exported orders from your store? Which tool did you use? Let us know in the comments section below.