How to Import Customers?

This block will give you information on how to import customers.

To perform import customer operations you must have to enable the import customer option from the customer settings tab.

Once you have enabled the import customers option then there are 3 new options. Insert Customer, Update Customer, and Delete Customer.

Insert Customer, Update Customer, and Delete Customer will automatically add an insert, update and delete sheet headers.

After saving settings, Our plugin code will auto add sheet headers respectively.

1. Insert Customer

If a user wants to add a new customer via spreadsheet then the user must have to add 1 within the Insert column of the spreadsheet. Please make sure you have added the Customer Username within the row as the user wants to insert it. Customer Username and Customer EmailID are mandatory for a new customer and they must be unique values.

Updated Spreadsheet

2. Update Customer

If you want to update any customer row then add 1 in the update column from a spreadsheet.

Here is an example to show you how you can update customers. In this example, we changed the customer with 2 customer Id.

Original Sheet

Customer FirstName test to Testing
Customer LastName testing to Last
Customer Nickname test testing to TestingLast
Customer Biographical Info test to Biographical Info
Update to 1

For example, you can make changes as per your need. You must have to add 1 within the Update column of the spreadsheet.

Whenever you try to update any customer data from a spreadsheet keep in mind that Customer Username and Customer Profile Image values can not be changed from the spreadsheet so if you want to change Customer Profile Image then you have to edit it from the backend. Customer Username , Customer EmailID, and Customer Nickname are mandatory fields for updating customer data so it can not be passed blank.