Filters and Category Display Order

Hi,

I was wondering, if possible, to change the StoredProc for Ajax Filters because it doesn't take into account child category display order for parent categories.

For example (display order in brackets):

Parent Category: SHOES (1)

Child Categories:
Boots (1)
Trainers (5)
Sandals (3)

Products:

Boots:
- Product A (1)
- Product B (2)
- Product C (3)

Trainers:
- Product D (1)
- Product E (2)
- Product F (3)

Sandals:
- Product G (1)
- Product H (2)
- Product I (3)

If you then view parent category Shoes, you end up with this:

- Product A
- Product D
- Product G
- Product B
- Product E
- Product H
- Product C
- Product F
- Product I

It doesn't take into account the child category display order.

It should be:
- Product A
- Product B
- Product C
- Product G
- Product H
- Product I
- Product D
- Product E
- Product F

Because of the child-category display order.

Do you think this could be changed in the system?

Many thanks,
Jorge

Hi Jorge,

The way products are sorted in a given category is not controlled by the Ajax Filters.
The Ajax Filters control only the list of products after a filtration, which is the same one that has been chosen by the client or the default one when you open a category. So the initial sorting of the products within a category is controlled by the nopCommerce search products stored procedure.
The Ajax Filters can only allow you to change the default display order, which is by position, to be any of the other sorting options i.e Price etc.
You can test this by turning off the Ajax Filters and you will see that the sorting is the same with or  without them.

Thanks

Hi.

Initial load is running NopCommerce stored procedure. But as soon as I used filter, that's the point where Seven Spikes ProductLoadAllPagegNopAjaxFilters procedure running, and the problem is returning. Does 7Spikes going to amend SP and include category hierarchy into the "order by" in future?

Hi kaunuk,

We need to be consistent with nopCommerce.
Otherwise the order will differ after a filtration, which is not good.
So if nopCommerce do it then we will do it too.

Thanks