Change order of options

Hi - Can someone tell me if it is possible to change the order of the options that display on the page? I can see the order by OptionName, but when I change it to OptionID the add to cart function does add the correct options to the cart. If you are sorting sizes small, medium, and large by name they do not sort in the proper order. Instead I would like to sort them by id since I entered them in the order that I want them to display.

Thanks for your help.

You should be able to change the order of the options.

Are you referring to the options that are shown on the product detail page?

Yes - sorry I should have been more clear. On the Product_Details.php page.

If there is only one set of options it works fine, but if there is more than one set of options and you change the sort order here from OptionName to OptionID:

$query_OptionValues = sprintf("SELECT options.OptionName,options.OptionID, productoptions.ProductID, products.ProductLive FROM options INNER JOIN productoptions ON productoptions.OptionID = options.OptionID INNER JOIN products ON products.ProductID = productoptions.ProductID WHERE OptionGroupID = ".$row_ProductOptions['OptionGroupID']." AND GroupingID = (SELECT GroupingID FROM productoptions WHERE productoptions.ProductID = ".$PIDParam_ProductOptions." LIMIT 1) ".$AddToWhere." ORDER BY OptionID", GetSQLValueString($OGIDParam_OptionValues, "int"));

The order changes to the correct order that I want, however, if I add the item to the cart, the incorrect options are added.

You will need to make the update in the look up file (Product_Details_Lookup.php) as well. A similar query should be in that file.

Thanks for getting back to me. I made the change in the Products Lookup file as well, but it still does not put the proper combination of selected items in the cart. Anywhere else, I should make change?

those two places are where you will need to make the modifications. I did a quick test and the correct options are adding correctly.

The only difference i see between the change i made and the change you have is that my order by looks like this:

ORDER BY options.OptionID

instead of

ORDER BY OptionID

and similarly in the Products_Detail_Lookup.php file. Please trying making this change and let me know if it solves your issue.