- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
www.iwebsolutions.co.uk | Magento Small Business Partner
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
www.iwebsolutions.co.uk | Magento Small Business Partner
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: List all Configurable products with no Associated products defined?
Cheers Andy - that's exactly what I needed!