How to Export WooCommerce Orders and Products (Using free plugins)

Last updated on September 11, 2021

How to Export WooCommerce Orders and Products (Using free plugins)

Orders and products are the two core elements of any online store. While WooCommerce offers minimal functionality to export products using CSV, orders can’t be exported using CSV by default in WooCommerce.

This article will help you learn about the ways you can export orders and products to CSV in a few simple steps using free plugins.

Read ahead to find out how.

How to Export WooCommerce Orders?

Here you can learn how to export WooCommerce orders to a CSV using the Order Import & Order Export plugin for WooCommerce.

Step 1 : Download and install the plugin.

From your WordPress dashboard navigate to the menu WebToffee Import-Export (Basic) and click on the submenu ‘Export’.

Step 2 : Select the post type as ‘Order’ 

select a post type to export orders

The post type should be selected since the plugin supports the import and export of coupons as well.

Step 3 : Choose an export method

select an export method to export orders

You can choose either quick or advanced export. In quick export, the export will be done with a single click. You can export all the basic fields associated with orders.

Whereas in advanced export the data will be exported after a detailed process of data filtering/column selection/advanced options that may be required for your export. You can also save this selection for future use with the pre-saved template option. 

For those who choose quick export the steps stop here. You will be able to download a CSV of your store’s orders.

If you are choosing advanced export, you will be taken to the next step filtering orders for export.

Step 4 : Filter orders

filters for exporting orders

Here you can export orders based on order status, product, customer, coupons, and date range.

You can choose one or a combination of filters.

For example, say you need to export all orders in your store having the status ‘Completed’ and placed by a specific customer.

For this, you can select completed status and the customer name from the drop-down corresponding to them. 

If you need scheduled exports, order meta, and subscription support, etc., you can try the pro version of the plugin. 

Step 5 : Mapping and Renaming of CSV column headers

Within the mapping section, you can view the default column headers for your CSV file corresponding to the WooCommerce order fields. You can rename the column headers as your preference or change their order by drag-and-drop. 

Step 6 : Export

Once you click the export button all the exported order data will be available for download.

Other Free Plugins to Export Orders from WooCommerce

Following are some of the other fee extensions available to export your WooCommerce store orders. Let us find out more about them.

Advanced Order Export for WooCommerce

Advanced Order Export for WooCommerce lets you export orders into different file formats. XLS, CSV, TSV, PDF, HTML, XML and JSON formats are supported by the plugin. It comes with a bunch of powerful export filters. Automated export, custom field export, etc., are supported in the pro version of the plugin.

WooCommerce – Store Exporter

Store Exporter for WooCommerce allows you to export orders to CSV. It is ​​compatible with WordPress multi-site. more advanced features are available in the pro version.

WooCommerce Flexible Order Export

This WooCommerce Flexible Order Export plugin Export Orders from WooCommerce into Excel and CSV. It provides filters to get exactly the orders you are interested in and lets you export metadata and fields from other plugins. 

How to Export WooCommerce Products

Here you can learn how to export WooCommerce products to a CSV using the Product Import Export plugin for WooCommerce.

Step 1 : Download and install the plugin.

From your WordPress dashboard navigate to the menu WebToffee Import-Export (Basic) and click on the submenu ‘Export’.

Step 2 : Select the post type as ‘Products’ 

select a post-type to export products

The post type ‘Product’ should be selected from the drop-down for export to work. 

Step 3 : Choose an export method

select an export method for products

You can choose either quick or advanced export. In quick export, the export will be done with a single click. You can export all the basic fields associated with orders.

Whereas in advanced export the data will be exported after a detailed process of data filtering/column selection/advanced options that may be required for your export. You can also save this selection for future use with the pre-saved template option. 

For those who choose quick export, you have no more steps to follow. You can download a CSV of your store’s products by clicking the export button. 

If you are choosing advanced export, you will be taken to the next step where filtering of products will take place. 

Step 4 : Filter Products

filters for exporting products

Within the filtering section, you can export products selectively. The plugin provides you with the option to export by-products, category(s), tags, product status, the total number of products, etc. You can choose one or more filters to export the desired list of products. 

Step 5 : Map CSV columns

Within the mapping section, you can view the default column headers for your CSV file corresponding to the WooCommerce product fields. You can rename the column headers as per your preference or change their order by drag-and-drop. 

Step 6 : Export

Once you click the export button all the exported product data will be available for download.

Conclusion

The import and export of orders and products will need to be done on a frequent basis for online stores. When the default functionality doesn’t offer much support, the right course of action is to go for extensions that support this. Hope the above guide helped you understand how you can achieve it with plugins.