-
Notifications
You must be signed in to change notification settings - Fork 29
Home
Peter Jaap Blaakmeer edited this page Apr 2, 2019
·
1 revision
Run this query on your database;
SELECT sku, catalog_product_relation.*, COUNT(*) as cnt FROM catalog_product_relation INNER JOIN catalog_product_entity cpe on catalog_product_relation.child_id = cpe.entity_id GROUP BY parent_id HAVING cnt > 1000 ORDER BY cnt DESC
It will give you a list of the products and how many simples they have attached to them, if there are more than 1000. There's a server/project-specific limit at how many simple products Magento times out. In our cases, that was around 3000.
If this query gives you any results, you'll likely benefit from using this extension.