Sorting question dealing with numbers.

[patski]

Never used EZPopulate so can't advise I'm afraid. I'm sure someone else will be along in a moment

[Ajeh]

Are you sorting based on products_name or based on products_sort_order

[redrumloa]

Are you sorting based on products_name or based on products_sort_order

Product Name

Thanks.

[Ajeh]

Product Name is text ...

As text, you have to write text in a proper alpha/numeric method

test 1
test 11
test 111
test 2
test 222
test 3
test 4

Or ...
test 1
test 11
test 111
test 2
test 222
test 3
test 4

Or ...
test 001
test 011
test 111
test 002
test 222
test 003
test 004

Or ...
Stick in your physical sort order ...

[Ajeh]

NOTE: a cleaner "Looking" way, but you may need to think a bit more ... as you are trying to force alpha sorts to visually look correct ...

It would be nice if computers had a clue and understood that:

test 1
test 2
test 11
test 22
test 222
test 111
test 3

Does not sort as:
test 1
test 11
test 111
test 2
test 3
test 22
test 222

So, when using alpha/numeric you have to help it a bit ...

Now, you could think out side the box and count spaces

If you know you will have:
Test 1
Test 11
Test 111

And not go higher than 3 digit ... multiple spaces do not show ... so enter the spaces ... where there visually is a space bar or the word space is written, hit the space bar between the Text and number:

Test spacespace1
Test 222
Test spacespace3
Test spacespace2
Test space22
Test space11
Test space33
Test spacespace4
Test 111
Test 333

Will sort correctly ...