Best Sellers

[Parklife]

Trying to change the best sellers lists, in other words I want to change the length of time the best sellers are accumullated over as we have had some products for years that consistently sit at the top of the best sellers list where others that are more recent and selling well never get to the top.

Have seen this https://www.interspire.com/forum/showthread.php?t=13500 but, a, didn't know if that would do the trick and, b, where to to find the code

Any help would be much appreciated.

Regards,

Darron

[jonsam]

good idea

[jonsam]

also better if you could arrange by £ of sales instead of number of unit sold

[CharlieFoxtrot]

Modify the query statement so that it only selects items that have sold within the past 30 days.

[danielleslot]

Modify the query statement so that it only selects items that have sold within the past 30 days.

You could also consider a "daily" list with best sellers :O