Try our conversational search powered by Generative AI!

Top Selling Products


Hi All,

Is there any example showing how to develop code to return Top Selling Products (Best Seller)?

So if user perform a search then we can sort it by best seller rank.

Dec 11, 2012 2:48

It´s kind of hacky, but there is an existing stored procedure that fetches entries from shipped orders.


            DataCommand dataCommand = OrderDataHelper.CreateTranDataCommand();
            DataParameters dataParameters = new DataParameters();
            DataSet dataSet = new DataSet();
            string query = "[dbo].[ecf_reporting_ProductBestSellers]";

            dataCommand.CommandText = query;
            dataCommand.CommandType = CommandType.StoredProcedure;
            dataParameters.Add(new DataParameter("ApplicationId", CatalogConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
            dataParameters.Add(new DataParameter("interval", "year", DataParameterType.VarChar));
            dataParameters.Add(new DataParameter("startdate", DateTime.Now.Date.AddDays(-100), DataParameterType.VarChar));
            dataParameters.Add(new DataParameter("enddate", DateTime.Now.Date, DataParameterType.VarChar));
            dataCommand.Parameters = dataParameters;
            dataCommand.DataSet = dataSet;

            DataResult dr = DataService.LoadDataSet(dataCommand);
            int[] po = new int[dataSet.Tables[0].Rows.Count];
            foreach (DataRow row in dr.DataSet.Tables[0].Rows)
                int x = (int)Math.Round(decimal.Parse(row["Ordered"].ToString()));
                if (x != 0)

Jan 04, 2013 14:36
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.