While we cannot use Mass Update for this functionality since this is currently logged in as Enhancement under Issue 131958 Mass Update > Contact > Ability to update the Role for the contact, we can use CSV Import instead.
Based on my testing, below are the steps you can follow:
A. Create a CSV file using MS Excel software.
For testing purposes, you can use one customer first. You can follow this format below:
Don't forget to save the file as .csv.
B. Proceed with the CSV Import.
1. Navigate to Setup > Import/Export > Import CSV Records
2. Under Scan & Upload CSV File, set the following:
a. Import Type - Relationships
b. Record Type - Customers and Contacts Together
c. Upload the CSV file you have created
3. Click Next.
4. Under Import Options, click Add or Update
5. Click Next.
6. Map the following fields:
a. Role - customer : Role
b. Internal ID Customer - customer : Internal ID
c. Internal ID Contact - customer Contact 1 : Internal ID
d. Click the pencil icon on the Role fields. Set Value to Null.
7. Click Next.
8. Set Import Map Name.
9. Click Save & Run.
10. Check the status of your CSV Import.
11. If you were able to follow these steps successfully, you can go back to the Customer record you have used for testing. Check if the Role is now set to blank.
Note: It would be important to follow each step carefully so you won't encounter any errors on your end.
Feel free to visit SuiteAnswers ID: 10022 CSV Imports Overview for further details.
Have you tried this before? Feel free to share your thoughts and suggestions!
Kind regards,
@Shamaine Chan-Oracle