function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ozz54001Ozz54001 

Mass update of opportunity stage

Is there a way to do a mass update of opportunity stages? I have over 150 opportunities (for different accounts) that need to be closed. These are left-overs from when we started using saleforce and no one could remember to close the opportunities.

I looked at the appexchange and there is an app for mass updating opportunity close dates, but not stage.

Thanks,
Dave
jeffstuitjeffstuit


Ozz54001 wrote:
Is there a way to do a mass update of opportunity stages?



If you can isolate all of the records you want to update with a query, you should be able to export them with the Data Loader, then update the "stage" value in your export file, then use the data loader again to update the records. I do updates like this frequently with the data loader, and it works fine.
Michael TomarMichael Tomar
Skyvia cloud platform offers perfect tools for automating opportunities stage update, take a look at this tutorial: https://skyvia.com/blog/top-3-ways-to-mass-update-salesforce-records
This is how I would query it in SQL (https://skyvia.com/gallery/salesforce-mass-update-opportunities-stage):
UPDATE Opportunity
SET
StageName = 'New_StageName'
WHERE
StageName = 'Old_StageName'