prestashop shows duplicate products in backoffice

[jacograaff]

After 1.6.0.12 -> 1.6.1.1 upgrade everything works - front end shows correct products BUT the backoffice page for products shows duplicate and tipple entries for some products.

 

When I delete one of the duplicate entries in the backoffice list view all is gone - 

 

the query might be returning multiple results for same entry..

 

As you can see in the attached image

 

the backoffice shows 40 product 

 

the database only shows 30 (same in front-end)

 

[NemoPS]

Did you use multishop? I'd check product_shop as well in terms of db tables

[jacograaff]

Solved... it had to do with an extension/module I purchased

 

I guessed it could be something to do with this module

 

The developer was again very quick to answer and I am impressed by his support

 

Virtual Product Combinations with Associated File

 

http://addons.prestashop.com/en/administration-tools-prestashop-modules/18561-virtual-products-with-combinations.html

 

New changes had to be made to a file

 

-----------------------------------------------------------------------

 

open your controllers/admin/AdminProductsController.php file and find rows: 

 

$this->_use_found_rows = false; 

$this->_group = '';

 

And replace it on follow:

 

$this->_use_found_rows = true; 

$this->_group = 'GROUP BY '.$alias.'.id_product';

 

------------------------------------------------------------------------

 

--- my review on this module ---

First - The developers were extremely helpful and quick to assist in getting this working after I applied all the changes from the documentation and it did not work.

 

They even logged into my system and made changes themselves.

 

Backwards and forwards discussions followed as I temporarily allowed secure access to a limited set of files/folders as requested.

I was impressed.

 

An upgrade from v1.6.0.12 to v.1.6.1.1 caused duplicate entries to show in the backoffice - I guessed it could be something to do with this module

 

The developer was again very quick to answer (I purchased this 6 months ago)

 

The workflow to use this extension is not the best - but acceptable - e.g. you have to save the new combination -- which closes the combination form and then have to go back into the combination form before you see the dialogue that allows you to add a virtual product to the specific combinationrnrnBut for the price this is acceptable

 

Install was painful and took some time - the documentation did not have all the necessary changes

 

Also there are some changes on the core which will break on updates as happened going from v1.6.0.12 to v1.6.1.1

 

I again have to stress that the developer was very quick in replying with an answer that solved the issue

 

I am thus satisfied since the cost of the module and time I had to spend is far less then it would have taken me to develop it myself or source the development out

[Kogkalidis]

That patch with GROUP BY worked like a charm! Thank you for your helpful guideline

[Dawn]

Hi! same problem here but with PS 1.7...in that version this lines not exists.

Any solution? Thanks!