Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 VP-Cart 8.00 Issues
 Top Sellers - limited period		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jack208
VP-CART New User

Malaysia
116 Posts
Posted - February 14 2016 :  07:09:01  Show Profile  Reply with Quote
The Top Sellers logic as-is tracks sales for all period, yes? It works fine as-is. However we are thinking of changing Top Sellers to be on a rolling 90-day basis. Has anyone done this hack before?

serjtankian
VP-CART Super User

Armenia
378 Posts
Posted - February 16 2016 :  15:21:51  Show Profile  Visit serjtankian's Homepage  Reply with Quote
so you mean that the top seller calculation is within 90 days?






*serj*
Go to Top of Page

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - February 17 2016 :  05:03:57  Show Profile  Reply with Quote
I haven''t done this but you could add a WHERE orders.odate>date()-90 clause to the initial sql call in shoptopsellers.asp?

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

serjtankian
VP-CART Super User

Armenia
378 Posts
Posted - February 23 2016 :  18:48:40  Show Profile  Visit serjtankian's Homepage  Reply with Quote
hm.. that''s make sense, but need to try it first with my local installation






*serj*
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty