List all Configurable products with no Associated products defined?

[batting46]

After dong a bit of a clear out of obselete products I want to check that there are no old configurable products in the database that don't have any associated products applied to them.

Is there a way of doing this?

Thank you

[iweb_smartie · Accepted solution]

If you have access to the database you can run the following;

SELECT
entity_id
FROM catalog_product_entity
LEFT JOIN catalog_product_super_link
ON entity_id = parent_id
WHERE type_id = 'configurable' AND parent_id IS NULL

It will return entity ids of configurable products that do not have an associated product. If the list is empty you are all good

Regards,

Andy

[batting46]

Cheers Andy - that's exactly what I needed!