Sorting Error for product codes >= 100

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.5
-- PHP version -- : 7.0.18
-- Browser(s) name and version -- : Chrome 64.0.3282.186

Product codes over 100 do not sort correctly.
Mass actions and sorting do not consider any values greater than or equal to 100 as being greater than 99.
Instead, it considers 100 as being equal to 0.

This is easy to test.
Just create a product with the code of 100 and a couple of products with codes less than 100 and see how it sorts incorrectly.

Hoping this is an easy issue to fix.

Hi,

That was the exact answer I was looking for.

Thank you

The product_code column is already using alpha characters in many of the products, so changing the data type to integer is not an option.

Will it work if I create a custom field then set it column type to integer in my database and use that to sort the products on the front-end?

Hi,

I'd think that adding zeros in front of product codes beginning with < 100 should also do. Like so:
001...
002...
003...
...
010...
011...
...
099...
100...