Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Specifying the order of products attributes


Recommended Posts



Some of the products I am entering into the shop come in varying lengths from 36 to 60 inches and every inch inbetween. The problem is that on the product page, the dropdown list containing all the available lengths is not in number order, e.g. it goes 36, 37, 38, 45, 39, 40, 43......


Is there an option somewhere specify that you want the options to be listed in alphanumeric order? If not, any idea where the MySQL query is so that I can specify it at that level?


Many thanks.

Link to comment
Share on other sites

I just found a solution.


Go to line 118 in products_info.php and add the following code to the end of the database query:


ORDER BY pov.products_options_values_name ASC



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...