aheisey Posted February 25, 2006 Share Posted February 25, 2006 I set up my available options in the products attributes and it works fine, but how do I set it so that the pull down menu displays 'None'? I tried inputing 'None' first and last but the software keeps putting it in the middle of the list or at the end. For example I want my customers to choose colors (additional cost) or chose 'None'. I'd like the 'None' attribute to be at the top of the drop down list or the default. Anyone know the trick to this? Link to comment Share on other sites More sharing options...
c_karsan Posted February 25, 2006 Share Posted February 25, 2006 you should have a sort order associated with each attribute, set the 'none' attribute to sort order '0' and the rest to 1, 2, 3, 4 etc... in the order which you want them displayed The sooner you fall behind, the more time you'll have to catch up. Link to comment Share on other sites More sharing options...
ThoroughWeb Posted February 26, 2006 Share Posted February 26, 2006 you should have a sort order associated with each attribute, set the 'none' attribute to sort order '0' and the rest to 1, 2, 3, 4 etc... in the order which you want them displayed I do not see sort order as an option anywhere on the attributes page. Is it a contribution that needs to be installed? I set up my available options in the products attributes and it works fine, but how do I set it so that the pull down menu displays 'None'? I tried inputing 'None' first and last but the software keeps putting it in the middle of the list or at the end. For example I want my customers to choose colors (additional cost) or chose 'None'. I'd like the 'None' attribute to be at the top of the drop down list or the default. I had the same problem, I'm assuming from making additions and deletions and then more additions, and ended up going back and forth between my drop down menus and my attributes list and switching them until I had them in order. So for example, if you have colours as Red, Blue, None, Black, and want None at the top. Find red, make it none, then find the other instance of none and make it red. Can take a while but I couldn't find another way to sort them properly. I'm sure someone else has a better solution, but that's mine :) Link to comment Share on other sites More sharing options...
aheisey Posted February 26, 2006 Author Share Posted February 26, 2006 I do not see sort order as an option anywhere on the attributes page. Is it a contribution that needs to be installed?I had the same problem, I'm assuming from making additions and deletions and then more additions, and ended up going back and forth between my drop down menus and my attributes list and switching them until I had them in order. So for example, if you have colours as Red, Blue, None, Black, and want None at the top. Find red, make it none, then find the other instance of none and make it red. Can take a while but I couldn't find another way to sort them properly. I'm sure someone else has a better solution, but that's mine :) We need a better way to manage sorting order in the attributes lists. Thanks for the tip, I'll go back and do that to get 'None' at the top for the default choice. Link to comment Share on other sites More sharing options...
c_karsan Posted February 26, 2006 Share Posted February 26, 2006 best to install a contribution which allows you to add the sort order for the attributes, especially if a lot of your products are going have attributes. Do a search in the contributions section for 'attributes sort' The sooner you fall behind, the more time you'll have to catch up. Link to comment Share on other sites More sharing options...
brazillia Posted February 27, 2006 Share Posted February 27, 2006 I have found the fix to set the order of attribute options as I want them (see below if you are still looking) but how do I add a sort order for the attributes themselves? I want something like: Colour Size Length Other Option 1 Other Option 2 but it sorts alpabetically so I get: Colour Length Other Option 1 Other Option 2 Size I haven't found any contribution that will do this so any help would be appreciated. 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"); Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.