Product View Count

[stampsville]

Hi all,
In the admin side I can see the list of item views count.
Is there a way to display that in the product_info page?
This product has been viewed...

Thanks
Grant

[perfumbg]

Hi all,
In the admin side I can see the list of item views count.
Is there a way to display that in the product_info page?
This product has been viewed...

Thanks
Grant

Yes i want that too.

I onlle managed to show the most viewed product count number, not the exact views of every separate product.

What have i done:

In /includes/modules/pages/product_info/main_template_vars.php right before

$products_model = $product_info->fields['products_model'];
  // if no common markup tags in description, add line breaks for readability:
  $products_description = (!preg_match('/(<br|<p|<div|<dd|<li|<span)/i', $product_info->fields['products_description']) ? nl2br($product_info->fields['products_description']) : $product_info->fields['products_description']); 

i put that:

$products_query_raw = "select p.products_id, pd.products_name, pd.products_viewed, l.name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_LANGUAGES . " l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC";
    $products = $db->Execute($products_query_raw); 

and somewhere in product info page exactly were i wanted to apear in my case under product image

<?php echo $products->fields['products_viewed']; ?>

But that gives me only the most watched product count.

Can someone help ?

[perfumbg]

Problem solved :)

I was so dum to copy-paste everything and forgot to revise the DB "order by pd.products_viewed DESC"

you just need to delete that line from main_template_vars.php and everythig comes to its places.

Many regards

[davewest]

Problem solved :)

I was so dum to copy-paste everything and forgot to revise the DB "order by pd.products_viewed DESC"

you just need to delete that line from main_template_vars.php and everythig comes to its places.

Many regards

This is what I use to display number of viewed at the base of my auction products... for you, in tpl_products_info_display.php if it's not in your template folder, move it over then make the edit where you wish it to be displayed... add

<?php echo ( zen_products_lookup((int)$_GET['products_id'], 'products_viewed') > 0 ? '<div class="reviewCount">' . 'Product Viewed: ' . zen_products_lookup((int)$_GET['products_id'], 'products_viewed') . '</div>' : '') . "\n"; ?>

This a quick if statement, if the product been viewd before, display 'Product Viewed: #' if not, don't display anything... or you could say something else... I didn't use a languge file here so you could do that by changing 'Product Viewed: ' and defining it in your languge file.