PrestaShop product page visits counter

In this tutorial i want to show you how to create visits counter on each product page in your store based on PrestaShop engine. To achieve it we have to modify two things, FrontController and your theme template file. This feature uses default prestashop stats engine, so it mean, that it's necessary to turn on datamining module and enable all features for this addon (default module in your prestashop, you can turn on its features on module configuration page).


product page views count tutorial


Front Controller modification

As i said before it's necessary to modify the FrontController.php file. You can find it in this directory: classes/controllers/ Open this file and before last closing bracket paste this code:

public static function getTotalViewed($id_product){ 
  $view1 = Db::getInstance()->getRow('SELECT pv.counter AS total FROM '._DB_PREFIX_.'page_viewed pv 
  LEFT JOIN '._DB_PREFIX_.'page p ON pv.id_page = p.id_page 
  LEFT JOIN '._DB_PREFIX_.'page_type pt ON p.id_page_type = pt.id_page_type 
  WHERE = \'product\' AND p.`id_object` = '.intval($id_product).''); 
  return isset($view1['total']) ? $view1['total'] : 0; 

Main function of this code is possibility to get information about visits from datamining module database. This function returns number of visits for product, query is based on product id number.


Theme template file modification

Now we have to modify theme template file. In this case please open product.tpl file located in your theme directory. For default prestashop template path to file looks like: themes/default-bootstrap/product.tpl . All what we have to do now is just little code paste, to display product page views counter use just this code:


You can use it anywhere you want in product.tpl file. You can also stylize it with css styles like other elements. Voila ;)

author milos myszczuk
Article by Milosz Myszczuk PrestaShop expert, official PrestaShop community moderator. PHP developer, specialist in relative and spatial databases management, GIS Analyst, CEO & founder of VEKIA interactive agency. Read more about VEKIA company
If you like my articles and want much more valuable tips, feel free to send me donation
1.4 version 1.4.11 1.6 404 addon admin advertise ahref ajax alpha animation api app application authentication back office backup badge banner basics block bootstrap button cache carrier cart catalog category certificate changelog chat class clear client clip cms code colors columns comments configuration contact container content controller cookie counter country coupon css csv currency customer dashboard database debug default delete delivery desktop developer device disable discount displayNav displayTop download dynamic editor effect empty encrypt engine error exchange exclude export facebook faceshop fade fancoupon fancybox fanpage fatal feature feed field file fix fixed font footer free friendly url front ftp full gallery generate gift global godaddy google google+ gray grid groupon header help hide highlight homefeatured homepage hook hosting hover howto htaccess html html5 ID image import include input instagram installation integration iPhone issue javascript jquery kgb knowhow languages law left likebox link list livingsocial loading log login logo loyality mail mailing maintenance manufacturer marketing marquee mcrypt menu meta mobile modification module movie moving multilanguage multiupload must have mysql news newsletter notification number open graph order override page password performance PHP phpmyadmin picture pinterest plugin popup post prestashop prestashop 1.0 prestashop 1.1 prestashop 1.2 prestashop 1.3 prestashop 1.4 prestashop 1.5 price rules problem product profile promotion proslider purifier quantity query quick tip random rates register reinsurance release reporting reset responsive restore results ribbon rich text right sales search security seo service shadow share shipping shop shopmania slider smarty social networks SQL SSL statistics stock store style subcategory superuser support switcher tab tablet tag tax template text theme tinyMCE tips and tricks tpl tracking translations tree trends trigger tumblr tutorial twitter update upgrade upload variables video visits voucher vulnerability web2print wide widget width window wishlist wysiwyg youtube zip zopim