We are on Magento Version and have been using Magento for a few years now. When we moved our site to the live site from the development site, we deleted all the development products but looks like the URL's created in the development site in the URL re-write table did not get deleted and are in the live site's table.

Over a period of time, this table as you all know has grown and now as 1.5 million records in it.

In our live site, I see that the system generated product ID (under Catalog --> Manage Products) starts at 2800. I assume that 2800 products were added during development and testing.

Using the SQL query below - shows that there are 500,000 records SELECT * FROM core_url_rewrite WHERE product_id <> 'NULL' AND product_id < 2800 AND product_id > 0;

My question is, is it safe to go ahead and delete these 500,000 records from the URL re-write table as these URL's are of no use since there are no associated products related to the URL. Will there be any SEO impact or any other issues that you foresee?

At least it will solve part of the problem for us.

Your advice and suggestions would be very helpful.

1 Answer 1


It's very likely that you have so many entries because of this bug and it's totally unrelated to your Dev products.

Once you delete products and reindex there shouldn't be any entries for these items in the core_url_rewrite table.

  • Yes, but the database does show half a million records with product ID's that are non-existent (based on the SQL statement I mentioned above). So in this case, do you think it will be OK to just delete the half million records? Thx much
    – Raj
    Commented Nov 9, 2018 at 22:02
  • Truncating core_url_rewrite should not cause any problems as Magento will re-build once you re-index. The only issue may be if you have any custom re-writes as these will also be deleted.
    – hejhog
    Commented Nov 10, 2018 at 16:38

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.