product sort order in categories pages is not functional

Hello-

I posted on another topic, but then I tried the LIVE nopCommerce demo site, and it seems to be a genuine bug.

I'm running nopCommerce 3.40 and I'm using the nop-templates.com Alfresco theme, but it happens on the 3.70 demo site too.

On my site, as described here( https://www.nopcommerce.com/boards/t/31951/display-order-of-products.aspx#170119 ), I changed the display order of each product in a particular category, but the changes are never reflected on my public pages. I tried restarting the application and have searched everywhere for any setting that might prevent my changes from being displayed, but found nothing.

The sorting function works...allowing customers to order by price low to high, or price high to low, or by name or created date, etc..but the default "Position" option always shows the products in the same order...regardless of what I change the products order to...

I logged in as admin on the demo site and changed the product sort order for the products in the Electronics >> Camera & Photo category, but on the demo public page, the default "position" sort order does not reflect the change:
http://demo.nopcommerce.com/camera-photo?orderby=0 or http://demo.nopcommerce.com/camera-photo


Thanks,
Steve

fyi -  the admin demo site is not linked to the demo public page

New York wrote:
oh, okay..thanks. I thought maybe there actually was a reason for this weirdness...

I just tried adjusting another of my client's category product sort order,(v. 3.70 with Default Clean theme) and it worked as expected..so this problem is either specific to version 3.40 ...or maybe a problem with the CategoryTemplate.ProductsInGridOrLines.cshtml view in my custom theme??

Any ideas what else might cause this behavior?

Thanks,
Steve

After further examination, I've discovered that the problem only exists for top-level categories.

So, I can affect change in the product sort order of any subcategory without any problems, but the parent/top level category product sort order does not change after being modified...

I verified that it is, indeed, also a problem with version 3.70 and default clean theme...

It is impossible to affect the product sort order for top-level categories.

Here's proof of the problem:
this site is version 3.70 with default clean theme-

This is how I have the sort order for the top-level category configured:


This is what the page looks like:
http://www.fortworthgrass.com/decorative-stone

Can reproduce this issue on the clean installation of nopCommerce with default theme?

I have no new installation to test with, but the example I posted in the above post is 3.70 with default clean theme...no major customizations, and very few plugins.

It works fine out of the box. We cannot reproduce it. Please share your solution with database backup so we can reproduce it locally

embryo wrote:
Are the products specifically mapped to both the top level category and the relevant subcategory?
On the catalog settings page in admin is the Include products from subcategories setting ticked?

Have a look at Products tab in the admin for the Computers category on the nop demo site: http://admin-demo.nopcommerce.com/Admin/Category/Edit/1

The tab shows no products since they're not mapped to this category. The Computers category on the front end displays all the products because they exist in subcategories of the computers category and the setting mentioned above is switched on: http://demo.nopcommerce.com/computers

My guess is that you've got the products mapped to both the top level and subcategories with this setting switched on and it's causing some sort of conflict with which sort order it uses (possibly the display order from the subcategory mappings is overriding the top level display order).