I think core_url_rewrite is built in the wrong way:

  • why it contains records for not visible products ( all simple associated to the configurable for example )
  • why it contains records for every storeview even if the request_path (url_key/url_path) for a product/category is the same for every storesview ?

I actually have 394415 records on this table ( my store has 28120 products and 7 storeviews ), if I could solve the above 2 point I think the table would be 10 times smaller.

Anybody worked on this before ?

  • it is but that question points to another problem with url_rewite, the solutions proposed there has been already implemented on my store few months ago – Fra Mar 16 '17 at 9:52

Here are some solutions. You can follow that solutions https://magento.stackexchange.com/a/18690/49821



With this you can check what exactly problem is in your case.


  • unfortunately those solutions do not address the problems described in the question, thanks anyway for adding these links – Fra Mar 16 '17 at 10:34

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