Magento Delete All ‘Url Rewrite Management’ URLs in the Database

Written by Sid Vel

Topics: Magento

To delete all the URL rewrites from the Magento admin backend, you can do the following:

  1. Using your favourite database browser, connect to your Magento database
  2. Go to the table named ‘core_url_rewrite’
  3. Empty this table
  4. Log back in to the Magento backend and reindex all

This action will clear out all manually and system created rewrites and recreate only the needed ones (e.g. current products and categories)

2 Comments Comments For This Post I'd Love to Hear Yours!

  1. ME says:

    TO USE WITH EXTRA CAUTION!! I thought this would remove the Catalog Url Rewrites but it’s really removing all rewrites. Have a 404 error on all pages now. Anyway, thanks. Luckily i’m on localhost.

  2. Giel Berkers says:

    Thanks! This really should be a button somewhere in Magento. ‘Clear and reindex all rewrites’.

Leave a Comment Here's Your Chance to Be Heard!