To import WooCommerce data from CSV, Excel, XML, or Google Sheets, go to All Import › New Import, choose your import file, and select the WooCommerce data to import. Use our Drag & Drop tool to map incoming data elements to their target fields, then run the import.

To demonstrate, we'll show you how to import WooCommerce customers in this guide.

Advanced Topics

Navigate to All Import › New Import in the main WordPress menu, select or upload your import file, then pick WooCommerce Customers from the drop-down list.

Click Continue to Step 2.

To import from Google Sheets, you would provide the public sharing URL via the Download a file option.

The Review Import File screen appears, where you can check to ensure that WP All Import has correctly interpreted your file.

You can also add filtering options in this step if you want to filter the customers to import, this is done under Manage Filtering Options. Once done, click Continue to Step 3 to proceed.

You will now see the Drag & Drop screen, where you can map the incoming data elements to their WooCommerce customer fields. Simply drag & drop the data from the panel on the right to the correct fields on the left.

The first section is Customer Account Info, which contains the main customer information:

Further down, the Billing & Shipping Info and Other Customer Info panels let you map the rest of the customer information.

After completing this process, click Continue to Step 4 at the bottom (not shown).

Next up is the Import Settings screen, where you define options and settings for the import. First, click on Auto-detect to define a unique identifier for the import. Below this, you can define how the import behaves when it runs again.

You also have the following panels near the bottom:

For this example, leave these panels with their default selections.

Click the Continue button to move to the next step. You'll then see the Confirm & Run screen, where you can review an Import Summary.

If everything looks okay, click Confirm & Run Import. Once the import completes, the screen will update as follows:

To import other types of WooCommerce data, see the information in the next sections.

The steps to import WooCommerce products are essentially the same as importing any other post type. The import fields themselves will be different, but the other parts of the import function the same way, i.e., you upload the import file, map the product fields, then run the import.

The following documentation provides additional instructions:

How to Import WooCommerce Products from CSV, XML, and Google Sheets

How to Import Variable Products in WooCommerce

Import WooCommerce Products with Images

Again, the process is the same. See:

How to Import WooCommerce Orders

How to Import WooCommerce Coupons

How to Import Reviews to WooCommerce

When importing WooCommerce data, our plugin will treat each record as new when inserting it into the database, meaning it will be assigned a new ID. However, you can modify this behavior using custom code (see documentation) and our API (see documentation). Here are the available snippets:

If you wish to import multiple types of WooCommerce data, make sure to import WooCommerce products and customers first, followed by coupons, reviews, and orders. If you adhere to this sequence, WP All Import will help you maintain the relationships between different data types even if you can't preserve the original IDs.

Filters can be added in Step 2 using the Manage Filtering Options panel. These filters let you control which WooCommerce records get imported.

A filter is composed of an Element (from your import file), a Rule (to apply), and a Value to filter. For example, when importing WooCommerce customers, you can choose the country as the element to import customers from the US only.

Once the filter is added, click Add Rule and then click Apply Filters To XPath to apply the newly created filter. This is what the result looks like:

In some cases, you may encounter problems importing your WooCommerce data. For example, when importing WooCommerce variable products, there can be issues with adding the variations correctly. If this happens, double-check our documentation to ensure you're setting up everything as expected.

If you're unable to figure out the issue, try to replicate your import and any problems in our sandbox environment (https://www.wpallimport.com/debug/). Then, just contact our support team and include the sandbox site URL and a brief description of what's wrong. You can contact Support by emailing us at [email protected] or using this form: /support.

The steps to import an XML file into WooCommerce are essentially the same as described in the guide above.

We explain more about importing taxonomy data here: How to Import WordPress Categories and Tags.

Assuming that you obtain your WooCommerce data from a URL or from an S/FTP source, you can schedule the imports using our available options to automate them. The following methods are available:

To import WooCommerce customers, you need to have both the WooCommerce Import Add-On and the User Import Add-On active on your site, along with WP All Import.

Explains how to import WordPress posts.

An overview that leads to documents on all types of image imports.

Describes how to import Advanced Custom Fields (ACF), including all of their field types.

Explains how to import Gravity Forms entries.

Shows how to import WordPress users, including how to handle encrypted password data.

An overview of how to configure recurring imports.

Learn how to export WordPress and WooCommerce data.

Oxygen Builder's review of the four best plugins for WordPress imports.