Is there a box (or mod) to show most viewed products, related to the same category?
Is there a box (or mod) to show most viewed products, related to the same category?
Is there a box (or mod) to show most viewed products, related to the same category of product that I'm seeing?
CLOSEST to your request at
http://www.zen-cart.com/index.php?ma...roducts_id=720
it's a wonderful mod, but it show only last viewed item during browsing shop; instead i would mod that show most viewed item related to categories of item I'm seeing.
As stats_products_viewed in admin.
You can search in downloads/Free software addons...
link top of this page.. dont see one myself that meets your exact requirements so you can advertise in Commercial section
for zencart coder to create one..
I've just created a query like this:
but no products show in boxPHP Code:
$most_view_query = "select distinct p.products_id, p.products_image, pd.products_name, pd.products_viewed, p.products_price, 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_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 pd.products_viewed desc
limit " . MAX_DISPLAY_BESTSELLERS;
$most_view = $db->Execute($most_view_query);
Why? thanks for help
Bookmarks