Sort by model

[DocRocks]

Hello Zenners,

Found this thread (http://www.zen-cart.com/forum/showthread.php?t=70194) and followed its advice but it didn't work.

I'm using ZC 1.3.7.1, and have tried to change the product sort order using the Display Product Listing Default Sort Order. I have changed the values from 1a through 6a but nothing happens in my catalog - example page at http://prestonribbons.com/catalog/in...dex&cPath=17_5

I would appreciate some help on getting this to work.

Thanks

[Webskipper]

Admin/ Configuration-Product listing-Display Product Listing Default Sort Order



1a=model number sort ascending
1d=model number sort descending
2a=name sort ascending
2d=name sort descending
4a=price sort ascending
4d=price sort descending

Basically leave it alone and it will sort A-Z and 1-9.

I just let it ride.

[DocRocks]

Thanks for the info.

Setting it at 1a or any other of the allowed settings has had no effect. I had some coding work done on this file to enable display of the sizes in columns. I'll get back to the php guru who did the job and see if his code is blocking the sorting.

[Ajeh]

Actually, it is working ... the problem is it appears to not be working because it doesn't follow human logic but follows computer logic ...

Your module numbers are being addressed as character/number which means they are not numerically handled but handled as ascii ...

This means:
1
11
111
2
22
222

vs what you want:
1
2
11
22
111
222

If ALL products_model are numeric with NO characters, you could make that field numeric vs varchar ...

IF this is the case, backup your database and change the field type to INT and see if the sort method magically fixes itself for you ...

[janellez]

Linda (or someone),

I know I'm bringing up an old topic but can anything be done when a client has both numerical and non-numerical model numbers?

[Ajeh]

What are your model numbers like that you are having a problem with?