Skip to content

Instantly share code, notes, and snippets.

@drewdhunter

drewdhunter/parentless-products.sql

Last active April 25, 2017 05:32
Show Gist options
  • Save drewdhunter/8752315 to your computer and use it in GitHub Desktop.
Save drewdhunter/8752315 to your computer and use it in GitHub Desktop.
Download ZIP
Magento - find parent-less simple products
Raw
parentless-products.sql
select
entity_id
FROM
catalog_product_entity
WHERE
type_id = 'simple'
AND(
entity_id NOT IN(
SELECT DISTINCT
(product_id)
FROM
`catalog_product_super_link`
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment