Display in product page how many times item have been viewed

[tashkas 2]

Can somebody tell me how to make display in product page how many times item have been viewed by customers, there is module best products but it just for backend, I want it in main page.

[tashkas 2]

nobody knows?

[happykidsmart 0]

I want to see this feature as well ...

 

many thanks.

[vekia 8,952]

take a look here: http://www.prestashop.com/forums/topic/251539-solvedhow-to-get-product-view-count-in-prestashop/

[tashkas 2]

there is no solution in that link that you gave me Vekia, can somebody please share a solution how to do that?

[vekia 8,952]

in Product.php class add function
 

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

then in product.tpl file you can use:

{Product::getTotalViewed1(Tools::getValue('id_product'))}