How to Export WooCommerce Customers and Orders?

Exporting your WooCommerce customer and order data is one of the most common store management tasks — whether you’re migrating to a new platform, syncing with a CRM, running an email campaign, generating accounting reports, or responding to a GDPR data request. Whatever the reason, getting your data out of WooCommerce cleanly and completely is what this guide covers.

By default, WooCommerce gives you limited native export options. The built-in Reports section lets you download basic order data, and WordPress has a simple user export — but neither gives you full control over which fields are included, how the data is filtered, or what format it comes out in. For anything beyond a basic export, you need a dedicated solution.

This guide covers two approaches: what WooCommerce can do natively, and how to get complete, filtered, field-level exports using the WebToffee Customer Import Export and Order Import Export plugins. Both are free to start and require no coding.

Yes, to a limited extent. WooCommerce and WordPress both have native export functionality built in, and for simple needs, it may be enough. Here’s what each can do:

For orders: Go to WooCommerce > Reports, and you can download basic sales data as a CSV. This covers order totals, dates, and product summaries but gives you no control over which fields are exported, no filtering by order status, and no customer-level detail beyond what appears in the summary rows.

For customers: WordPress includes a built-in user export under Tools > Export. Select “Users” and you’ll get a basic XML file with user account data. It does not include WooCommerce-specific fields like billing address, shipping address, total spend, or order count.

What the native options can’t do:

• Filter customers by registration date, total spend, or purchase history
• Filter orders by status (completed, refunded, processing)
• Export guest orders separately from registered customer orders
• Choose which fields to include or exclude
• Export to Excel or XML with WooCommerce-specific data intact
• Schedule automatic recurring exports

If your needs go beyond a basic one-time data pull, the native tools will fall short quickly. The rest of this guide covers how to do it properly using dedicated plugins.

The WordPress Users and WooCommerce Customers Import Export plugin by WebToffee allows exporting customers with just a few clicks. This plugin not only allows you to export WooCommerce customers but also gives you the option to select which users and their related data should be exported.

Now, follow the below steps to export WooCommerce Customers from your store site.

Step 1: Install & Activate WooCommerce Customers Import Export Plugin

• From your WordPress dashboard, go to Plugins > Add New
• Search for the WordPress User Import plugin by WebToffee.
• Once you have found the plugin, click Install Now and then Activate the plugin.

Step 2: Select User/Customer as Post Type to Export

Once you have installed the plugin,

• Navigate to WebToffee Import Export (Basic) > Export.
• Select User/Customer as the post type to export.

Step 3: Select Export Method

Here you have two options: Quick Export and Advanced Export. Selecting Quick export exports your WooCommerce customers quickly, without any data filtering options. If you want advanced data filtering options, you may select the Advanced Export option.

Let’s go with Quick Export.

We will then proceed to Step 3 to review available options. You can directly go with the Export too.

Step 4: Configure Advanced Export Options

Here are some advanced options for exporting WooCommerce Customers.

• Decide whether to include guest users in the export.
• Enter a custom file name for the exported customer file.
• Specify a batch count to divide the export into smaller batches. This helps reduce server load when exporting a large number of customer records.
• Choose a delimiter (separator) to distinguish columns in the CSV file.
• Once done, click the Export button to begin exporting your customer data.

Once the export is completed, you can see a success message with the option to download the user data file. You can then click the download link to save the exported customer data file to your system for further use or record-keeping.

For more advanced options, check out the premium version of the WooCommerce customers export plugin. It includes features such as exporting WordPress users to Excel, applying additional filters, scheduling import/export actions via FTP profiles, and more.

Common Customer Export Scenarios

Exporting WooCommerce Customers by Date Range

To export only customers who registered within a specific period, useful for campaign targeting or periodic data backups, use the Registration Date filter in the export settings. Set your from and to dates before running the export. Only customers who created their account within that window will be included.

Exporting WooCommerce Customers for CRM Import

If you’re moving customer data into a CRM like HubSpot, Salesforce, or Mailchimp, export with these fields prioritized: first name, last name, email address, billing phone, billing city, billing country, and total spend. Most CRMs accept CSV with a header row — the WebToffee plugin exports in this format by default.

Check your CRM’s field mapping documentation before export to align column names where possible, which reduces manual remapping on import.

Exporting WooCommerce Customers for Email Marketing

For platforms like Klaviyo, Mailchimp, or ActiveCampaign, the minimum fields needed are typically: email, first name, last name, and any segmentation data you want (total orders, total spend, last order date). Filter by user role set to Customer to exclude admin accounts and test users from the export.

GDPR Customer Data Requests

For individual GDPR data subject access requests, WordPress has a built-in personal data export tool under Tools > Export Personal Data — use this for individual user requests as it pulls data from all plugins in one go. For bulk GDPR compliance audits or data-deletion workflows, the WebToffee plugin’s filtered export via email or user ID is more efficient.

Now, let’s move on to the next section – exporting WooCommerce Orders.

To export WooCommerce orders from a website, you don’t have to go far away to search for a plugin that can do that effortlessly. WooCommerce Order Import Export Plugin by WebToffee can help you export all the orders from the WooCommerce store into a CSV file.

Step 1: Install & Activate Order Export & Order Import for WooCommerce Plugin

