Sorting question dealing with numbers.

[redrumloa]

Please see this example.

http://www.redrumloa.com/index.php?m...&cPath=182_183

See how it sorts numbers? not 1-10 then 11-20 etc. No, it does 1, 10, 2 etc.

Again, thank you for your kind assistance.

[patski]

Do you mean the item names aren't being correctly sorted? If so then they are according to the item name. In that context ie a text string, a number is just treated as more text therefore in an alpha listing you get 2,201,3,301 etc.

There are a number of places you can set sort orders - on the products themselves at the bottom of the entry page, or there are other settings in the various listing pages under Configuration which you could play around with.

[redrumloa]

Hi!

Here's the problem. I am trying to use Easy Populate to upload very large quantites of products and Easy Populate does not have a field for sort order. By default Zen Cart sorts alphabetically correct, but chokes on numbers 1, 11, 100, etc THEN 2. I'm hoping there is a way for it to sort numbers ascending correctly, then I won't need a special sort field.

[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 ...