Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do I set Available Options to a specific value?


aheisey

Recommended Posts

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

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

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

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

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

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

Archived

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

×
×
  • Create New...