| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
periodic bestseller (weekly/monthly/annually) | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
periodic bestseller (weekly/monthly/annually)
warning: this was not tested on a live server, so please backup your xcart sql database just in case...its actually my first time playing with mysql functions but i have a programming background so was able to catch on
note: this will reset your products' sales stats and obviously you must have both the Advanced Statistics and the Bestsellers modules enabled, also products are not considered 'sold' until the order is 'processed' in modules/Advanced_Statistics/prod_sold.php, look for Code:
Code:
now in the xcart admin section, goto patch/upgrade...in the "SQL query(ies)" textbox, paste one by one each line (or together, i dont know if it will work though) Code:
also, you may want to update the bestseller label (lbl_bestsellers) to reflect the period that should be it...it should work for 4.0.x and 4.1.x |
|||||||
#2
|
|||||||
|
|||||||
Re: periodic bestseller (weekly/monthly/annually)
Will this work on 3.5.x?
__________________
X-Cart Version 4.3.x |
|||||||
#3
|
|||||||
|
|||||||
Re: periodic bestseller (weekly/monthly/annually)
anyone that can get this working on 3.5.x?
__________________
X-Cart Version 4.3.x |
|||||||
|
|||
X-Cart forums © 2001-2020
|