Product options in random order

Hi, is there a way to get my product options to appear in the order i create them?. on some product pages the options are in order like

products_detail.php?ProductID=63.

but on the other page:

products_detail.php?ProductID=59.

i have found that deleting and re-creating the option, sometimes sorts this issue out. But is a major headache. i have had a look through related posts on here but i think they are for older versions of powerstore as i do not have the file location CSSMenuWriter/cssmw_home/menu.php

Plus when you click on one option being silver or black under the option (case colour), the option below it (Image Finish - Glossy Metal) appears above ???

you can force the options to be listed in the order you create them by editing the webassist/plugins/shopping_cart/add_to_cart.php page, change:

$query_OptionValues = sprintf("SELECT ps4_options.OptionID, OptionName FROM ps4_options INNER JOIN ps4_optiongroups ON ps4_optiongroups.OptionGroupID = ps4_options.OptionGroupID  WHERE ps4_options.OptionGroupID = %s  ", GetSQLValueString($OGIDParam_OptionValues, "int"));

to:

$query_OptionValues = sprintf("SELECT ps4_options.OptionID, OptionName FROM ps4_options INNER JOIN ps4_optiongroups ON ps4_optiongroups.OptionGroupID = ps4_options.OptionGroupID  WHERE ps4_options.OptionGroupID = %s  ORDER BY ps4_options.OptionID DESC", GetSQLValueString($OGIDParam_OptionValues, "int"));

that code will be in 2 places.

This post has been deleted.

i uploaded the add_to_cart.php with the changes but it has made no difference. the options for the product are still in random order.

what im trying to achieve is this order for the option (image finish)

Glossy Metal
Mirror Metal
AIR-FX (Lid)
AIR-FX (Full Case)

but whats happening is

Glossy Metal
AIR-FX (Lid)
AIR-FX (Full Case)
Mirror Metal

products_detail.php?ProductID=59

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

I am also having this issue. I have changed the code as suggested in this thread, but it does not seem to help.
Is there anyway to specify the order in which you would like product options displayed?

Thank you,
-Matt K

If you post FTP information and a url to the page where I can see the problem, I can take a look and suggest how it could be updated.