How to only se products with combination back office?

[mpa1]

Hi,

We are currently in a bit of a pickle we are syncing our shop with a inventory system and we have run in to a minor issue, we accidentally added ean to some of the products with combination and that makes the integration leak out the EAN numbers to the combinations, that dont got a ean code.

So right now we are trying to find a way only to see products with combinations so we can fix these issues, but how the heck can we do that? it's hard to figure out what products got combinations in back office, some soul out there that can tell us a solution?

[shokinro]

I think you may have to use your database tool by running SQL statement on your store database to find out what products has combinations.

[shokinro]

You may try to use this SQL statement

 

SELECT count(*) as num, id_product FROM `ps_product_attribute` 

group by id_product

having num > 1

[DataKick]

You can use my free module to find out your data. You can also use inline editing, or mass update functionality, to fix the data. Check out this video