Need help with attribute order in drop down product menus

[Guest]

I just recently installed 2.2ms1 and need help with the sorting order of the product attributes. I need the product attributes to show up in the drop down menus in a certain order each time...ex. Size---> Small, Medium, Large, 1x, 2x, 3x

Problem is that no matter how I assign the attributes in the admin, they always come out in a different order on the product page. I just need a simple fix...please help!

[Guest]

As I understand it, the product attributes should display in the order that they are entered - but you could give this a try just to make sure ...

 

find this line in product_info.php

 

$products_options = 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 = '" . $coll['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'");

 

 

and change it to ...

 

$products_options = 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 = '" . $coll['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "' order by pov.products_options_values_id asc");

 

Now enter the attributes in the order you would like them displayed - ie first item to be displayed gets entered first.

 

HTH

BrianD

[joekilo]

thaks ive just used your advice and it worked for my order of attributes...im thinking of using my attributes for customer to choose a shipping charge for whether uk or europ or world...then turn of shipping within the admin...can anyone tell me if this is a safe and workable procedure or can i should i set the shipping for these three as zones? but with the one charge per zone.....can anyone help thanks

[Guest]

I cut and pasted the replaced code as you suggested but the attribute boxes on the product page had nothing in them.

 

Do I have to create entirely new attributes? I created the original attributes (small, medium and large) in the order I want them to appear, but the first entered in the create attributes of the admin , always appears at the bottom of the dropdown list. This isn't good because the default should be the lowest price. Any advice on why the attributes dropdown showed up with empty listings?