Export and Import Customers in Magento 2

It takes too much time to manually add new customers to your store especially if there are too many of them. In order to facilitate the process, there is an automatic import in Magento 2.0. Let’s take a look at the ways how to import new customers to your site.

The format for the files to import in Magento is CSV.

What comes first: import or export?

This may look similar to the chicken-and-egg question, but in our case, we know the answer.

In order to import in Magento, you need to export a file and fill it according to its structure.

How to export Customers?

System -> Export

Then choose Customers Main File.

How to Export and Import Customers in Magento 2

You can mark the boxes that you would like to exclude from the file, but since we only want to see the structure of the document, we leave all the fields.

You can also select your segments according to different criteria:

  • age (Date of Birth),
  • date of purchase (Created at)
  • or other.

After that, you scroll down to the bottom of the page and click Continue. You save the file on your computer and open it.

Here you can see how it looks after you download it:

How to Export and Import Customers in Magento 2

In order to make it look normal, you need to select the first column. Then press Data then Text to Columns. Then select Delimited. Then Press Next. After that, you need to select the Comma box and unselect other boxes. Then press Next again and Done.

And after all the changes your file will look as following:

How to Export and Import Customers in Magento 2

Now you need to follow the example to fill in the file with your data. If you would like to create accounts for your existing customers at your newly created website, you insert emails in the first column, write down the name of your website in the second.

These are required fields.

Remaining fields are up to you to fill.

How to Export and Import Customers in Magento 2

After your file is completed, make sure you save it in Unicode (UTF-8). In order to do so in Excel, you need to press Save As and on the left from Save button, you find the Service button and you select Web document settings and there you find Coding section. You need to select Unicode (UTF-8). Then press OK and Save your file.

When this is done, you can proceed to the next step.

How to import Customers?

To start the process, you need to access System -> Import.

How to Export and Import Customers in Magento 2

Note: Your file cannot be bigger than 8M.

After that you need to select which kind of data you want to import in the Entity Type tab:

  • Customers Main File 

How to Export and Import Customers in Magento 2

Then in Imports Behavior you need to select Add/Update Complex Data if you would like to add new customers (this is what we actually want to do). If you select Delete customers, your customer database will be replaced by new one.

Then you choose the File to Import, browse, find it on your computer and upload it. Then you press Check Data. If you filled the file correctly, new customers will be added to your site.

Viewed 278 Times

Post On 2022-12-02