How to reorder available option field elements for a product

[libman]

Hi Folks,

 

I have a bit of a problem. I have some products that have available options such as size and color.

I want the sizes to go from small to extra large. Some of the sizes are out of order. In other words I want the field options to open up and read: small, medium, large, extra large, etc...My situation the sizes read: small, extra large, medium, blah blah blah..

 

Any help would be greatly appreciated...

 

Regards,

G.landry

[Guest]

You can use this contribution to sort product attributes: http://www.oscommerce.com/community/contributions,2924

[libman]

You can use this contribution to sort product attributes: http://www.oscommerce.com/community/contributions,2924

Thanks for the response. I installed as directed and got the following error. Any hints:

 

1054 - Unknown column 'pov.products_options_values_sortorder' in 'field list'

 

select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_sortorder, pov2po.products_options_id from products_options_values pov left join products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '1' order by pov2po.products_options_id, pov.products_options_values_sortorder, pov.products_options_values_id

 

[TEP STOP]

[Guest]

it means you did not install the contribution properly. Run the install_sortoptionvalues.php file

[libman]

it means you did not install the contribution properly. Run the install_sortoptionvalues.php file

 

Where do I find this file?

 

Regards,

G.Landry

[libman]

Where do I find this file?

 

Regards,

G.Landry

 

Sorry, I did find it. I guess I'm not sure how to run the install_sortoptionvalues.php file

 

Regards,

G.Landry