How to read Products never viewed on Catalog Statistics

[bicdeveloper]

On the Page, Stats > Stats > Catalog Statistics

 

I can read the number of products never viewed, I would like to ask can I find out the list of products that have never viewed, which is similar case to bottom part for "PRODUCTS NEVER PURCHASED"?

 

To display the list, I can see which products are never viewed and edit it.

[vekia]

prestashop does not have a page where you can display such list of products, but it is possible to achieve this with available tools in ps.

 

1. go to advanced parameters > sql manager
2. create new sql query ("Add new sql query")
3. name it "not viewed products"
4. use this sql code:
   

   SELECT p.id_product, pl.name FROM ps_product p
     LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product
     WHERE p.id_product NOT IN (
   		SELECT page.id_object AS id_product FROM ps_page page
   		INNER JOIN ps_page_type paget ON page.id_page_type = paget.id_page_type
   		WHERE paget.name='product'
     ) AND pl.id_lang=1
   

the result will be the list of products that were not viewed

 

please note that this require "data mining" module installed and enabled.