WP All Export: A Complete WooCommerce Export Tool
If you need to export your WooCommerce data, it can be tricky to find the right tool. This is because even though WooCommerce has a built-in import/export tool, it only supports WooCommerce products and not customers or orders.
You can try extracting the data from the WordPress database or writing custom code, but this can get messy, especially when dealing with complex data relationships.
Most users turn to 3rd-party plugins to perform these tasks. In this article, we’re going to show you how to export products, customers, and orders using WP All Export.
You can follow along in a free sandbox at: https://www.wpallimport.com/try/. Select WooCommerce Store and click Create Sandbox. This takes a few minutes to configure itself but will provide you with a complete working environment.
How to Quickly Export WooCommerce Products
Why would you need to export your WooCommerce products? It could be that you need to send your product information to other sale channels or platforms, or you may need a full report with the items that can be purchased in your store.
Whatever the reason, follow the steps below.
Step 1: Select to Export WooCommerce Products.
Navigate to All Export › New Export in the WordPress main menu. In the New Export screen, select WooCommerce Products from the dropdown list.
WP All Export will show the number of products to export. Continue by clicking on the blue Customize Export File button.
Step 2: Choose What WooCommerce Product Data to Export
The Drag & Drop screen will appear next. Here you can choose which data fields to export by dragging them from the Available Data panel on the right into the column selection area:
Once the export template has been set up correctly, click on the blue Continue button at the bottom.
Step 3: Run and Complete the Export
Next up is the Export Settings screen. Here, you can configure Scheduling Options, which are used to automate an export so that it happens regularly on a fixed schedule.
You can also configure Advanced Options, such as exporting the products only once or generating multiple export files.
In this case, just click on the green Confirm & Run Export button at the top right.
Once the export is finished, you will see a confirmation screen like this:
In the Click to Download section of this screen, click the blue CSV button to download your file.
And that’s it! For a simple export, you can complete this task in less than a minute. However, WP All Export is capable of performing far more sophisticated exports that include:
- exporting data in simple or custom XML formats
- creating a complete Google Shopping product feed
- exporting all product data, even custom data from other product-related plugins
- integrating product exports with external applications using Zapier
- supporting a robust bulk edit process for product data
- integrating with WP All Import to quickly and easily migrate products from one WooCommerce store to another
For information on these and other product export capabilities, see Easily Export WooCommerce Products to XML & CSV.
Export WooCommerce Customers
Following the previous example, you can also export WooCommerce customer data.
Everything that was explained above about exporting products also applies when exporting WooCommerce customers. In summary, here’s what needs to be done:
In Step 1, select to export WooCommerce Customers instead of products.
Click on the Customize Export File button to proceed to Step 2 and configure the export file structure.
For this export, in addition to the default fields, we also need the number of orders made by each customer along with its country. To export this data, include the _order_count custom field (found under Available Data › Custom Fields) and the Shipping Country field (found under Available Data › Address).
Click the green Preview button to make sure that you have the data you need:
Close the preview and click the blue Continue button to proceed to Step 3.
In the Advanced Options of this step, you can enable an option to export only those customers who have made a purchase on your site, as shown below. This will cause WP All Export to update the number of customers that’ll be exported.
This is just one example of how WP All Export can help you refine your exports.
To finish and run the WooCommerce customers export, click on Confirm & Run Export, then download your file as before.
For more information on exporting WooCommerce customers, see Export WooCommerce Customers to XML & CSV.
Export WooCommerce Orders
You can also export WooCommerce Orders with WP All Export. The previous instructions for products and customers also apply here.
However, let’s say that you offer free shipping in your store and you need a list of orders that are above $30 because those are the orders that will incur actual shipping charges.
Here’s what you need to do to export such orders:
Step 1: Select to Export WooCommerce Orders
Go to All Export › New Export. Then, select to export WooCommerce Orders from the list of available post types to export.
The number of orders to export will appear in green. To export just the orders with a total above $30, click on Add Filtering Options and add a rule as follows:
Element: Order Total
Rule: equal to or greater than
Then, click on Add Rule to complete adding this rule. The number of orders to export will update.
Once done, click the blue Customize Export File button at the bottom.
Step 2: Customize WooCommerce Orders Export File
As with the other exports, the Drag & Drop screen appears where you can decide which data from your orders should be exported.
In this case, we want to generate a report that contains all order data, so we click on Add All.
By default, orders with multiple products will export each product in its own row. However, since we only need a report of orders above $30, we will disable this to show each order on a single row, regardless of the number of products within that order.
To do so, click on Advanced Options and then disable the checkbox Display each product in its own row.
Click Continue at the bottom to move to the Export Settings screen.
Step 3: Review Export Settings and Execute WooCommerce Order’s Export
Here you can set up Scheduling Options to run this export automatically, and also change different Advanced Options.
In most cases, changing the default settings won’t be necessary. Proceed to click on Confirm & Run Export.
Once the export is complete, you can download the exported file with all of your filtered WooCommerce Orders.
Here’s a preview of the orders that we exported:
For more information on exporting WooCommerce Orders, see Export WooCommerce Orders to XML & CSV.
In this article, we have shown you how to export WooCommerce products, customers, and orders using WP All Export.
We have kept these scenarios simple so that you can get a sense of how WP All Export works without getting bogged down in the details. But we have just scratched the surface of its capabilities. Its greatest strength is its ability to handle a complete range of WooCommerce exports from simple tasks that require only a few seconds to the most complex export tasks imaginable.
This is the advantage of dealing with a company that has been building WordPress/WooCommerce import/export plugins since 2011 and remains solely dedicated to that cause.