Error on front office and back with product listings

[defensetechga]

Heres my issue, my products have duplicated themselves multiple times.

 

example: product id 1 is appearing multiple times in FO and BO.

 

I ran a check in SQl using the following command:

 

 

 

SELECT COUNT(*) as repetitions, id_product, reference

FROM ps_product

GROUP BY id_product, reference

HAVING repetitions > 1;

 

*****No duplicates found*****

 

I did a manual check in the ps_products table

*****no duplicates found*****

 

 

Cleared Browser cache

*****problem still there*****

 

Can someone please let me know what the hell I am missing here.....

I do not want to continue adding any more product until I resolve this!

[defensetechga]

Somebody must know what causes this to happen, Please help!!!!!

[in53ktin]

Jejeje, I had that problem the last week, my solution was...upload a new .csv of categories and products, I think the reason it's a bad insert of categories with .csv, maybe when you clic on a product of your list on FO, sends you a non available product; try with that solution, you need to clear all categories and products and after all upload the new .csv. First of all....make a backup of your shop and your DB, if you could, try it on a non production shop. Sorry for my english =P.

[defensetechga]

Somebody must know what exactly causes this. I am beginning to wish I stuck with xcart!!!

 

I did a transfer from a localhost build to server database and its showing every product 4 times. Someone help me I am ripping my hair out!