Managing orders in WooCommerce is very easy, it has a clean layout and proper sorting options but it didn’t provide any export orders option by default. And exporting order data is crucial for any business. There are plethoras of reasons why someone wants to export order data.
You may need to export orders for taxation, evaluate the sale and make marketing strategies, calculate profits, also keep it safe if you ever lose access to your website or get into any hacking attack it is always preferable to store your data on multiple locations to keep it safe.
While WooCommerce lets you view your orders, they don’t have the best layout for getting an overall glimpse of the order data. You have to individually view the orders to check their details.
With the help of an order export plugin, you will be able to export the order data fields that you want to have a look over. This will help you analyze the data better and focus more on revenue-generating products.
In this article, we are going to show how to export orders from WooCommerce. We will be using the Advanced Order Export For WooCommerce plugin.
Installation of this plugin is the same as any other just go to the WordPress plugin section and search for “order export” and the first result should be this plugin install and activate. If you wanna know how you should install a plugin follow this tutorial.
Export orders
- Install and activate the Advanced Order Export For WooCommerce plugin.
- Navigate to WooCommerce -> Export Orders from your admin dashboard.
- You can choose how you want the data to be filtered in the Filter orders by option.
Then you can select the order date range under the Date range option. You can also export by entering a range of order numbers in the Orders range option.
You can then select the format of the exported file from various options such as XLS, CSV, JSON, etc.
In Set up fields to export you can add or remove any fields you don’t want in the export file. You can now change any other settings depending on your needs.
- Once done, click on the Export button and save the file.
Your orders are now exported in the file.
Filtering options
Basic exports are fine but those are kinda worthless if you can’t filter out the data you actually want or need. Thankfully this plugin has a lot of filtration options to filter out unnecessary data and only export what you need. We will go throw each of them one by one.
- The first filter option is Filter order by, in this filtration you can select how you want to order your data for filtering. You get four options in it.
- Order date: To order data by order date.
- Modification date: To order data by order modification date.
- Paid date: To filter data based on the Payment date.
- Complete data: To filter the data based on the order completion date.
- Now the second option is to actually select the date range based on the first choice. You can also select an order range to get specific data between dates. You also get an option to get a summary report of your orders.
- The next option is the file name, you can specify the file name in which you want your data to be exported. Along with the basic name, you also get advanced options to stitch time and date and other parameters in your exported data name.
- The next option is to select in which file format you need the data to be exported you can select any as per your need.
- After that, you get the option to sort the data order based on the order id or many other parameters you can also choose between ascending to descending order.
- After these, you get some more very advanced filtering options, which are listed below and their names are self-explanatory so you can use them easily.
- Filter by order
- Filter by product
- Filter by customer
- Filter by coupon
- Filter by billing
- Filter by shipping
- Filter by item and metadata
- And the second last option is Misc settings, where you can define some rules for your exported data. Also, specify if you need some extra formating or wanna get some extra fields. The best thing is you can use custom PHP codes to modify the exported data which is super amazing.
- Now the last option is to set up the fields of export, in this section, you can map the product fields as per your requirements. You can reorder fields, you can remove fields, and also add new fields. Basically, you can do whatever you want to modify in your field.
- Now the last thing is to export you can also see the preview of your export data to verify the filtration is as per your need. Also, save your filter setting for future exports and can export the data with a progress bar.
These are the options available in the plugin for free and unlimited usages and to be honest, most of you will be fine with it. In the pro option, you get more options along with schedule exports, multiple profiles, and so on.
Now you know how you can export orders from your WooCommerce website. If you face any issues while following this tutorial please let me know in the comment below.