Extra Field Options ordering

[markjackson]

V4.2.1 Developer (edit), default

I have added an extra field (CONDITION, drop-down), in which I have a few options (new, like new, perfect, good, poor, ...

I would like them to display in the order as I just typed, makes since new-to-poor, but it auto displays in alpha order. Is there a way to change that. I see setting for weight in other section of the site, but not Extra Field-Options?

Thanks

[Mike-N-Tosh +]

Although may not be the elegant way, is to simply prefix your options with either a number or character.

Like this:
a. new
b. like new
c. perfect
d. good
e. poor

or numbers.

As with anything there are other methods, with this example in particular would be much more complex.

[markjackson]

Just wanted to see if there was another option before I started my build out.

Do you think adding a number or letter to get the order I want hurt searching for say "like new".

[seymourjames +]

Its a good question about searching although it certainly will not affect the dropdown in the search (you could manually code in the options if you don't have too many extrafields and options in the order you like). Try a little experiment on that.

[Mike-N-Tosh +]

Originally Posted by markjackson

Just wanted to see if there was another option before I started my build out.

Do you think adding a number or letter to get the order I want hurt searching for say "like new".

As this is already a drop down field, when you search it is also going to be a drop down field which means that it is going to populate the field as it appears, therefore that will not affect your searches.

[Mike-N-Tosh +]

Originally Posted by seymourjames

Its a good question about searching although it certainly will not affect the dropdown in the search (you could manually code in the options if you don't have too many extrafields and options in the order you like). Try a little experiment on that.

Bear in mind that if this is NOT the only extra field that you have and is not a global field (e.g. assigned to ALL categories), manually coding the drop down will bring in much more complication to the issue as the extra fields are called via javascript/AJAX. This would affect both advanced search as well as the checkout.

[John Snyder +]

Ordering them the way Mike described with numbers or letters is just about the only way to do this with the designer version.

In the developer version you could order by field option id, but it would be global effecting all extra field options. Depending on the page the you want to alter the display of options you would need to edit either ajax.php or includes/kernel/Listings.php, the change would be almost identical in both places.

Find:

PHP Code:

$ssql = "SELECT optID,fieldID,optValue,optOrder FROM " . PREFIX . "fields_options WHERE fieldID=" . (int) $row['fID'] . " ORDER BY optValue"; 


Replace :

ORDER BY optValue

with:

ORDER BY optID

[markjackson]

My mistake, I do have v4.2.1 Developer

It would be fine with me if all Extra Field Options listing based on optID then, but that leads to another question.

How do I set the optID value or is that based on the option box I am typing in?

Searching, so in my example if some just did a quick search for say "like new", the text in my Extra Field Option is not including in that. All Extra Field Options are search for based on the field type I have selected, not text search. So only the "title", "short description", and "description" are searched with text?


Thanks for the help guys, this is my first post here and you guy are very helpful.

[John Snyder +]

optID is automatically set and should be in the order you add them

[markjackson]

That may not work then, if I need to add a new option after a few weeks or months, then there would not way to say place it in the middle of the list. Really thinking the alpha or numeric before the options is going to end up as the winner. Unless I could add/adjust the optID inside the database directly.

Thanks again for the help.