Reset Bestsellers List
 

Hi,

I was trying to locate on the backend (and then through searching the forum) for a way to reset 'bestsellers' so everything starts at zero again as our bestsellers doesn't reflect current sales anymore.

Re: Reset Bestsellers List
 

Same here! Anyone?

Re: Reset Bestsellers List
 

raised!

Re: Reset Bestsellers List
 

maybe it can't be done!

Re: Reset Bestsellers List
 

its doable, i believe it just requires that you reset your products' sales stats in your sql database (backup your database before attempting, just in case)

Re: Reset Bestsellers List
 

I am coming up with a solution for this which I am testing out at the moment

instead of resetting the bestsellers manually, it is a weekly bestsellers (which can be changed to monthly very easily)...it makes use of the advanced statistics module, php's date function, and a new table (2 cells) to keep track of when it was last updated

Re: Reset Bestsellers List
 

that's fantastic, as it would reflect what is 'hot' more than what statistically has been best over a period of years.

Re: Reset Bestsellers List
 

check http://forum.x-cart.com/showthread.php?p=154185#post154185 for the mod

Re: Reset Bestsellers List
 

Thanks

Tried line by line, on the 2nd line you get an error, tried altogether got

PATCH RESULTS

SQL PATCH FAILED AT QUERY:
CREATE TABLE `xcart_lastupdate` (`period` INT( 2 ) NOT NULL ,`year` INT( 4 ) NOT NULL) UPDATE xcart_lastupdate SET week=51 UPDATE xcart_lastupdate SET year=2006

PATCH LOG