Is this Possible

[Guest cntgifts]

i would liek to change my popular produucts box to lsit my best sellers

is it possible and how would it be done

[goober999]

i would liek to change my popular produucts box to lsit my best sellers

is it possible and how would it be done

Yes, it's possible!

in includes/boxes/popularProducts.inc.php

find this line of code

$popularProds = $db->select("SELECT name, productId FROM ".$glob['dbprefix']."CubeCart_inventory ORDER BY popularity DESC",$config['noPopularBoxItems']);

And replace it with this line

$popularProds = $db->select("SELECT name, productId, sum(quantity) as sales FROM ".$glob['dbprefix']."CubeCart_order_inv GROUP BY productId ORDER BY sales DESC",$config['noPopularBoxItems']);

That's it

Good luck

Thanks

/Goober

[Guest cntgifts]

nice thanks alot