cancel
Showing results for 
Search instead for 
Did you mean: 

List all Configurable products with no Associated products defined?

SOLVED

List all Configurable products with no Associated products defined?

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: List all Configurable products with no Associated products defined?

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 Smiley Happy

 

Regards,

Andy

Problem solved? Click Accept as Solution!
www.iwebsolutions.co.uk | Magento Small Business Partner

View solution in original post

2 REPLIES 2

Re: List all Configurable products with no Associated products defined?

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 Smiley Happy

 

Regards,

Andy

Problem solved? Click Accept as Solution!
www.iwebsolutions.co.uk | Magento Small Business Partner

Re: List all Configurable products with no Associated products defined?

Cheers Andy - that's exactly what I needed!