Merging Duplicate Customer Records in NetSuite

Merging duplicate customer records helps ensure that the NetSuite Connector matches the correct customer when syncing orders for existing customers. This is essential for maintaining data integrity across your business processes.

Why Merge Duplicate Customer Records?

Merging duplicate records is crucial in NetSuite as it consolidates customer information, ensuring that all relevant data—from relationships and communications to sales and financial records—is maintained without redundancy. Clean data enhances reporting, customer interactions, and overall efficiency.

How to Merge Two Customer Records in NetSuite

You can merge duplicate customer records either individually or in bulk. For individual merges, follow these steps:

1. Go to Lists > Relationships > Customers.
2. Click Edit next to the name of the customer whose record will serve as the source.
   • This is the record that will be merged into the target customer record. Note that the source record will be deleted during this process.
3. Select Merge at the top of the record.
4. On the Merge Customer page, the source customer will appear in the Duplicate field.
5. In the Primary field, select the target customer into which you want to merge the source customer.
6. Review the Duplicate/Primary Summary tab to confirm that everything is in order before proceeding.

Key Features of the Merge Process

When merging customer records, keep the following in mind:

• The target record receives all data from the source record, including any relevant relationships and communications.
• Data fields in the target record will only be updated if they are empty. If the field already contains information, it remains unchanged.
• After the merge, the source customer record is deleted.

Mass Merging of Duplicate Customer Records

For mass merges, utilize the Duplicate Detection feature, which can be enabled by an administrator through Setup > Company > Enable Features. This allows for simultaneous detection and merging of multiple duplicate records. Ensure that the setup includes all relevant fields that will aid in identifying duplicates effectively.

Important Notes:

• Ensure that both source and target customer records have accurate data before merging.
• If you're using NetSuite OneWorld, merging can involve customer records across different subsidiaries, but they must share the same VAT Registration Number.
• Merges can have significant data implications. Always validate records beforehand and be aware that system notes will not transfer during merges, impacting historical tracking.

Who This Affects

• Administrators: Responsible for enabling and managing the Duplicate Detection feature.
• CRM Users: Engage with merged customer records for sales and marketing efforts, ensuring accurate customer data is utilized.

Key Takeaways:

• Merging customer records eliminates duplicates and consolidates data in NetSuite.
• The target record retains information based on existing data fields without overwriting established entries.
• Administrators must enable the Duplicate Detection feature to facilitate this function and maintain clean customer records.

Source: This article is based on Oracle's official NetSuite documentation.