Home » Deeper in to NetSuite » Preventing Duplicate Records During Data Import Into NetSuite

Preventing Duplicate Records During Data Import Into NetSuite

[vc_row][vc_column width=”1/1″][vc_column_text]NetSuite provides support for preventing data duplication when importing Customer or Company records into the system. Although NetSuite has had duplicate detection and Merge features/functionality for quite some time, it’s latest release now offers these features in the (data) Import Assistant as well.

In order to utilize these features during the data import process, you must first enable the Duplicate Detection & Merge feature in NetSuite by going to Setup → Company → Enable Features, and then apply the duplicate detection feature to specific record types by going to Setup → Company → Duplicate Detection.

After you’ve done that, just enable this option in the Import Assistant by selecting “Advanced Options”  from under Import Options (the second step) in the import assistant. Doing so will display all of the Advanced Options you can use with the import assistant, including the new “Prevent Duplicate Records”option (as shown in the screenshot below).[/vc_column_text][/vc_column][/vc_row]

CTA - NetSuite Products

[vc_row][vc_column width=”1/1″][vc_single_image image=”4331″ border_color=”grey” img_link_target=”_self” img_size=”large”][/vc_column][/vc_row]

[vc_row][vc_column width=”1/1″][vc_column_text]Next, just continue and complete the Import Assistant wizard and NetSuite will automatically detect and prevent any duplicates from being created during the import process. Once the import has completed, NetSuite will generate a CSV Response file which will have details about all the errors encountered during the data import (including duplicate records). You can also download this CSV file.

In the example below, the import assistant detected this particular customer record as a duplicate and marked it as an error during the customer import process.

Error External Id Company Name Email
Duplicate record was detected comp_12312 Yellow Ways Inc. [email protected]

If you have a NetSuite development requirement you would like to discuss, or would like to know more about our NetSuite development or NetSuite customization services, please get in touch with us.[/vc_column_text][/vc_column][/vc_row]

Get In Touch With Our Experts

    Get In Touch With Our Experts

      I have read and agree to the Privacy Policy of Folio3
      I agree to be contacted by Phone or Email by Folio3

      Get in touch with the


      End-to-end NetSuite Servicing Agency

      Tell us how may we assist you!