Display Product Listing Default Sort Order

[Website Rob]

Maybe I'm just not understanding the concept of the "Display Product Listing Default Sort Order".

If I cannot display by Product ID and in Descending or Ascending order, what is the purpose of that option in the Admin section?

But if you leave the Default Sort Order switch blank, then it will sort by the Sort Order you've assigned to the products, followed by the product name.

How would I do that?

To my knowledge, if I leave the sort order blank then products are listed/displayed Alphabetically.

[DrByte]

To my knowledge, if I leave the sort order blank then products are listed/displayed Alphabetically.

Yes, after they are sorted by their individual sort orders. (And if all have no sort orders, then they effectively all have the same value: 0 ... meaning that only the secondary alphabetical sort by product name applies.

How would I do that?

1. Leave Admin->Configuration->Product Listing->"Display Product Listing Default Sort Order" blank.

2. Edit each and every one of your products and give each one a sort order, based on the order in which you want them to show up.

Now whenever they show in a product listing, they will appear in the order of the sort order you supplied for each product. If there is more than one with the same sort order value, then the product name will be the secondary sort, in alphabetical order.



Or if you'd rather write custom code to change how the SQL pulls products from the database, you can do that too.

[Website Rob]

OK, that works. Thanks for the tip.

So what then, is the purpose of the "Display Product Listing Default Sort Order"? Even after giving each product an individual sort order number, I still got the same results as mentioned previously for using 2d or 2a.

It doesn't seem to key on Product ID or Sort Order Number so what then does it key on, in order to determine the Sort Order?

[Ajeh]

The options are to use one of the existing columns (fields) in Ascending (a) or Descending (d) order ...

This can be seen by clicking on the titles themselves to see the "matching code" for you particular settings on your products listing ...

This changes based on the assigned sort order of the fields ...

If you want the assigned sort order of the products to be the default, there isn't a code to enter for the sort order ... the code is to leave the sort order blank as stated in the Product Listing configuration settings:

Display Product Listing Default Sort Order
Product Listing Default sort order?
NOTE: Leave Blank for Product Sort Order. Sort the Product Listing in the order you wish for the default display to start in to get the sort order setting. Example: 2a

Now it will display by the sort order you assigned to each product when viewing the Product Listing ...

[Nick B]

Hi again.
Totally understand all of this thread and have changed lots to make sure I understand it inside out and I do.
The only thing is that when I set the Default Sort order to Price (ascending) it just doesnt work. I know it can be selected to sort this way on the page by the customer which is great but so far i have had 3 people who missed that so a default way would be good.
I'm using 3a as a code. Havent changed any orders from stock.

Thank you ;-)
Nick.

[Nick B]

Eek, more fiddling and I was using the wrong code. I assumed it was taken from the VALUE but its not its the listing top to bottom:

Hope this little table helps to explain to others.

Code TITLE VALUE
1 Display Product Image 1
2 Display Product Manufacturer Name 0
3 Display Product Model 1
4 Display Product Name 2
5 Display Product Price/Add to Cart 3
6 Display Product Quantity 1
7 Display Product Weight
And, as you have said, add an a for ascending and a d for descending.
In my case making 5a
Beautiful, like you zenners ;-)
Nick.

[DrByte]

Eek, more fiddling and I was using the wrong code. I assumed it was taken from the VALUE but its not its the listing top to bottom:

No, actually it's taken from the column-number across the page when it's displayed.
Since you have non-zero values of "1, 1, 1, 2, 3", your 5th column is the "3", which in your case is the sort-by-price you desired.

Glad you got it working the way you want.