Product Sorting Order

[Big_Woody]

has any one sussed out how to sort Products by dated entered .. i can get it to work

Cheers

[Jeff G]

op999,

Your problem is a typical ASCII sort issue.
I assume your sizes are the beginning of the product name, so you have something like..

10" wide
2" wide
20" wide
4" wide

To the computer that is sorted. Text is left sorted.
You then have 1,2,2,4 sort order.
I'm new to Zen and sql, so I can not offer much help on a fix, only the "why".

One possible (but pretty ugly) solution is to zero fill your sizes.
02", 04", 10", 20"
And if your sizes go over 99 you actually need more leading zeros.

[Jeff G]

I also have a product sort question...

When selecting a category, the index display is sorted by product name.
I am displaying "model" in the first column and would like products sorted by the model number.

I have not been able to find a switch/setting for changing sort order on the list page.

Is is a setting or code change somewhere?

Thanks,
Jeff

[Jeff G]

Disregard last question.

I found the setting.

The required entry was not so obvious based on the help description.

[erwin208]

after setting the sort order in your admin (10,20,30, ....) you have to make the right setting in admin/productinfo >> Previous Next - Sort Order

Products Display Order by
0= Product ID
1= Product Name
2= Model
3= Price, Product Name
4= Price, Model
5= Product Name, Model
6= Product Sort Order

the right setting is 6.
now the appearance sorting in the product info will be the same as your productlisting.

[khopek]

I guess I'm confused because my product won't list by date added. I want the newest products showing first, and it's just not doing that. Do I REALLY have to enter a sort order for each individual product? That just seems like a huge waste of time and too hard to remember where you left off the last time you added something...?

[Ajeh]

Date is actually not an option on the Product Listing nor the Product _info pages ...

The New Listing, Featured, All Listings all offer:

1= Products Name
2= Products Name Desc
3= Price low to high, Products Name
4= Price high to low, Products Name
5= Model
6= Date Added desc
7= Date Added
8= Product Sort Order