Is there a way to see a list of products that have no categories assigned?

[timlight10]

Is there a way to see a list of products that have no categories assigned?

[Basara]

Hello.
Please run this SQL script in phpMyAdmin or your preferred database tool. Be sure to replace the database prefix with your own before executing it.

Code Select Expand

SELECT
    p.product_id,
    p.model,
    p.status,
    pd.name
FROM `<DB_PREFIX>products` AS p
LEFT JOIN `<DB_PREFIX>product_descriptions` AS pd
    ON pd.product_id = p.product_id
    AND pd.language_id = 1
WHERE NOT EXISTS (
    SELECT 1
    FROM `<DB_PREFIX>products_to_categories` AS p2c
    WHERE p2c.product_id = p.product_id
)
ORDER BY p.product_id;