As per the title, can someone kindly tell me what query to use to delete all url rewrites in the core_url_rewrites table with store ID of '1'? The current store ID is 5 and i need those to stay.

Also if its possible to delete everything in the database from that store? Im getting pages on admin throw a "404 error: Page not found" which i strongly believe is something to do with the store issue.

1 Answer 1


magento save store id core_url_rewrite table.

So just run the below query:

DELETE FROM `core_url_rewrite` WHERE `store_id`=1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.