How to Export Orders from WooCommerce

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

At times you will need to migrate the orders of your WooCommerce website, bulk update the information of the orders, want to add new order information to a website. Manually adding the orders is not practical and will eat up a lot of your time and take a lot of effort. When you have hundreds or thousands of orders on your website, the task becomes near impossible. So, the easiest way to accomplish this is by importing and exporting the order data.

You can easily export and import orders from WooCommerce store using Order/Coupons/Subscriptions Import Export plugin for WooCommerce. Using the plugin you can easily export all the data from your WooCommerce store. To know more about the plugin and its features visit the product page.

There are two file formats in which you can import or export the order data – in CSV format and in XML format. Let’s see how we can export the orders in each of these formats using this plugin.

Consider you have all your orders on your website as follows.order listing page

Exporting Orders in CSV Format

After you have installed Order/Coupon/Subscription Import Export plugin for WooCommerce on your website, navigate to the dashboard of the store and then WooCommerce > Order Im – Ex. The export section looks like the following.

export orders in csv xml formatIn the Export Orders in CSV Format section, fill in the following fields according to your requirements.

  1. Order Statuses:  Select order statuses for which you want to export orders from the given list:order-statuses
  2. Offset: Enter the order row number at which you wish to start the export.
  3. Limit: Enter the maximum number of orders that you wish to export.
  4. Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
  5. End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
  6. Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
  7. Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.

After all these columns have been filled, click on Export Orders. This will export all the orders into a CSV file and the file will be downloaded to your computer.Exported field

Export Orders in a CSV File from the Orders Page

You can directly export orders and order data individually from the WooCommerce orders page. To do that, navigate to Dashboard > WooCommerce > Orders. The Order page appears as shown below:Order page

  • Click Download to CSV button to export single order to CSV file.
  • To export bulk orders, select them. From Bulk Action drop-down list, select Download as CSV and click Apply. All the information about selected Order gets auto-downloaded to CSV file.

Exporting Orders in XML Format

You can export all the required orders by using the Export Orders option. The window is as shown below:export orders in xml format

  1. Select the Order Export Type as WooCommerce.
  2. Order Statuses:  Select order statuses for which you want to export orders from the given list:order statuses (1)
  3. Offset: Enter the order row number at which you wish to start the export.
  4. Limit: Enter the maximum number of orders that you wish to export.
  5. Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
  6. End Date: Select the date till which you want to export the orders by clicking on the calendar icon.

After you have filled in all the required fields, click on Export Orders. This will export all the orders and the data related orders into an XML file.Exported-XML

Export Order(s) from Order Page

You can directly download the export file with all the fields. To do that, navigate to Dashboard > WooCommerce > Orders. The Orders listing page appears as shown below:orders page 3

  • Click Download to WooCommerce XML button to export single order to an XML file.
  • To export bulk orders, select them. From Bulk Action drop-down list, select Download as WooCommerce XML and click Apply. It is shown as shown below:bulk action list

All the information about selected Orders gets auto-downloaded to an XML file.

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *