This can be achieved through CSV import. Need to prepare a CSV file with the following details:
- Internal ID of the Contact records to be updated
- Internal ID of the Customer records associated with the Contacts
- intended Role for the contacts
Then import can be performed as
- Navigate to Setup > Import/Export > Import CSV Records
- Import Type = Relationships
- Record Type = Customers and Contacts Together
- Select the CSV file
- Click Next
- Set Data Handling = Update
- Click Next
- In the field mapping page, map the following fields:
- Customer Internal ID <=> map to the Internal ID in the Customer Folder
- Contact Internal ID <=> map to Internal ID in the Contact Folder
- Role <=> map to the Attached Role in the Contact Folder
- Click Next
- Click Run
Note:
Initially, update the same in one or two records for testing and confirm that it works as expected without any other impacts.
If the testing went well, then we can perform import on the remaining record. This is a good practice while doing an import process