Product Sorting Within "show Subcategories"

When subcategories are joined & shown in the main category they don't sort correctly. They sould take the main category+subcatory sorting option the the options sorting like “sorting by title” should be added to that. This maintains the hierarchy settings the merchant has chosen and so products listing in subcatorgies are not promoted out of their sorting value. Or at least this should be an option.



I'll try and show the problem, these are the sorting values for a category with 3 subcategories;



0 rootcat



0 subcatone

1 subcattwo

2 subcatthree



This sorting maintains how the categories show BUT NOT THE PRODUCTS.If you decide to show subcategories within root when clicked.



So it you sort your products by alphabetical order - on title, for example, Products in subcatthree might show above products in subcatone.



This can be anoying if you sort your categories 1 2 3 then the products should show in that order regardless. Or mine shoud anyway.

[quote name='kickoff3pm' timestamp='1434971463' post='219904']

When subcategories are joined & shown in the main category they don't sort correctly. They sould take the main category+subcatory sorting option the the options sorting like “sorting by title” should be added to that. This maintains the hierarchy settings the merchant has chosen and so products listing in subcatorgies are not promoted out of their sorting value. Or at least this should be an option.



I'll try and show the problem, these are the sorting values for a category with 3 subcategories;



0 rootcat



0 subcatone

1 subcattwo

2 subcatthree



This sorting maintains how the categories show BUT NOT THE PRODUCTS.If you decide to show subcategories within root when clicked.



So it you sort your products by alphabetical order - on title, for example, Products in subcatthree might show above products in subcatone.



This can be anoying if you sort your categories 1 2 3 then the products should show in that order regardless. Or mine shoud anyway.

[/quote]



kickoff3pm,

Showing products from subcategories in main category could be a time-consuming operation. Moreover if we would try to sort all subcategories first and then union them. I won't go deep into details but in MySQL terms it would be 4 separate queries instead of one in your example. Imagine what would happen when there are several hundreds of subcategories.



This could be done as a modification in store with not many products.

I'm not sure about that, can it be acheived when add products to the store as follows. A simple change to the database that adds one numeral to the front of all products. That number being the category they are in.



A default product or category is always give the sort value 0.



Instead make the categories start 1 and the products start at 11



So shoes might be 1, trainers 2, slippers 3



Brown shoes would be 11, brown trainers 21, brown slippers 31



Red shoes might be 12, red trainers 22, red slippers 32



If I choose slippers to be higher then trainers later could just change the sort value as normal.