Gold R10 Category Sort Time out

[rpb3]

Category Sort not working on large store.

We have a large store and are not able sort and save categories with many subcategories/products. Works on small categories just fine. On large categories we get the AJAX spinning wheel then comes back to the sort page and new sort is not saved.

The following error is logged on the server...

Exception information:
Exception type: HttpException
Exception message: Request timed out.

Request information:
Request URL: https://www.MyStore.com:443/Admin/Catal ... goryId=477
Request path: /Admin/Catalog/SortCategory.aspx

There is a section of code in the SortCategory.aspx page that is new to us as we recently upgraded to Gold from 7.0.7. If I comment this out then the sort works.

Code: Select all

                    // recalculate orderby for child products
                    foreach (CatalogNode cn in _CatalogNodes)
                    {
                        if (cn.CatalogNodeType == CatalogNodeType.Product)
                        {
                            Product tempProduct = cn.ChildObject as Product;
                            if (tempProduct != null)
                            {
                                tempProduct.RecalculateOrderBy();
                                tempProduct.Save();
                            }
                        }
                    }

Any ideas? What will commenting out that section do to our store catalog?

Thanks

[mazhar]

This part tries to calculate child products sort order within category being sorted. If you comment it out then it may result in some incorrect order for child products.

[rpb3]

Any idea what to do? For now I have that commented out because we can't work with it in there.

I don't know what sorting items in one category has to do with the order in the sub categories so I have no idea how to fix that problem.

The page needs to wait for the loop to finish.