Skip Navigation
Importing two records that have the same value in the 'email' field
Answer ID 5260   |   Last Review Date 12/12/2018

When importing two contacts with the same 'email' value, why is it importing two records instead of one?


Data Import Wizard


When using the Data Import Wizard and there are two records that have the same value in the 'email' field, the system is importing two records into the 'contacts' table, instead of just one.


If Email Address Sharing is enabled, the first_name and last_name is included when importing contacts. This narrows the criteria by permitting multiple contacts that share a common email address as long as they have different first or last names. For example, any_email={1} AND first_name={2} AND last_name={3}.

With Email Address Sharing enabled, and importing both contact records from the attached .csv file, both contact records will be imported with the same email address.

For additional information, refer to the 'Data import error handling' section in online documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.

For further information on areas affected by Email Address Sharing, refer to Answer ID 2831: Householding - email address sharing.