Product Sorting Order

[Quadrille]

So under "All products", i want to specify a specific sort order, not have this alphabetical default. I'm wanting to have the items in the sequence i made my videos. So say i want my first video listed, and then my second, and so forth, how do i do this?

[Ajeh]

In the Configuration ... All Listing ... are the choices for:

Display Product Display - Default Sort Order
What Sort Order Default should be used for All Products Display?
Default= 1 for Product Name

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

[Quadrille]

Right, i tried this and it doesn't seem to be working. I assigned the items, for example, "1", in the catalog item sort order field, but it doesn't come out this way. And is Product Sort Order supposed to be an option in the drop down box, or does it just affect the listing by default.

[Ajeh]

While it is an optional default sort order for the page, it is not in the list to switch back to in the dropdown ...

This is managed by the setting in:

and controlled via the files:
/includes/modules/listing_display_order.php
/includes/templates/template_default/templates/tpl_modules_listing_display_order.php

You can work on using copies of these files in your templates and overrides to alter how these work ...

[Quadrille]

Sorry to bump this again but i'm still having no luck. Still getting my listing under the category alphabetically. What values am i supposed to put in the product item sort field? I try "1", thinking it will logically sort that product first, but it has no effect at all. And i do have All Listing set to "8 - Product Sort Order".

[op999]

Me too. I am trying to sort items by size (inches), and items that are, for example, 2" wide are appearing after items that are 10" wide. Any ideas why?

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