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;

[timlight10]

Thank you, this worked perfectly and helped me get my catalog cleaned up!

[Jenny Arora]

Beautiful, intelligent women are waiting to meet those discerning gents like you. You truly deserve companions who match your vibe, plus that refined, sophisticated kind of energy. Hot Chhatarpur Escorts offer a great mix of good looks and quick mind, you know. Their engaging personalities make, every moment feel easy and enjoyable, almost like it was planned. Go ahead and see why they are becoming the preferred choice, locally.