Double products id and references inside of Back-end ver. 1.4.7 after import

[kibiribi]

I've got ver.1.4.7.0

After import of CSV file I can see duplicate products in back-end.

There are no duplicate products on Frond-end.

I tried to search products by id or reference in whole SQL dump - no double result.

I can see such issue in categories - products page = /index.php?tab=AdminCatalog&id_category=81&viewcategory&toke

 

I can see 1 product id inside of products table

There are no double items in database.

 

2 languages - English, Russian (active)

no taxes

1 category assigned

no attributes

no combinations

 

What's wrong with Back-end? :-(

 

 

I know about new version 1.5

I can't migrate to new one.

 

Thanks for advice!

[cleoni]

I am having the same issue after importing items with a custom script.

 

Probably the duplicate is on a referenced table, but the presta core classes do not give a hint of what the query done is.

 

Any ideas?

[cleoni]

Found it.

Simply put, you have more images in the ps_images table associated to that product,and all of them have "cover=1". Just one should be cover=1 or you will see multiple instances of the same product in the list!