Community Add-Ons

Add file to this package
Top » InfoBoxes

Scrolling bestsellers with images
for osCommerce Online Merchant v2.2

Simple to use scrolling best sellers box with product images.

Legend:  Download   Report
Expand All / Collapse All
hide products that cost $0.00 ggbig 9 May 2008  

I had a need to hide my FREE products from the infobox, thus only displaying the bestsellers that actually cost more than 0. Here is the query with the needed changes to hide free stuff if anyone needs it :)

if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_price > 0 and p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$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);
} else {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_price > 0 and p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
}

all i added was a check for products price above 0 like this "where p.products_price > 0 and "

njoy!

Little addition - changes wauziweb 29 Dec 2006  
Scrolling Best Sellers with Images V1.2 Lao 13 Oct 2006  
Scrolling Best Sellers with Images V1.1 DRIVE 8 Apr 2006  
Scrolling Best Seller with image clickable Roy Laniado 1 Mar 2005  
Scrolling bestsellers with images Justin Rains 31 Jan 2005