Important
You are browsing documentation for version 5.0 of OroCommerce, supported until January 2025. Read the documentation for version 6.0 (the latest LTS version) to get up-to-date information.
See our Release Process documentation for more information on the currently supported and upcoming releases.
Import Customer User Details
Hint
This section is part of the Data Import concept guide topic that provides guidelines on import operations in Oro applications.
Import File option helps import the customer user information using the .csv file that follows the customer user details data structure.
Example of customer user bulk import template
ID |
Name Prefix |
First Name |
Middle Name |
Last Name |
Name Suffix |
Birthday |
Email Address |
Customer Id |
Customer Name |
Roles 1 Role |
Enabled |
Confirmed |
Owner Id |
Website Id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 |
Mr |
Jerry |
John |
Coleman |
Jr. |
04/19/1987 |
111 |
Oro Inc. |
ROLE_FRONTEND_BUYER |
1 |
0 |
1 |
1 |
To import a bulk of customer user information:
In the main menu, navigate to Customers > Customer Users. The customer users list opens.
Click Import File on the top right.
In the Import dialog, click Choose File under the required tab, Customer Users or Customer User Addresses, depending on what data you are importing. Select the .csv file you prepared, and then click Import File.
Note
Ensure that your .csv file is saved in the Unicode (UTF-8) encoding. Otherwise, the content of the file can be rendered improperly.
Click Download Import Template to download a sample .csv file with the necessary headers.
Prepare data for import: Based on the downloaded file, create your bulk information in the .csv format. Once your file is ready, click Choose File, select the prepared comma-separated values (.csv) file, and click Import File.
Validate import results: Click Validate to check your import results. If there are any Records with errors, fix them in the .csv file before starting the import.
Launch import: After successful validation, click Import File.
Click Cancel to decline the import.
Important
Interactive status messages inform about the import progress, and once the import is complete, the changes are reflected in the list upon refresh. Additionally, an email message with the import status is delivered to your mailbox.
Follow the on-screen guidance for any additional actions. For example, for the inventory template, select one of the options: a) inventory statuses only or b) detailed inventory levels.