Is there a way to set a sale to a collection?

Bulk editing is the best way. I select the whole collection, copy paste my current numbers, use excel to calculate all the new prices, then I grab a good beer and start my copy paste session.

Otherwise, there are apps that can help.