Delete all Magento products MySQL

You can quickly delete all Magento products using this collection of queries.
UPDATE: Added removal of reviews & ratings!

This works for me under


  1. Now now, there’s no need to get all frisky! Glad it helped someone though 🙂

  2. Works like a charm – worth noting if you used a table prefix when setting up Magento you need to append that suffix to the front of each table name; otherwise, it will return a “not found” error.

    Thanks for posting this – saved me a ton of time.

Leave a Reply