Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sort Product Option Value Alphabetically


grebow

Recommended Posts

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.

Link to comment
Share on other sites

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>");

Hard Work Is The Simplest Way Of Success

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...