• From your WordPress dashboard, go to Plugins > Add New
• Search for the Order Import Export plugin by WebToffee.
• Once you have found the plugin, click Install Now, then Activate the plugin.

Now, follow the below steps to export WooCommerce orders from your store site.

Step 2: Select Order as Post Type for Export

Here, select Order as the post type to export. Then proceed to the next step.

Step 3: Select an Export Method

Like the User import plugin, you also have two options: Quick Import and Advanced Import. If you have used this plugin earlier and saved a template for the export option, you can see a third import method Pre-saved template.

Let’s select Advanced Export and proceed to the next step.

Step 3: Filter Data for Order Export

Here, you have some filtering options available to custom export orders from your store site.

You can choose the number of orders you want to export, skip the first n number of orders, and select order IDs to specifically export order data. Also, export order data based on order status, products, users, coupons, and date range.

After choosing the necessary filters, proceed to the next step.

Step 4: Map and Reorder Export Columns

Here you can edit, reorder and rearrange the columns in the export file. Use the drag-and-drop handle to rearrange the columns.

Step 5: Configure Advanced Export Options

• Enable the option to skip orders that have already been exported to avoid duplicates.
• Use the Export in batches of field to define how many orders should be exported per batch. This helps manage performance and reduce server load during large exports.
• Select the delimiter (separator) used to distinguish columns in the CSV file.

• Click on the Export button to export the orders.

Once the export process is finished, you will see a dialog box with the option to download the export file. Click on the Download file button to download the CSV file containing the order data.

For more advanced functionality, consider upgrading to the premium version of the WooCommerce Order Import Export plugin. It offers powerful features such as importing and exporting subscription orders, enhanced filters for selective export, and scheduling options for automated import/export tasks — perfect for stores managing large or recurring order volumes.

Additionally, WebToffee brings all these capabilities together in a comprehensive suite of data migration plugins, covering products, orders, users, and more, making store management seamless and efficient.

Common Order Export Scenarios

Exporting WooCommerce Orders by Status

To export only completed orders, the most common request for accounting and fulfillment purposes, set the Order Status filter to Completed before running the export. For refund reconciliation, run a separate export filtered to Refunded. Running separate exports per status rather than one combined file keeps your data clean and avoids errors when importing into accounting software.

Exporting Guest Orders Separately from Registered Customers

Guest orders don’t have a WordPress user account attached, which means they won’t appear in a customer export — only in an order export. To get a complete picture of all transactions, including guests, always export from the Orders plugin rather than the Customers plugin. To isolate guest orders specifically, filter by orders where the customer ID is empty or zero, depending on your plugin’s filter options.

Exporting WooCommerce Orders for Accounting

For importing into accounting tools like QuickBooks, Xero, or FreshBooks, export with these fields: order ID, order date, billing name, billing email, line item names, line item quantities, line item prices, tax total, shipping total, discount total, and order total. Most accounting tools accept CSV — confirm the expected column names before export to minimize remapping. The WebToffee plugin lets you reorder and rename columns before generating the file.

Exporting Orders for Store Migration

If you’re migrating to a new WooCommerce installation or a different platform, export all orders without status filters to capture the complete order history. Include all available fields — you can always delete columns you don’t need after export, but you can’t recover data that wasn’t exported. Use XML format for WooCommerce-to-WooCommerce migrations as it preserves data structure more reliably than CSV.

Exporting data from WooCommerce is generally straightforward, but you may occasionally run into issues that affect the accuracy or completion of your export files. These problems can arise due to incorrect settings, large data volumes, or file format inconsistencies.

Below are some frequent problems users face and practical solutions to resolve them.

1. Missing Data

Issue: Some fields or product details are missing in the exported file.
Cause: This often happens when the export column mapping is not correctly configured or when certain fields are excluded.

Fix:

• Review your column mapping settings to ensure all necessary fields (e.g., product name, SKU, price, stock, category) are included.
• Double-check that the source data exists and is populated in your store or database.
• If custom fields or meta keys are used, confirm they are properly referenced in the export configuration.

2. Incorrect Encoding

Issue: Exported data displays unreadable or garbled characters, especially for non-English text.
Cause: The export file uses an incompatible character encoding format.

Fix:

• Always export files using UTF-8 encoding, as it supports all international characters.
• When opening the file in spreadsheet software (like Excel), ensure that UTF-8 is selected as the import format.
• If issues persist, open the file in a text editor (e.g., Notepad++ or VS Code) and convert it manually to UTF-8 before re-importing.

3. Timeout Issues

Issue: The export process fails to complete, hangs, or returns an error due to server limitations.
Cause: Exporting a large dataset or including complex filters can exceed PHP execution time or memory limits.

Fix:

• Use the batch export option (if available) to process the export in smaller chunks.
• Filter by smaller date ranges or product subsets to reduce the load.
• Increase PHP execution time or memory limit temporarily in your server configuration if necessary.
• Schedule exports during off-peak hours to reduce server strain.

Exporting WooCommerce order and customer data can be daunting, especially with bulk orders on your store site. But with the plugins mentioned in this article, it can be done effortlessly.

We hope this guide has helped you understand how to efficiently export WooCommerce customers and orders from your store. By following the outlined steps and applying the recommended best practices, you can streamline your data management process and focus more on growing your business.

If you want a solution for the import and export of WooCommerce products, take a look at our plugin: Product Import Export Plugin For WooCommerce