Sort Product Option Value Alphabetically

[grebow]

Ok Here it goes. I am using OSC 2.2 and I have a slight problem.

 

The company I am using the system for is selling candles.

The Candles are arranged by size then broken down to scents.

 

As I place the scent names in they are not appearing alphabetically. Or Alpha Numerically if that is the corect way to say it.

 

Basically is there a way to sort the Product Option Value.

 

Here is a link to the storefront. http://www.beacondlites.com/mall/product_i...;products_id=33

 

Notice the drop down for the scents is not alphabetical order but the order in which the sents were entered the first time. I need to get them alphabetized as the store adds new acents all the time. I did try and place numbers in front of the Value but I have had no luck.

 

Any suggestion you may have would be appreciated. BTW I did do the sort order and went through the contributions. I may not kow what to look for exactly. Heeeeelllllpppppp.

 

grebow.

[Guest]

if you set all the sort orders to the same number, osc automatically sorts aphabetically.

[grebow]

if you set all the sort orders to the same number, osc automatically sorts aphabetically.

 

 

Where would that option be?

[GulSar Ray's]

Ok Here it goes. I am using OSC 2.2 and I have a slight problem.

 

The company I am using the system for is selling candles.

The Candles are arranged by size then broken down to scents.

 

As I place the scent names in they are not appearing alphabetically. Or Alpha Numerically if that is the corect way to say it.

 

Basically is there a way to sort the Product Option Value.

 

Here is a link to the storefront. http://www.beacondlites.com/mall/product_i...;products_id=33

 

Notice the drop down for the scents is not alphabetical order but the order in which the sents were entered the first time. I need to get them alphabetized as the store adds new acents all the time. I did try and place numbers in front of the Value but I have had no luck.

 

Any suggestion you may have would be appreciated. BTW I did do the sort order and went through the contributions. I may not kow what to look for exactly. Heeeeelllllpppppp.

 

grebow.

 

the query on line 122 in product_info.php page must contain order by popt.products_options_name

 

$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' <b>order by popt.products_options_name</b>");

[grebow]

the query on line 122 in product_info.php page must contain order by popt.products_options_name

 

$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' <b>order by popt.products_options_name</b>");

 

 

Looks exactly the same.

G

[grebow]

I am still having difficulties with this feature. If anyone has any suggestions other than those posted please help.

 

I cannot tell where to force the product options sort in .php or I may be wrong and I may have to make a change in the SQL database somewhere. If that makes any sense. I can post the files or send them to you directly so you can see what I have and if I have made a mistake. The main issue is that I do not know which files control this feature.

 

I have tried numbering the files and that did not work. I am guessing that the sugesstion to number the file names was to number them all with the same number?

 

Thanks for any help.