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?


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
| improve this answer | |

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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