Skip to content

Instantly share code, notes, and snippets.

@tegansnyder

tegansnyder/truncate_url_rewrites.sql

Created October 6, 2014 18:01
Show Gist options
  • Save tegansnyder/5ddb5988ba50c98badc1 to your computer and use it in GitHub Desktop.
Save tegansnyder/5ddb5988ba50c98badc1 to your computer and use it in GitHub Desktop.
Download ZIP
Truncate URL Rewrites Magento
Raw
truncate_url_rewrites.sql
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `core_url_rewrite`;
TRUNCATE TABLE `enterprise_catalog_category_rewrite`;
TRUNCATE TABLE `enterprise_catalog_product_rewrite`;
TRUNCATE TABLE `enterprise_url_rewrite`;
TRUNCATE TABLE `enterprise_url_rewrite_category_cl`;
TRUNCATE TABLE `enterprise_url_rewrite_product_cl`;
TRUNCATE TABLE `enterprise_url_rewrite_redirect_cl`;
TRUNCATE TABLE `enterprise_url_rewrite_redirect_rewrite`;
TRUNCATE TABLE `enterprise_url_rewrite_redirect`;
SET FOREIGN_KEY_CHECKS = 1;
@tegansnyder
Copy link
Author

Run a reindex afterwards. Note this includes enterprise_url_rewrite_redirect - removing all custom redirects

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment