Export WooCommerce Orders and Products (Using Free Plugins)

Exporting orders and products are sometimes essential for platform migration, analysis, or reporting. This article guides you on exporting WooCommerce orders and products using a free plugin.

WooCommerce is undoubtedly a powerful solution for running your online store. However, when it comes to exporting order and product data, the core WooCommerce plugin won’t be sufficient. WooCommerce offers minimal functionality for exporting products and orders. But for selective export and export filters, you must go for third-party plugins.

This article will introduce you to some such plugins and how they help you export WooCommerce orders and products.

Read ahead to find out.

📌

Key Takeaways

  • Exporting orders and products is essential for platform migration, data analysis, and reporting tasks.
  • While WooCommerce is a robust platform, its export capabilities are restricted. You will need third-party plugins to achieve selective exports or implement advanced filtering.
  • WebToffee offers a variety of plugins, including order and product export, specifically designed to improve WooCommerce’s export capabilities and make it easier to handle order and product data.

How to Export WooCommerce Orders Using Order Export Plugin (Step-by-step Guide)

To export orders from your WooCommerce store, you can use the free WooCommerce order import export plugin to your site.

In addition to exporting orders, the plugin allows you to:

  • Import orders
  • Export order items as single-column, multi-column, or multi-row data
  • Bulk update order data
  • Export, import, and update coupons
  • Bulk add coupons

The following is a step-by-step process for exporting orders using this plugin.

Step 1: Install & Activate WebToffee WooCommerce Order Export Plugin

First, you must install and activate the plugin on your WordPress website from which you export users. 

From your WordPress dashboard,

  • Go to Plugins > Add New
  • Search for the “Order Import Export” plugin by WebToffee. 
  • Once you’ve found the plugin, click on Install Now. Then, Activate the plugin.
Order Export & Order Import for WooCommerce Plugin

Step 2: Select Order as the Post Type to Export

After installing the plugin,

  • Go to WebToffee Import Export (Basic) > Export
  • Choose Order as the post type to export from the drop-down.
  • Proceed to the next step.
Selecting order as post type

Step 3: Choose An Export Method

Choosing order export method

The plugin offers you two different methods for export: Quick export and Advanced export.

While quick export allows you to export in a single click, advanced export lets you apply filters, choose what fields to export, in what order, etc.

Advanced export will be the default option within the plugin. But you can choose whichever method you prefer.

Step 4: Apply Filters for Custom Order Export

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, if you need to export all orders in your store with the status ‘Completed’ and placed by a specific customer,

You can select the completed status and the customer name and then export the orders.

Filtering order data for export

Step 6: Rename & Reorder Order Export Fields

You may not want to export all the order fields. The order data you need to export may vary depending on the purpose of the export.

The plugin allows you to choose the order fields you need to export and offers options to rename and reorder them.

You can deselect the fields that need to be excluded from the export, rename the field name/column header, and even drag and drop the fields to re-order them in the export file.

Note: The columns get automatically mapped if the input file has matching header names. You can easily view the mapped columns by scrolling through the drop-down menu.

Mapping and reordering of order export columns

Once done, proceed to the next step.

Step 7: Configure Advanced Order Export Options

Here are some advanced export options. Choose the options that fit your requirements.

After making the necessary changes, click the Export button to export the Order data.

Exporting orders

Once the export process is complete, you will see a dialog box with the option to download the CSV file.

If your export fails due to a time-out, you can lower the batch number and try again.

💡

Quick Tip: Save your export settings as a template for quick reuse during frequent exports. 

Upgrading to the premium version of the WooCommerce Order Export and Import plugin allows you to import and export subscription orders, handle different file formats (CSV, XML, Excel), and even set up automated exports to run on a specific schedule.

Order, Coupon, Subscription Export Import for WooCommerce (Premium)

Order Coupon Subscription Import Export for WooCommerce Plugin

The premium version of the WooCommerce Order Import Export plugin enhances the free version with powerful features and advanced settings that facilitate seamless data migration. It offers a variety of options for importing and exporting orders, along with advanced filtering capabilities for greater precision, making it perfect for exporting orders from specific customers.

Key features:

  • Multiple methods for efficiently migrating orders.
  • Advanced filters and customizations for precise control over order migrations.
  • Ability to import and export orders in Excel, XML, CSV, and TSV formats.
  • Option to import orders via FTP/SFTP and URL for added flexibility.
  • Scheduling of automated imports and exports to streamline processes.
  • Capability to export and import custom fields, including data from third-party plugins.

How to Export WooCommerce Products?

For exporting products, you need a different plugin that focuses explicitly on product exports. Since we are exporting products linked to their respective orders, let’s explore how that is done using the Product Import Export for WooCommerce plugin.

In addition to exporting products, this plugin also lets you:

  • Import products effortlessly
  • Bulk update your product listings
  • Export, import, and update categories, tags, attributes, and reviews
  • Bulk add products, categories, tags, attributes, and more

Step 1: Install & Activate WooCommerce Product Export Plugin by WebToffee

First, you must install and activate the plugin on your website from which you are exporting the WordPress users. 

For this,

  • Go to Plugins > Add New Plugin.
  • Search for “Product Import Export for WooCommerce” plugin.
  • Then, Install and Activate the plugin. 
Product Import Export for WooCommerce Plugin

Step 2: Choose Product as Post Type to Export 

Once you have installed the plugin,

  • Go to WebToffee Import Export (Basic) > Export.
  • Choose the post type to export as Product
Selecting product as post type for export

Step 3: Choose an Export Method

Choosing an export method for products

You can choose either Quick export or Advanced export.

Quick export lets you easily export all your products and the basic export fields. With just one click, you can finish the export process; there are no extra steps to follow. Just click the Export button to download a CSV of your store’s products.

Advanced export is preferred if you wish to exclude specific products or fields from your export file. You can achieve this through various filtering, column selection, and advanced options.

If you choose advanced export, you will be taken to the next step, where the products will be filtered.

Step 4: Filter Product Data for Export

Within the filtering section, you can export products selectively with the help of various filter options. The plugin provides you with the option to export by-products, category(s), tags, product status, etc.

You can choose one or more filters to export the desired list of products.

Filtering product data for export

Proceed to the next step.

Step 5: Map and Reorder Product Export Columns

You may not want to export all the product fields. The product data you need to export may vary depending on the purpose of the export.

The plugin allows you to choose the product fields you need to export, along with the options to rename and reorder them.

You can deselect the fields that need to be excluded from the export, rename the field name/column header, and even drag and drop the fields to re-order them in the export file.

Mapping and reordering of product export columns

Step 8: Export Products

Next, you must configure a few additional options, including the batch size, which determines how many products the server will handle in each iteration during the timeout period.

Additionally, specify the delimiter for separating columns in the CSV file, such as commas, semicolons, or tabs.

Finally, click the Export button to export the products.

All the exported product data will be available to download as a CSV.

Exporting products

In addition to the free plugin, WebToffee provides a premium version of the Product Import Export plugin for WooCommerce, which includes advanced features to enhance your export process.

The premium version allows you to automate export schedules for consistent updates and supports the export of product variations, subscriptions, and custom fields. This level of flexibility is perfect for stores with varied product catalogs, enabling more customized and efficient data management.

Product Import Export for WooCommerce (Premium)

WooCommerce Product Import Export Plugin

This premium version of the WooCommerce product export plugin comes with a range of customizations and filters that the basic version lacks. For example, the pro version allows you to export files in CSV, XML, XLS, and XLSX formats. It also enables you to schedule export actions and provides various advanced filtering and column options.

Some other notable features of the plugin include:

  • Support for exporting variable, subscription, and custom product types.
  • Options to sort columns based on your chosen criteria.
  • Ability to add third-party custom fields as data columns in the export file.
  • Option to export products that have been modified since the last export.
  • Scheduled exports of product data.
  • Exporting product images in separate zip files.

Next, we’ll highlight some other free plugins that are definitely worth trying.

More Free Plugins for Exporting Orders and Products from WooCommerce

The following are some of the other free extensions that are available to export your WooCommerce store orders. 

WordPress Product Excel Import & Export for WooCommerce

WordPress Product Excel Import & Export for WooCommerce

WordPress Product Excel Import & Export plugin lets you export products to .xlsx format. Simple products are only supported by the plugin. With the plugin, you can export and import a limited number of product fields and taxonomies (product category and tags). You will need to upgrade to their premium version for exporting all the product fields. 

Advanced Order Export for WooCommerce

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

WooCommerce – Store Exporter

Store exporter lets you export WooCommerce orders to CSV and TSV formats. It lets you export all major order fields. Fields like order subtotal, order discount, shipping tax, order tax, etc., can only be exported with the pro version of the plugin.

Orders can be filtered by date within the plugin. In addition to orders, you can export products, tags, categories, users, and more using the plugin.

Order Export for WooCommerce

Order Export for WooCommerce

The Order Export for WooCommerce plugin exports orders from WooCommerce into Excel and CSV. It lets you add custom filters to export exactly the orders you want. However, order items and coupon-based filters are only available for premium users.

Order Tracking for WooCommerce

Orders Tracking for WooCommerce

Order tracking for WooCommerce plugin lets you both track your WooCommerce store orders and export them to a CSV.

The plugin offers you a bundle of filters that makes selective export easy. Major filters include the date, order statuses, billing and shipping addresses, payment methods, and shipping methods. Using the plugin, you can also select the order fields you want to export.

WP All Export – Product Export Add-on

WP All Export - Product Export

WP All Export has a product add-on for exporting product data from your WooCommerce store. The plugin exports products into CSV and XML (both simple and custom feeds). 

The plugin doesn’t provide any filters for custom export. You can only export bulk products with the plugin. But you can choose the product fields to export and re-order them in the export file.

Conclusion

Online stores must frequently import and export orders and products. When the default functionality doesn’t offer much support, installing dedicated plugins that support those functionalities is the right course of action.

These plugins can make importing and exporting data easier, enabling bulk actions that save time and minimize manual errors. They typically include advanced features like customizable export templates, automated scheduling, and support for different data formats. These tools allow store owners to keep their product listings and order information current and well-organized.

We hope this guide has helped you understand how to manage your import and export needs effectively. Feel free to comment below if you have any questions or feedback.

Article by

Associate Product Manager @ WebToffee

Comment (1)

Got any query? Please leave a comment or reach out to our support

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