%%tb-image-alt-text%%

How to Export WooCommerce Orders

How to Export WooCommerce Orders

Author: Wayne Williams

Date: April 7, 2022 

Category: Ecommerce, Guestposts, Tutorials

Exporting WooCommerce Orders — Basic Steps

Exporting WooCommerce orders is one of those tasks that can be as simple as saving a word processing document or as complex as creating your own custom PHP code and XML feed.

The beauty of the WP All Export plugin is that it can handle this full spectrum of tasks quickly and efficiently.

For example, to perform a simple export, all you need to do is follow these steps:

  1. In the WordPress main menu, click WP All Export > New Export and choose WooCommerce Orders.
  2. Use a drag & drop interface to select your desired WooCommerce order fields (or choose them all).
  3. Run the export.
  4. Download your export file.

That's it. You can literally complete this task in seconds!

But what if you need to do a little more?

Customizing WooCommerce Order Export Columns

Not happy with the order fields as they are? Want to change them in some way?

WP All Export lets you modify your order export columns in numerous ways. You can start by using the drag & drop tool to combine fields into a new field. For example, you can combine the Billing First Name and Billing Last Name fields into a new field called "Name".

Or you can use the PHP function editor to create a function. For example, the following function assigns a shipping method based on shipping weight:

function output_shipping($weight){
  if($weight <= 10) {
    return "USPS";
  } else if ($weight > 10 && $weight < 30) {
    return "DHL";
  } else if ($weight >= 30) {
    return "Knight-Swift Freight";
  }
}

Then you can just reference the function in a custom field definition like this:

[output_shipping({Weight})]

With access to the conditional logic of PHP, there are no limits to your ability to customize your export fields.

Filtering Your WooCommerce Order Exports

One of the most common tasks beyond a simple WooCommmerce order export is the need to filter order records.

WP All Export provides numerous tools and features to do this, as follows:

  • An interactive filter tool that allows you to set simple filters like orders for specific customers or products
  • An advanced date filter capability that includes the ability to create relative date filter criteria such as "last month" or "- 2 years"
  • The ability to combine filter conditions
  • The ability to create nested filters to combine AND/OR conditions
  • Create filters using PHP
  • Build filters using WP_Query

Again, there are virtually no limits to your filter capabilities.

A Broad Range of Other Order Export Capabilities

The most appealing aspect of WP All Export is how complete it is as an order export tool. In addition to the features already described in this article, you can:

  • Automatically export one order at a time as it is created
  • Schedule your order exports to run automatically when you want them to run
  • Export your orders in different languages using WPML
  • Export your orders to different file types including CSV, Excel, and XML
  • Split large exports into multiple batches and files to avoid overloading your server
  • Include customer data, product data, and even include data from any extensions, add-ons, or other plugins
  • Integrate with external apps using Zapier
  • Enjoy full developer support including an Add-on API and WP-CLI

And you get all of this, including free updates and world-class support, for one payment that lasts a lifetime, i.e. no renewal fees!

For more information on WP All Export's order export features, see Export WooCommerce Orders to XML & CSV.

For a simple walkthrough tutorial, see How to Export WooCommerce Ordes to CSV, Excel, or XML.