Hi I have a set of attributes which are sorted like this:

Option Value 1 Sort Order 0
Option Value 2 Sort Order 1
Option Value 3 Sort Order 2
Option Value 4 Sort Order 3
Option Value 5 Sort Order 4

Now I'm aware I've made a stupid error here as of course they should have been sorted like this:

Option Value 1 Sort Order 10
Option Value 2 Sort Order 20
Option Value 3 Sort Order 30
Option Value 4 Sort Order 40
Option Value 5 Sort Order 50

However I now have a dilemma as I need to add a new option value above Option Value 1 Sort Order 0 and I have numerous products with this set up, too many to go through 1 by 1.

The option value that should go above Option Value 1 Sort Order 0 will be NONE Sort Order -1, I can set this up in Option Values Manager and then add this to all products with the associated Option Name but it defaults back to Sort Order 0 and doesn't apply the new option value in as Sort Order -1. That would mean I would have to go through every product that has the associated Option Names and Option Values and manually change the new NONE option value to -1 through the attributes controller.

So I need a way to either a) fix the sort order so it could be
Option Value NONE Sort Order 0
Option Value 1 Sort Order 10
Option Value 2 Sort Order 20
Option Value 3 Sort Order 30
Option Value 4 Sort Order 40
Option Value 5 Sort Order 50

Or add Option Value NONE Sort Order -1 to all products with the associated Option Name. I don't mind if this has to be done through the database either. I'm sure it must be a common problem.