Sorting Numbers in Product Name

Hi,

You won't be able to do that with the options available.
In the options available, you can select a column on which the sorting will be done and whether the sorting can be ascending or descending.
And then, MySQL will sort the elements based on the type of the column in the database. So if you use the product_name column, its type is varchar, and thus the sorting will be alphabetical. If the type of the column would be "integer" for example, then the sorting would be numerical.
But what you want is a hybrid numerical and then alphabetical sorting on one column.

The only solution, supposing you don't have a # at the beginning of the product_name but directly the number, is to use this trick:
stackoverflow.com/questions/34054293/ord...habetically-in-mysql
That way, you have the number at the beginning of the text handled as a number for the sorting, and then the text behind handled as text.
However, there is no system in HikaShop to set "order by b.product_name + 0, b.product_name" in the options. That can be done by developing a small plugin implementing the onBeforeProductListingLoad ( www.hikashop.com/support/documentation/6...reProductListingLoad ) event and overriding the $order parameter. For a PHP developer, it should be easy to do.