How to trace product clicks ?

[upgrade4u]

I would like to trace which product clicks most.
Is any module or bundled module work with ?

Thanks !!!

[rocky]

Go to Stats > Best products (in the Navigation column), then click the "Page v.i." column to sort by the number of times the product has been viewed.

[upgrade4u]

thanks for your reply,
but i can't find any product in this page...
it any setting i missed in this module ?

[rocky]

The problem is that it doesn't display products that haven't been bought yet. You'd have to modify modules/statsbestproducts/statsbestproducts.php and delete the following lines from the queries to display all products:

WHERE p.active = 1 AND o.valid = 1
AND o.invoice_date BETWEEN '.$dateBetween.'

[upgrade4u]

i found 2 similar code in this files
should i delete both ?>

[upgrade4u]

public function getTotalCount($dateBetween)
{
$result = Db::getInstance()->GetRow('
SELECT COUNT(DISTINCT p.`id_product`) totalCount
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN '._DB_PREFIX_.'order_detail od ON od.product_id = p.id_product
LEFT JOIN '._DB_PREFIX_.'orders o ON od.id_order = o.id_order
WHERE p.active = 1 AND o.valid = 1
AND o.invoice_date BETWEEN '.$dateBetween);
return $result['totalCount'];
}


AND


FROM '._DB_PREFIX_.'product p
LEFT JOIN '._DB_PREFIX_.'product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = '.intval($this->getLang()).')
LEFT JOIN '._DB_PREFIX_.'order_detail od ON od.product_id = p.id_product
LEFT JOIN '._DB_PREFIX_.'orders o ON od.id_order = o.id_order
LEFT JOIN '._DB_PREFIX_.'currency c ON o.id_currency = c.id_currency
WHERE p.active = 1 AND o.valid = 1
AND o.invoice_date BETWEEN '.$dateBetween.'
GROUP BY od.product_id';

[rocky]

Yes, change the first one from:

WHERE p.active = 1 AND o.valid = 1
AND o.invoice_date BETWEEN '.$dateBetween);

to:

WHERE p.active = 1');

and the second one from:

WHERE p.active = 1 AND o.valid = 1
AND o.invoice_date BETWEEN '.$dateBetween.'

to:

WHERE p.active = 1

[upgrade4u]

i am so happy recieved ur reply,
but according ur code, i found all page under stats become blank page.
would u mind telling me more about this ?

[rocky]

For some reason, the forums are deleting some apostrophes in my code. I've attach the modified file.

statsbestproducts.php

[upgrade4u]

Many Many Thanks !!

AFter i replaced with ur file.
The stats page recover, but still display a blank page in all BEST modules.....

Best product, best categories, best supplier, best promotion.......

cry...cry.......

what i go wrong ?

[rocky]

Replacing that file should not affect the "Best categories", "Best supplier" or "Best promotion" modules. It should only affect the "Best products" module. It's working on my test site. Now all products including ones with a quantity of 0 are displayed in the "Best products" module.

[rocky]

You should edit config/config.inc.php and temporarily change 'display_errors' from 'off' to 'on' so that you get an error message instead of a blank page. Post the error message here.

[upgrade4u]

is it the problem which i am using traditional chinese ?

[rocky]

It shouldn't matter. The "Best products" module is designed to use the currently selected language.

[upgrade4u]

Omm...........

I remember i never have any data in all BEST modules ....
is any problem during my configuration ?

[rocky]

I have no idea why you don't have any stats. It's not something I can solve without having a look at your Back Office and your database.

[upgrade4u]

would u mind tell me which table is hosting the best product data ?
then i can verify the existing information ?

[rocky]

It reads many tables including ps_product, ps_product_lang, ps_product_attribute, ps_page, ps_page_viewed, ps_date_range, ps_order_detail, ps_orders and ps_currency.

[upgrade4u]

i found the following table is empty .

_page_viewed



.....any suggestions ?

[rocky]

It looks like statistics aren't being recorded for some reason. Make sure that the "Data mining for statistics v1.0" module is installed on the Modules tab (in the Stats section).

[upgrade4u]

installed....

but the table of product_viewed have data inside...

Thanks u keep answering my question, Rocky.

[rocky]

Do you mean that you installed the module or that it was already installed? If it was already installed, I'm out of ideas for how to help you.

[upgrade4u]

i found category page view have data, but i can't access page view of each product.
anyone can help ?

[GS VISION]

I want to bring this info to the front office on products page to be like:
Product views: xxx times

Any suggestions?

[htech]

any solutions to this post ? dieing to get something like this going!

I want to bring this info to the front office on products page to be like:
Product views: xxx times

Any suggestions?