This Magento1 website has 5 different URL's for each product that are indexing in Google. Examples below:

  • www.url.com/category1/product-name.html
  • www.url.com/brands/product-name.html
  • www.url.com/product-name.html


Thought process for best way to resolve is truncate the core_url_rewrite table

Then re-index URL's and allow the table to rebuild from scratch?

How then to ensure that the category's, search pages and brand pages all link to the same product URL?

The chosen ideal structure that the canonical will be on is below:


The site has 1 store, and circa 2000 products, and around 300 categories, and 40 brands.

Really looking to create best practice, and order of events to work through to resolve issue. With the last ones being re-generate sitemap, submit new sitemap to Google Webmaster tools.

  • If you don't mind me asking. Why do you have 2k products in 3k categories? Wouldn't layered navigation be easier?That said. You can turn off the categories showing in the URL from System->Configuration ->Catalog[Catalog]->SEO-> Use Categories Path for Product URLs. Have you tried that? Oct 4, 2017 at 7:41
  • 2000 products and 300 categories, not 3k categories
    – MagentoMac
    Oct 4, 2017 at 15:31
  • We have the correct settings now in place, the question really is correct procedure for cleaning up the url_rewrite table and rebuilding sitemap etc from there.
    – MagentoMac
    Oct 4, 2017 at 15:32

1 Answer 1

  1. Change

    System->Configuration ->Catalog[Catalog]->SEO-> Use Categories Path for Product URLs

    to 'No'

  2. Truncate the table 'core_url_rewrites'

  3. Rebuild Indexes

  4. Clear the Cache

  • Thanks. That's what I was planning to do, with some other steps in the midst of that like take a backup of the core_url_rewrite table. My worry is with the volume of products that the reindex of URL's may time out and not complete, but I guess server settings can be changed to allow a longer time limit.
    – MagentoMac
    Oct 4, 2017 at 20:02
  • One of my stores has more than 50k products. Its testing server is on a slow VPS and never timed out the indexing Oct 5, 2017 at 7:13
  • ok, thanks for the feedback, I've had occasions on Magento1 where it times out, but from memory, that was for over 100k of products now I think about it, so all should be fine, cheers for comments.
    – MagentoMac
    Oct 5, 2017 at 11:13

Your Answer

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

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