Sort order of option values

[Nick1973]

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.

[Ajeh]

Go to the Catalog ... Option Value Sorter ... and set the Values you want to have ...

Once set, you can run the:

Update All Products' Attribute Sort Orders
to match Option Value Default Sort Orders:

And this will fix ALL Attributes for ALL Products with the Default Sort Orders on ALL Option Values ...

NOTE: Backup your database before using this ...

[Nick1973]

Go to the Catalog ... Option Value Sorter ... and set the Values you want to have ...

Once set, you can run the:


And this will fix ALL Attributes for ALL Products with the Default Sort Orders on ALL Option Values ...

NOTE: Backup your database before using this ...

Thanks Linda, never used that so wasn't to know. Will save lots of time!!!!

[Ajeh]

You are most welcome ... thanks for the update that this was able to work for you to fix your Option Values Sort Order ...