There are numerous reasons why you need to export orders in WooCommerce. Sending orders to an external warehouse, shipping company, or analyzing sales may be some of them. Today, you’ll see how to export orders from WooCommerce to CSV (Excel supported), XML, or JSON file types.
Table of contents
- Default WooCommerce options vs Advanced export
- Order export with extra features
- Export orders from WooCommerce - step-by-step guide
Default WooCommerce options vs Advanced export
By default, you can use built-in WooCommerce options.
Export orders to CSV in WooCommerce (standard option)
First, you may export orders to CSV (in Analytics → Orders filtering orders for the exported file:
The first method gives you a CSV file with the following columns:
Date, Order #, Status, Customer, Customer type, Product(s), Items sold, Coupon(s), and Net sales.
As you can see, the information range is rather limited. You won’t see shipping and taxes in the Net Sales. And you can’t adjust the columns in the exported CSV file 🙁.
Export orders to XML in WooCommerce (standard option)
You may also use the second built-in method in Tools → Export. Choose Orders and click on the Download Export File button.
The XML file will contain all orders with postmeta, but you will not see items of the order, just billing, shipping, notes, and other postmeta information. That method lacks crucial information!
OK. Let’s see what is possible with the plugin 🙂!
Export WooCommerce orders to CSV/ XML in WooCommerce (plugin)
Using Dropshipping Orders Export for WooCommerce you may choose columns and dataset you want in your CSV or XML export files 💪! So, you export what you need.
You can also choose the export file format (CSV, XML, or JSON). Let’s see the example with a JSON file to see at once the exported data. We got all items of WooCommerce orders:
I will show you the export process in a while. But first, let’s see why you may want to choose the plugin.
Order export with extra features
As you’ve seen, the 2 default WooCommerce export options are limited. You will get more flexibility and export settings with the plugin, for example:
- choose the data and columns to export
- rearrange the file structure
- decide about the export file format (CSV, XML, JSON)
- export WooCommerce orders based on order status, billing email, order currency, date, total amount, product name, product category, product SKU, or product tag
- change the order status after the order export
- choose the CSV separator
- set automatic order export based on a schedule
- send the exported file by email
The plugin gives you those features 🎉! See all options on the product page:
Dropshipping Orders Export for WooCommerce £79
Export orders from WooCommerce to CSV, XML or JSON files in an easy way. With Dropshipping Export Orders for WooCommerce, it's child's play!
💾 Active Installations: 1000+ | 🔄 Last update: 2024-08-19
Export orders from WooCommerce - step-by-step guide
OK. To export orders from WooCommerce to CSV, XML, or JSON, follow these steps:
-
Install and activate the plugin
After purchasing the plugin, install the extension in your WordPress → Plugins by uploading the plugin zip.
Next, activate the plugin. -
Add your first export
Go to the Dropshipping Export Orders tab (above WooCommerce) and click create new 🚀.
-
Choose the export file format
💡 You can export WooCommerce orders to CSV (Excel), XML, or JSON files.
-
Set advanced conditions for exported orders
In the next step, you may select one or multiple rules (conditional logic). For example, you can decide to export orders above a certain order total, specific currency, or WooCommerce order statuses ⚙️.
-
Export Mapper
Select specific data for exported orders and arrange the data (columns in CSV, nodes in XML, or order in JSON). Map the WooCommerce Data with the field names in the exported files.
-
Use export options
Almost finished 🙂. In the final step before running the order export, you can name the export, choose a separator for the CSV file, automatically change the order statuses, and set the cron schedule ⏱️.
You may even send the exported file to a specific server location, or send an additional email with the export.
-
Run the order export
Finally, the plugin will export WooCommerce orders based on the settings and conditions we’ve set.
That’s it! Now, you can download the exported file.
-
Export files
If you need to download previously exported orders, go to the Export Manager tab and get the files.
Why export WooCommerce orders to XML or JSON?
It depends on your needs, the program for managing the export file, or the external (warehouse) software you will use to import your WooCommerce orders.
The Dropshipping Orders Export for WooCommerce plugin lets you export WooCommerce orders in CSV, XML, and JSON.
The plugin has also a useful feature to export orders automatically based on a schedule.
Summary
Today, you’ve learned how to export orders from WooCommerce to CSV (Excel), XML, and JSON with a plugin. See the plugin page and test the plugin in a free demo 🙂.
Dropshipping Orders Export for WooCommerce £79
Export orders from WooCommerce to CSV, XML or JSON files in an easy way. With Dropshipping Export Orders for WooCommerce, it's child's play!
💾 Active Installations: 1000+ | 🔄 Last update: 2024-08-19
If you have any questions leave a comment below.
