Suggestions - Sort by Popularity / Best Selling

Print Page | Close Window

Sort by Popularity / Best Selling

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Suggestions
Forum Description: ProductCart Suggestions
URL: https://forum.productcart.com/forum_posts.asp?TID=4130
Printed Date: 27-April-2024 at 6:25am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Sort by Popularity / Best Selling

Posted By: whizzinpc
Subject: Sort by Popularity / Best Selling
Date 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.

Replies:

Posted By: ProductCart
Date 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:

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)
ProductCart will regularly calculate those figures (e.g. on a weekly basis or so)
The storefront will allow to "Sort by Popularity" based on that sales information

Do you agree with this approach?

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: ProductCart
Date Posted: 09-November-2010 at 10:28pm

Thanks Greg. Yes, that's exactly the idea.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software