r/Netsuite•
bagehis

Can Customer IDs be mass updated?

resolved

I work at a company that has been around for a minute and has customer numbers using two different naming conventions (one old and one new). When they setup NS, they associated the ID used in the CRM with the customer ID in NS. They want to update the old IDs to use the new naming convention. I know how to update the customer ID manually. There are several thousand records however, so I'm hoping to automate this. Other than letting new records be creating when we import customer records next, then merging the existing accounts into the new accounts, or manually updating each existing record, is there a less onerous way to update these records?

Posted Mar 30, 2023, 2:44 PM UTC

24
Nick_AxeusConsultingConsultant•

CSV update the entityid field

5
broken1812Consultant•

Yes you can do a CSV to update the Customer ID. I believe you will have to have 'Allow Manual Override' checked in your Auto-Generated Numbers setup first, then the field should be available in your import mapping.

2
Nick_AxeusConsultingConsultant•

Yes you need Allow Manual Override.

2
bagehisOP•

Thank you.

1