product attribute question

[groggory]

If I set a few attributes using radio boxes, what determines what order they display? I want a particular option to be the default, and if they want differently they can choose.

Thanks

[michael_s]

See this:

http://oscdox.com/index.php?name=PNp...der+attributes

[groggory]

I read through that, and catalog/product_info.php doesn't contain the code they're talking about? Are they referring to base MS2 code? Sorry, I'm still new to hacking all this in...getting better through. If I figure this out I'll toss it in the wiki.

Thanks,

Greg

See this:

http://oscdox.com/index.php?name=PNp...der+attributes

I Found It! It was listed on another support site:

Sort Product Options (attributes)

What it does...
First - sorts by price
Second - if price is same (or 0), it sorts based on the order that the option was entered.

File to change ...
/catalog/product_info.php
********************************************

Replace this line
$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 . "'");


With this line
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id 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 . "'" . " order by pa.options_values_price, pa.products_attributes_id");


OR.......

If you want to sort solely by the order the option was entered (regardless of price) instead use this:

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id 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 . "'" . " order by pa.products_attributes_id");

[groggory]

Oh cool, got it.

I forgot that most of what can normally be found in the catalog directory will be found in your template/content directory. That was the case this time and it was as simply as replacing the code as directed.

If you want to see it in action, look at the flag>full size section of my website at www.upupandawaykites.com . Every flag there has 2 attributes. The 'just the flag' should be the first one everywhere.

On just a fun note, look at the videos on the power blast 4-8 under kites>quad kites. THey're pretty cool. Big powerful kite, lol.

Thanks for all the help. Its really appreciated. This whole website thing is going so smoothly for me.

[michael_s]

Remember that osCMax uses BTS, so the changes will be in :

/templates/[templatename]/content/product_info.tpl.php

I thought you knew that, since you have been working with osCMax for a while now. Any time you see a mod to a file in the base catalog dir, 99.9% of the time, it will be in the /content template of the same name. There are a few small exceptions, but it is rare.

[groggory]

Remember that osCMax uses BTS, so the changes will be in :

/templates/[templatename]/content/product_info.tpl.php

I thought you knew that, since you have been working with osCMax for a while now. Any time you see a mod to a file in the base catalog dir, 99.9% of the time, it will be in the /content template of the same name. There are a few small exceptions, but it is rare.

I just had a brain fart. I don't know why I forgot that. I just blindly followed the instructions. But about 2 mins after I posted my last question, I remember, hacked it in, and you replied to me while I was typign my last response.

I got a couple books on PHP, and its making alot more sense to me lately. The hundreds of files on OSC is all making sense. Its just all coming together. When I ask stupid questions, thank you for responding anyways. This community is so helpful and talented. I hope that I will be able to give back over time. Its really a great project.

Keep up the good work, and thank you!

Greg