change list order for attributes

[yatesy87]

hi,

 

i have setup a store which has optional colours for the product, it has 4 colours.

 

I want white to appear first as it is standard how do i make white appear first in the list?

[Avec]

A quick and dirty way is to add a field to products_options_values called products_options_values_sort. Manually enter the sort order you want them (white = 1, black =2, etc) Then add ORDER BY products_options_values_sort in the appropriate places.

 

It is manual, so if you add a color you need to use PHPMyAdmin to give the new color a sort value, otherwise it does not show.