Is it possible to list all configurable products either on page or in SQL most likely to display any configurable products that have NO associated simple products on them.

For example - I have ~ 1,000 configurable products and to ensure none have been missed out having simple products assigned to them I want to be able to check without going through each one.

Also - the other way round is it possible to list simple products that have not been added to any configurable products at all?

2 Answers 2


You can use below mysql query to get all the configurable products which are not associated with any simple products.

SELECT entity_id FROM `catalog_product_entity`
WHERE `type_id` = 'configurable' AND entity_id NOT IN(
    SELECT DISTINCT parent_id FROM catalog_product_super_link

to view info about configurable product's associated simple products this should give you some guidance.


Also you can check this more recent article : http://magentocommerceblog.blogspot.com/2012/08/how-to-get-all-associated-products-to.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.