I had the same problem. The bug seems to be in the cache logic as mentioned on the last post.
A workaround is to sort the variants list after retrieval. For example, add this in ProductVariantsInGrid.ascx.cs:
productVariants.Sort(delegate(ProductVariant p1, ProductVariant p2) { return p1.DisplayOrder.CompareTo(p2.DisplayOrder); });
Product Variant Sorting
- 7
- 35
- 9/22/2009
- United States
hunaid wrote:
I was having a similar issue with products not being sorted properly in the front end. I edited the Nop_ProductLoadAllPaged stored procedure and changed dbo.NOP_getnotnullnotempty(p1.[Name],p.[Name]) END ASC to the following: dbo.NOP_getnotnullnotempty(pv.[DisplayOrder],p.[Name]) END ASC. This will sort your products by product variant display order when "sort by position" is selected in the front end and will default to sorting by product name if a variant does not exist. You might also want to set Cache.ProductManager.CacheEnabled = false.
Thanks you for your help in this regard.
I have different products with same variant name like
Product 1
Variant -- > Green
Variant -- > Blue
Product 2
Variant -- > Green
Variant -- > Blue
Any Suggestions ? Cache Key checked and created can cause issue with this ?
Hunaid
I have different products with same variant name like
Product 1
Variant -- > Green
Variant -- > Blue
Product 2
Variant -- > Green
Variant -- > Blue
Any Suggestions ? Cache Key checked and created can cause issue with this ?
Hunaid
I was having a similar issue with products not being sorted properly in the front end. I edited the Nop_ProductLoadAllPaged stored procedure and changed dbo.NOP_getnotnullnotempty(p1.[Name],p.[Name]) END ASC to the following: dbo.NOP_getnotnullnotempty(pv.[DisplayOrder],p.[Name]) END ASC. This will sort your products by product variant display order when "sort by position" is selected in the front end and will default to sorting by product name if a variant does not exist. You might also want to set Cache.ProductManager.CacheEnabled = false.
- 2
- 10
- 6/21/2010
- United Kingdom
jsr wrote:
I had the same problem with version 1.8
This line of code have solved the problem. cheers ;)
I had the same problem. The bug seems to be in the cache logic as mentioned on the last post.
A workaround is to sort the variants list after retrieval. For example, add this in ProductVariantsInGrid.ascx.cs:
productVariants.Sort(delegate(ProductVariant p1, ProductVariant p2) { return p1.DisplayOrder.CompareTo(p2.DisplayOrder); });
A workaround is to sort the variants list after retrieval. For example, add this in ProductVariantsInGrid.ascx.cs:
productVariants.Sort(delegate(ProductVariant p1, ProductVariant p2) { return p1.DisplayOrder.CompareTo(p2.DisplayOrder); });
I had the same problem with version 1.8
This line of code have solved the problem. cheers ;)