Option Names ... how do I sort by sort number?

[xcergy]

In v 1.3.9 I had 20 color variations with a sort number of 100
5 size variations with a sort number of 200
several numerical options with a sort order of 300

The result was items are groups and always displayed alphabetically, even after adding new options.

v1.5.4 only offers sort by Option ID and ID Name.


How can I get v1.5.4 to sort by sort#?

TIA

[kobra]

had 20 color variations with a sort number of 100

These should not all have the same sort order number
Use something like
100
110
120
130
etc

[xcergy]

These should not all have the same sort order number
Use something like
100
110
120
130
etc

Why? Even if I did, the display does not sort by sort number, and that's what I want. 1.5.4 offers only two options, ID# and Name.

[kobra]

You can set order in the attributes controller

[RixStix]

Not that I can help....
I think the OP might be talking about
Admin
Catalog
Option Name Manager

[mc12345678]

When I go to product info on zc 1.5.4, there is the following option: Products Info - Products Option Name Sort Order
Please make any necessary changes

Products Info - Products Option Name Sort Order
Sort order of Option Names for Products Info
0= Sort Order, Option Name
1= Option Name

0
1

This allows sorting at least the option names by sort order, and if two or more option names have the same sort order then it is supposed to sort by name... As for the values, there is a sort order there as well...

If they are not sorting by these values, there is always the store manager under the tools menu, which has a reset option for option names and values... That may restore the sorting that you seem to want for your product.

[xcergy]

When I go to product info on zc 1.5.4, there is the following option: Products Info - Products Option Name Sort Order
Please make any necessary changes

Products Info - Products Option Name Sort Order
Sort order of Option Names for Products Info
0= Sort Order, Option Name
1= Option Name

0
1

This allows sorting at least the option names by sort order, and if two or more option names have the same sort order then it is supposed to sort by name... As for the values, there is a sort order there as well...

If they are not sorting by these values, there is always the store manager under the tools menu, which has a reset option for option names and values... That may restore the sorting that you seem to want for your product.

I tried that. Products info is set @ 0
Went to tools/store manager, that did no good either.
Went to catalog/name sorter ... even changed sort#s. That screen sorted by sort number, but in
/[admin]/options_name_manager.php, it will still not sort by sort#

[mc12345678]

I tried that. Products info is set @ 0
Went to tools/store manager, that did no good either.
Went to catalog/name sorter ... even changed sort#s. That screen sorted by sort number, but in
/[admin]/options_name_manager.php, it will still not sort by sort#

Ohhhh.. So the goal has been to display option names in sort order on the option_names_manager this entire time??? Ohh... Well, that can be done with:

First add the language define file for the following addition:

in admin/includes/languages/YOUR_LANGUAGE/options_name_manager.php
add a define for sort order like this:

define('TEXT_OPTION_SORT_ORDER', 'Option Sort Order');

find, this was around line 562 of admin/options_name_manager.php (line number was referenced from a file that has already been modified to support Stock-By-Attributes and therefore line number is likely off by a bit):

                <td valign="top" align="left"><form name="option_order_by" action="<?php echo zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, 'option_order_by=' . $option_order_by, 'NONSSL'); ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option></select></form></td>

And "add"/replace with:

                <td valign="top" align="left"><form name="option_order_by" action="<?php echo zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, 'option_order_by=' . $option_order_by, 'NONSSL'); ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option><option value="products_options_sort_order"<?php if ($option_order_by == 'products_options_sort_order') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_SORT_ORDER; ?></option></select></form></td>

[mc12345678]

Ohhhh.. So the goal has been to display option names in sort order on the option_names_manager this entire time??? Ohh... Well, that can be done with:

First add the language define file for the following addition:

in admin/includes/languages/YOUR_LANGUAGE/options_name_manager.php
add a define for sort order like this:

define('TEXT_OPTION_SORT_ORDER', 'Option Sort Order');

find, this was around line 562 of admin/options_name_manager.php (line number was referenced from a file that has already been modified to support Stock-By-Attributes and therefore line number is likely off by a bit):

                <td valign="top" align="left"><form name="option_order_by" action="<?php echo zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, 'option_order_by=' . $option_order_by, 'NONSSL'); ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option></select></form></td>

And "add"/replace with:

                <td valign="top" align="left"><form name="option_order_by" action="<?php echo zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, 'option_order_by=' . $option_order_by, 'NONSSL'); ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option><option value="products_options_sort_order"<?php if ($option_order_by == 'products_options_sort_order') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_SORT_ORDER; ?></option></select></form></td>

If want an Ascending/Descending option, then:

                <td valign="top" align="left"><form  name="option_order_by" action="<?php echo  zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, 'option_order_by=' .  $option_order_by, 'NONSSL'); ?>"><select name="selected"  onChange="go_option()"><option value="products_options_id"<?php  if ($option_order_by == 'products_options_id') { echo ' SELECTED'; }  ?>><?php echo TEXT_OPTION_ID; ?></option><option  value="products_options_name"<?php if ($option_order_by ==  'products_options_name') { echo ' SELECTED'; } ?>><?php echo  TEXT_OPTION_NAME; ?></option><option  value="products_options_sort_order ASC"<?php if ($option_order_by ==  'products_options_sort_order ASC') { echo ' SELECTED'; } ?>><?php  echo TEXT_OPTION_SORT_ORDER_ASC; ?></option><option  value="products_options_sort_order DESC"<?php if ($option_order_by ==  'products_options_sort_order DESC') { echo ' SELECTED'; } ?>><?php  echo TEXT_OPTION_SORT_ORDER_DESC; ?></option></select></form></td>

in admin/includes/languages/YOUR_LANGUAGE/options_name_manager.php
add a define for sort order like this:

define('TEXT_OPTION_SORT_ORDER_ASC', 'Option Sort Order ASC');

define('TEXT_OPTION_SORT_ORDER_DESC', 'Option Sort Order DESC');

[mc12345678]

@xcergy,

Please in the future be more specific about the problem. Doesn't require a lot of words, or complete sentences, but if had known that the issue was at admin/options_name_manager.php then a solution could have been provided a lot sooner... Yes, my "last" post was a few hours after RixStix had offered a potential location to "fix" which was confirmed hours after that post, but I had begun my post many hours before that and had wanted to wait to respond until I had at least reviewed my post. Finally reviewed and considered acceptable for posting (though didn't confirm what had already been added to the thread).

Anyways, my previous postings were with concern more about the store front part of operation. Yes I could have asked about where the issue was instead of offering "blind" advice... Please though, help everyone to be able to help you, give enought detail to reproduce the issue or to see where it is an issue (No, no one expects you to post your admin credentials).

Hope that helped. BTW, for anyone else that stumbles upon this looking for the same type thing, the value that is in the option value="" part is used as the mysql sort order criteria...

So if want to sort by other criteria or combinations of criteria, then can replace the pair of data with that new criteria and provide whatever "human readable" text represents that sort order in the language define...