Updating Existing Records in Salesforce
To update records in Salesforce in bulk, you will first need to pull them to your Excel spreadsheet. You can do it using either SOQL or Reports. You can retrieve your data with any other tool or directly from Salesforce by exporting a report too. The main thing to remember is that you need to have record Ids in order to be able to update the records.
In our example here we’ll use XL-Connector to update the stage of all opportunities under one specific account. We’ll use the following query to pull the data:
SELECT Name,Id, StageName FROM Opportunity WHERE Account.Name = ‘AVL GmbH’
Please note that we’re pulling record IDs. A column of record IDs is required to be able to update records in Salesforce.com.
We got the following results back from our sample database:
Now we want to change the stage of all four Opportunities to Closed Won. After the stage has been changed we’ll select the rows of data so that the selection spans across all the records that we want to update:
Then click Update up in the Push Data tab of the XL-Connector 365 main window:
In the Update screen, select Opportunity as the object to work with and click on Mappings manager:
In the Mappings dialog box, make sure you map your columns to the correct fields in Salesforce. The column with record Ids must be mapped to the Id field in order for the Update operation to work. Click on Apply when the mappings are done:
If you’d like the Ids of the updated records to be also populated in one of the data columns – select it in the Select column for result IDs.
By default, XL-Connector will use the selected rows to push them to Salesforce, but you can change that under Options together with Batch Size setting and Load Empty Values flag. If you
Click on Run and Save to run the Update operation according to the provided settings and save all the settings as a reusable Flow Step. In this case you’ll be able to run the same Update operation again from the same area in your sheet with a single click on the Run Flow or Run Flow Step button.
Click Run to only run the Update operation of the selected data and not save the mappings and other settings as a reusable Flow Step.
Click Save to save all the provided settings as a reusable Flow Step. In this case you’ll be able to run the same Update operation again from the same area in your sheet with a single click on the Run Flow or Run Flow Step button.
After the operation is completed, all operation results, along with the updated record Ids will be written on the right from your data, one column over:
If you selected Run and Save or Save when updating, this operation will be saved as a reusable flow step and you’ll be able to run it with one click by clicking on the little Play icon: