Eat, sleep, code, repeat
by Geoff Jackson · Published · Updated
You may wish to delete all URL rewrites from URL Rewrite Management in Magento at some point, especially if you are frequently importing/exporting product and category data.
Simply run the below SQL query and all rewrites will be wiped.
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `core_url_rewrite`; SET FOREIGN_KEY_CHECKS = 1;
Tags: magentomagento url rewritesmysqlmysql truncate
Geoff Jackson
Geoff Jackson (more commonly known by his online pseudonym zigojacko) is the founder of Design Haven and The Clubnet Group which hosts numerous agencies including the most widely recognised of them, Clubnet Digital, a full service digital marketing and creative design/development agency. He also has a personal blog but it doesn't get updated as much as he'd like.
by Geoff Jackson · Published May 1, 2015 · Last modified May 5, 2015
by Lucy Barret · Published June 22, 2016
by Geoff Jackson · Published May 15, 2015
