Rating 0 stars - 0 votes

Import WooCommerce Customers with IDs

Moving to a new instance of WooCommerce, you may need to migrate its entities preserving their IDs. In this article, we’ll describe how to import WooCommerce customers with IDs via Store Manager for WooCommerce.

Before we get down to import, let’s first check if any customer IDs already exist in the database. Yes, even a new WooCommerce installation may have some records in tables.

To check existing IDs, go to Store Manager > Tools > Raw Table Editor and open the wp_users table. As you can see, there already exists a record with ID 1.

WooCommerce User Import IDs Check

In our file, customer IDs also start from 1. So if we import our customers from the file, their IDs will be incremented and therefore, differ from the initial ones.

WooCommerce Store Manager Import Users File

To create customers with their initial IDs, we’ll break down the task into two steps.

Step 1. Import customer dummy data to create necessary IDs

As ID 1 already exists in the database, we need to create three more user IDs. For that, we’ll import three records from our file.

To import customers via Store Manager, navigate to Customers > Users > Import Data:

WooCommerce Store Manager Import Users IDs Launch Wizard

When the wizard opens, follow its prompts to set up and launch the import:

  1. Select the file with customers.

  2. WooCommerce Store Manager User Import Steps

  3. Specify delimiters used in your import .csv file.

  4. WooCommerce Store Manager User Import Steps

  5. Link columns from the file to the database fields.

  6. WooCommerce Store Manager User Import Steps

  7. Select the Just Add import option and start the import.

  8. WooCommerce Store Manager User Import Steps

After the import is complete, you can check the created users with IDs in Store Manager:

WooCommerce Store Manager Import Dummy Users

As you can see, the user with ID 1 is not the one listed in our file. To fix this, we’ll perform one more import during which we’ll replace existing user data with the one from our file.

Step 2. Import Actual Customer Data

The import steps will be the same as described above. The only significant difference is that in step 3 Field Links, you should select ID as an identifier:

WooCommerce Store Manager Import Actual User Data Identifier

Finish the import following the wizard prompts. Now you have your customers with IDs and actual data in your new WooCommerce store.

Import WooCommerce Customers Preserving IDs

Try now FREE
Related Articles:
Card image
Import WooCommerce Products Preserving IDs

Learn how import products to a new instance of WooCommerce preserving product IDs.Read More...

Card image
Mass Changer: Detailed Tutorial

Perform bulk WooCommerce product updates via Mass Changer tool. Read More...

Card image
Merge Product Brand Name and Title Upon Import

How to add a brand name to a product title in WooCommerce via import. Read More...

Card image
Update WooCommerce Product Tags In Bulk

How to update WooCommerce product tags in mass using WooCommerce Product Tags Mass Changer.Read More...

Be the first to comment.