How to Import and Export Customer Data in Magento 2

How to Import and Export Customer Data in Magento 2

Manually creating a new customer in admin takes too much time, especially when you have to finish adding a large number of customers. This blog will instruct you to import and export customer data and speed up the process using a CSV file.

Please note that to import the customer file successfully, you need to use the right CSV file structure so let’s go through the tutorial to export file first.

How to Implement Magento 2 Export Customer Data

Go to System ⇒ Export ⇒ Export Settings to config for Magento 2 export customers.

Magento 2 Export Customer

Entity Type: Choose Customers Main File.

Export File Format: Choose CSV.

To exclude any information from the file, tick the checkbox of the attribute below. But you should keep all the fields to preserve the structure of the CSV file.

Note: you can filter the information to export, such as gender, group, age (date of birth)…

Then click the Continue button.

Magento 2 Export Customer - exported csv

How to Import Customer Data

Using the export file from Magento 2 Export customers, you can now fill it with your data and save the file.

Go to System ⇒ Import. 

How to Import Customer Data

Entity Type: Choose Customers Main File.

Import Behavior: Choose Add/Update Complex Data.

Then Select a file to import and click Check Data button.

Besides, to import data into Magento 2 websites, there are some suggestions for you to take into consideration:

BSS Commerce is one of the leading Magento extension providers and web development services in the world. With experienced and certified Magento developers, we commit to bring high-quality products and services to optimize your business effectively.

Furthermore, we offer FREE Installation – FREE 1-year Support and FREE Lifetime Update for every Magento extension.

CONTACT NOW to let us know your problems. We are willing to support you every time.

Write A Comment