Skip to content

Instantly share code, notes, and snippets.

@tschifftner

tschifftner/query.sql

Last active March 16, 2018 08:42
Show Gist options
  • Save tschifftner/465b668f4c6a134bb083fccc0cd69383 to your computer and use it in GitHub Desktop.
Save tschifftner/465b668f4c6a134bb083fccc0cd69383 to your computer and use it in GitHub Desktop.
Download ZIP
Get all products not assigned to a category (Magento)
Raw
query.sql
SELECT cpe.entity_id, cpe.sku
FROM catalog_product_entity as cpe
LEFT JOIN catalog_category_product as ccp on cpe.entity_id = ccp.product_id
WHERE category_id IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment