Sort functionality within categories

Jason's picture

How would I sort products within a category alphabetically instead of by popularity, low-to-high, or high-to-low?

Also why do my products get sorted randomly, instead of alphabetically, if the prices or popularities are identical....?

Originial post:
I'm having issues with the sort functionality of Znode within categories. I am entering new products and leaving their "Display Order" in Storefront Management as 500. I had assumed that when they were displayed they would be organized alphabetically if there is no difference between two items popularity or price.
I tried to address this issue by actually giving the Display Order field values for each product (to make it alphabetical) but it still is sorted randomly.
Even when i sort high to low or low to high it sorts my items randomly (most are the same price).

Question: Is there a way to have Znode sort things alphabetically instead of randomly if the popularity and/or the price is the same, as opposed to random sort?

admin's picture

Yes

Jason,

You can change the sorting by editing the stored procedure ZNode_GetCategoryByID_XML in the database. If you study that procedure, you will see there are certain changes you can make to have the resultset be sorted to your liking.

Znode Administrator
email: support@znode.com
url: www.znode.com