The screenshots and content you are viewing corresponds to an older version. We are in the process of updating the documentation to reflect the current version. Until then, you may refer to the latest set up guide for an insight.

Documentation/WordPress Users & WooCommerce Customers Import Export/How to Import Customer Data from Magento into WooCommerce

How to Import Customer Data from Magento into WooCommerce

More and more people are changing their e-commerce platforms to WooCommerce. Being open-source, powerful and highly flexible, the popularity of WooCommerce is increasing by the day. The best thing about WooCommerce is that it gives the owner complete control over the website.

If you already have an e-commerce website for e-commerce platform like Magento, and you want to migrate to WooCommerce, all you need to find the right plugin that can help you with it.

From your existing e-commerce store on Magento, export all the user data into a CSV file. Once you have exported the customers and customer data into a CSV file, the next thing you need to do install the WordPress Users and WooCommerce Customers Import Export Plugin in your WooCommerce store. Now, take the CSV file and upload it to the plugin.

Note: The CSV Import file must be in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?

Then from the WooCommerce store, go to the dashboard, navigate to WooCommerce > Customer Import Export. This will take you to the plugin page from where you can import a CSV file to the store or export the data from the store to a CSV file.

From the plugin page, go to the Import Users in CSV Format section and click on Import Users.

This will take you to the Import page. From this page, you can upload the CSV file in which the data of your store resides.

If the CSV file is located on the local computer, then you can use Method 1 to upload the CSV. If the CSV file is located on a remote server, the plugin also helps you to upload the CSV from the server. This can be done by Method 2 on the Import page. All you need to do is to give the FTP details to connect to the server.

Once you have uploaded the CSV file to the plugin, click on Upload file and import. This will take you to the next step in the import process, Mapping.

Since the data are being imported from Magento, the customer data fields of Magento will not necessarily correspond to that of WooCommerce. So, we need to tell the plugin the right column in the CSV that corresponds to the right WooCommerce customer data field.

Map column header for user import

Map column header

In the mapping fields, you can also tell the plugin if you do not want to import any particular field in the CSV file. Also, during mapping, if you do want to changes in bulk in the data that are being imported, you can do so using the evaluation field.

User import evaluation field

User import evaluation field

After the mapping, click on Submit. This will import all the data in the CSV file into the WooCommerce store.

User imported completed successfully

User import completed successfully

The imported customers will now be listed on the Users page.

Imported user on the users page

The imported user on the Users page

This way the plugin makes it easy to migrate from your existing e-commerce store to a WooCommerce store. No matter which you e-commerce platform you are migrating from WordPress Users & WooCommerce Customers Import Export Plugin will help you effortlessly import the users and user data into the new WooCommerce store.

The Best WordPress User/ WooCommerce Customer Import Export Plugin

40,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

  • Was this article helpful?
  • YesNo