Hi,

I have mixed products on my store that are both free and those with price. If I activate the bestseller sidebox, it will show mostly free as the bestsellers so I was wondering how I can change the code around to just say something like check that the product price is greater than zero then display the bestseller.

I found the file under modules\sideboxes\bestseller.php

Line 32 onwards:
if ($show_best_sellers == true) {
if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
where p.products_status = '1'
and p.products_ordered > 0
and p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id)
order by p.products_ordered desc, pd.products_name
limit " . MAX_DISPLAY_BESTSELLERS;


Is the correct code to add:
and p.products_price > 0

which I insert under the and p.products_ordered > 0

Thanks for your help in advance