Product Attributes HOW TO

[Guest]

UNDER Admin>Catalog>Products Attributes:

 

can some one help: i am trying to add "OPTION VALUES" as follow:

 

1.0, 1.5, 2.0, 2.5, 3.0,...

 

BUT it keep grouping 1.0, 2.0, 3.0 to one group and

1.5, 2.5, 3.5....to another group!

 

please email to [email protected]

[Guest]

you will need to add a contribution for attribute sort order

[Guest]

It might be easier just to make this change:

 

To sort the product attribute values, find this code in store/product_info.php:

 

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " .TABLE_PRODUCTS+OPTIONS_VALUES . "pov where pa.products_id = '" . (int)$HTTP_GET_VARS('products_id'] . "' and pa.options_id = '" .

(int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and

pov.language_id = '" . (int)$languages_id . "'");

 

and replace the last line "pov.language_id ... " with this:

 

pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name asc");

[bglkk]

With the contribution, you can assign weights to change the sort order to whatever you want.

 

http://www.oscommerce.com/community/contributions,1690

[Guest]

It might be easier just to make this change:

 

To sort the product attribute values, find this code in store/product_info.php:

 

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " .TABLE_PRODUCTS+OPTIONS_VALUES . "pov where pa.products_id = '" . (int)$HTTP_GET_VARS('products_id'] . "' and pa.options_id = '" .

(int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and

pov.language_id = '" . (int)$languages_id . "'");

 

and replace the last line "pov.language_id ... " with this:

 

pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name asc");

thanks mate!

 

tried...and it works....cheers...

[Guest]

It might be easier just to make this change:

 

To sort the product attribute values, find this code in store/product_info.php:

 

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " .TABLE_PRODUCTS+OPTIONS_VALUES . "pov where pa.products_id = '" . (int)$HTTP_GET_VARS('products_id'] . "' and pa.options_id = '" .

(int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and

pov.language_id = '" . (int)$languages_id . "'");

 

and replace the last line "pov.language_id ... " with this:

 

pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name asc");

thanks mate!

 

tried...and it works....cheers...