Order of variants on Product Page dropdown

I have created a product with an option product that has variants.
The option product lists on the product page with a dropdown. So far so good.
After trial and error I realized that I could set the default value of the Option Product by selecting the variant and saving the product, ok.
However, I cannot seem to order the variants in the dropdown correctly. (they are actually dates and I want them in date order)
Characteristic ID 'Value' Variant ID
19 Default 52
20 May 51
21 June 50
22 July 53
This results in the dropdown ordered July(22/53) June(21/50) Default(19/52) May(20/51)

The hikashop_variant table has a relation 'ordering'. Can this be used, even if directly edited in the database?

Nicolas,
Thank you for your reply.
I commend you on the switch between ID and Alphabetical in your design.
However, it seems to fail when used on an Option product. Please review these urls:
www.ip3inc.com/index.php/ordering The option product with variants; correct ID ordering
www.ip3inc.com/index.php/cisspfull The 'main product' whose option product variants are listed alphabetically

If I have something configured incorrectly please help me understand what that might be.

Paul

line 701

seems to have done the trick.

Thanks!

This has helped me also. Thanks Nicolas

I'm having a similar problem. It wasn't following the order of the IDs. However, I went into the database and found the characteristics table and manually adjusted that table in the characteric_ordering column and I was able to get it to work. Having trouble finding an area in the Hikashop settings to adjust these values.