Totally Zenned
- Join Date:
- Sep 2008
- Location:
- Cleethorpes
- Posts:
- 1,230
- Plugin Contributions:
- 3
Sort order of option values
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.
Nick Smith - Venture Design and Print
https://venturedesignandprint.co.uk
