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?
Solved! Go to Solution.
If you have access to the database you can run the following;
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