ProductCart Shopping Cart Software Forums : Sort by Popularity / Best Selling https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 05:13:36 +0000 Tue, 09 Nov 2010 22:28:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4130 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Sort by Popularity / Best Selling : Thanks Greg. Yes, that&#039;s...]]> https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16105.html#16105 Author: ProductCart
Subject: 4130
Posted: 09-November-2010 at 10:28pm

Thanks Greg. Yes, that's exactly the idea.]]> Tue, 09 Nov 2010 22:28:02 +0000 https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16105.html#16105 <![CDATA[Sort by Popularity / Best Selling : As a point of interest, we recently...]]> https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16104.html#16104 Author: Greg Dinger
Subject: 4130
Posted: 09-November-2010 at 10:16pm

As a point of interest, we recently altered a store so that the merchant can dictate the period of time for which best sellers may be calculated, and we use that to drive the "best sellers" feature on the home page and showBestSellers.asp.
 
To keep the sales data up to date, we built a stored procedure + a scheduled task that runs that procedure.  It runs daily.
 
]]> Tue, 09 Nov 2010 22:16:29 +0000 https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16104.html#16104 <![CDATA[Sort by Popularity / Best Selling : Yes, this is on our radar. The...]]> https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16103.html#16103 Author: ProductCart
Subject: 4130
Posted: 09-November-2010 at 10:00pm

Yes, this is on our radar. The reason why it's not there yet is that we don't want to calculate the "popularity" on the fly, for obvious performance reasons, and, on the other side, ProductCart does not currently store a history of sales for specific time frames.

The issue is the following: "popularity" typically means "sales", but it clearly does not make sense to show as #1 a product that sold like crazy 2 years ago and that is now close to being discontinued.

That is: "popularity" really means "recent sales", in most cases.

So, what we are thinking is that:
  1. The merchant should indicate what "popular" means (e.g. best selling over the last N months, where N is a variable that they can enter)
  2. ProductCart will regularly calculate those figures (e.g. on a weekly basis or so)
  3. The storefront will allow to "Sort by Popularity" based on that sales information
Do you agree with this approach?
]]> Tue, 09 Nov 2010 22:00:40 +0000 https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16103.html#16103 <![CDATA[Sort by Popularity / Best Selling : ProductCart now has sort by high...]]> https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16098.html#16098 Author: whizzinpc
Subject: 4130
Posted: 09-November-2010 at 1:22pm

ProductCart now has sort by high price, low price, sku and description. I think it would be useful for a customer to sort by popularity or best selling.]]> Tue, 09 Nov 2010 13:22:28 +0000 https://forum.productcart.com/sort-by-popularity-best-selling_topic4130_post16098.html#16098