custom bestseller module

i am looking for best seller module but with price and date filters.

for ex. Bestsellers below $ 50, bestseller between $ 50 - 100 in last week

because the cheaper products like $5 0r $8 always on top of bestseller list.

This can be easily done by changing default bestseller module;

In OC2.2 (you forgot to specify version used) sql for bestseller look like this: For ex: to get products from last 10 days orders (products with price over 50) you should modify sql to Of course you have to clear cache;

Pro developer will add this as options in extension admin area

Good luck and many many sales!

Reason for adding as images: WHEN SQL commands are added inside message opencart security system think I try to hack website using sql injection and block message;

hi,

thank you for your quick replay, sorry i missed to mention version, it is oc 2.1.0.2

i got logic and tried sql query solution and i got expected results, thank you for your help it works gr8.

but i was more looking for an extension where i can set set this range in back-end and display multiple bestseller modules with different price range on same page. in sql modification its quite difficult.

if anybody developed any extension work like this please mention, its very useful to market higher price range Products.

thnx oc-extension team for helping out.