Best Seller Page -Allow admin more control

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

I wish the "manage best sellers" page allowed the store admin to select whether it should display best sellers from last 30 days, last 6 months, the last year, or all time. 

We've been running productcart since 2005 and it's frustrating that the Bestseller page is filled with products that have sold only moderately well, but have been in our catalog since we opened- while the products that are actually best sellers don't even make the top 50 products because they were added only 2 or 3 years ago.

It would also be nice to be able to set a list of products to exclude from the  bestseller page. Some of the products on our best seller page are accessories or upgrades that are sold separately but would never be purchased alone, & on another of our websites, the top best sellers are all out of a tiny category of replacement hardware pieces and take up all the space on the bestsellers page  because a few people placed large quantity orders

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Lindsay Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-December-2008 Status: Offline Points: 17	Post Options Post Reply Quote Lindsay Report Post Thanks(0) Quote Reply Topic: Best Seller Page -Allow admin more control Posted: 01-February-2012 at 5:57pm
	I wish the "manage best sellers" page allowed the store admin to select whether it should display best sellers from last 30 days, last 6 months, the last year, or all time. We've been running productcart since 2005 and it's frustrating that the Bestseller page is filled with products that have sold only moderately well, but have been in our catalog since we opened- while the products that are actually best sellers don't even make the top 50 products because they were added only 2 or 3 years ago. It would also be nice to be able to set a list of products to exclude from the bestseller page. Some of the products on our best seller page are accessories or upgrades that are sold separately but would never be purchased alone, & on another of our websites, the top best sellers are all out of a tiny category of replacement hardware pieces and take up all the space on the bestsellers page because a few people placed large quantity orders

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 01-February-2012 at 6:28pm
	Hi Lindsay - I actually have a solution that you might consider. We built some code that provides for control panel management of the period for which sales apply to best sellers. There is a .sql file that we place on the server, and schedule via Windows Task Manager, which re-calculates the period-to-date sales every day. Then the best sellers listing has been altered to base its reporting on this re-calculated figure instead of the total sales of a product since it first sold in your store. Since we host sites, it was an easy choice to establish such a scheduled task. Whether this solution would work for you is largely dictated by whether (or not) your host will allow a scheduled task to be run. Does this sound at all like a solution that would work for you? Edited by Greg Dinger - 02-February-2012 at 12:01am