Most viewed Products
Posted: Mon Jan 09, 2012 4:40 pm
Is there a plugin or a way to display the most viewed products of the website somewhere on a page ? Kind of like featured products but the top 5 or so with the most page views overall.
Code: Select all
DbCommand selectCommand = database.GetSqlStringCommand("SELECT DISTINCT TOP "+MaxItems.ToString()+" OI.ProductId FROM ac_OrderItems AS OI WHERE OI.OrderId IN ( SELECT OrderId FROM ac_OrderItems WHERE ProductId = @ProductId ) AND OI.ProductId <> @ProductId1 ORDER BY OI.ProductID DESC");
//database.AddInParameter(selectCommand, "@MaxItems", System.Data.DbType.Int32, MaxItems);
database.AddInParameter(selectCommand, "@ProductId", System.Data.DbType.Int32,productId);
database.AddInParameter(selectCommand, "@ProductId1", System.Data.DbType.Int32, productId);Code: Select all
DbCommand selectCommand = database.GetSqlStringCommand("select top "+MaxItems.ToString()+" p.ProductId from ac_Products p join ac_PageViews pv on p.ProductId = pv.CatalogNodeId where pv.CatalogNodeTypeId = 1 and p.VisibilityId = 0 group by p.productid order by COUNT(*) desc");