Is there a way to see a list of products that have no categories assigned?
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.
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;
Thank you, this worked perfectly and helped me get my catalog cleaned up!