Magento URL indexing and core_url_rewrite table

Magento URL indexing and core_url_rewrite table

July 3, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento URL indexing and core_url_rewrite table

Understanding Magento URL Indexing: The Mystery of the core_url_rewrite Table

As a seasoned developer working extensively on eCommerce platforms like Magento, I often encounter queries from merchants concerned about the sudden growth in their core_url_rewrite table. This table is crucial for managing product URLs and ensuring SEO-friendly links across your store.

The Role of Catalog URL Rewrite Reindexing

The catalog_url_rewrite reindex process is a critical part of Magento’s indexing system. Its primary function is to generate or update the URL rewrites for all products in your catalog. This process ensures that every time you add, edit, or delete a product, its corresponding URLs are managed accordingly.

Understanding the core_url_rewrite Table Growth

When you observe an increase of around 10,000 rows in the core_url_rewrite table after reindexing, even without any product data changes, it might seem counterintuitive. However, this phenomenon can be attributed to several reasons:

Magento’s Multi-Store and Multi-Site Configuration

If you have configured multiple stores or websites within your Magento installation, the URL rewrite process generates separate entries for each store view. Even if the product data remains identical across views, a new URL rewrite is created for each unique URL path.

To verify this:

SELECT * FROM core_url_rewrite WHERE meta_title LIKE '%your-product-name%';

This query should return multiple rows, one for each store view where your product appears.

Product Image Resizing and Reindexing

Magento’s image resizing process also triggers the URL rewrite reindex. Whenever you resize an image in the admin panel or manually initiate the catalog_product_attribute_media_gallery index, Magento updates the core_url_rewrite table to reflect the new image paths.

Third-Party Extensions and Custom Modifications

Some third-party extensions or custom modifications might trigger additional URL rewrites. For instance, SEO extensions often add custom rewrite rules for category pages or CMS content.

Best Practices for Managing core_url_rewrite Table Growth

While Magento’s default behavior is to create separate URLs for each store view and image variation, you can optimize the core_url_rewrite table growth:

  1. Avoid Unnecessary Indexing: Limit manual reindexing to only when required, such as after adding or modifying products.

  2. Use Relative Image Paths: Configure your images to use relative paths instead of absolute ones. This reduces the number of unique URLs generated for product images.

  3. Clean Up Old Entries: Periodically clean up old or redundant entries from the core_url_rewrite table using a script or extension that handles URL cleanup.

Conclusion: Embracing Magento’s URL Rewrite System

The growth in the core_url_rewrite table is a natural consequence of Magento’s flexible multi-store and multi-site architecture, coupled with its robust image resizing capabilities. While it might seem concerning at first, this process ensures that your store maintains SEO-friendly URLs across all configured environments.

By understanding Magento’s default behavior and implementing best practices for indexing, you can effectively manage the core_url_rewrite table without compromising your store’s performance or search engine optimization.

For more advanced strategies on managing URL rewrites in Magento, consider exploring our dedicated guide Optimizing Magento URLs: A Comprehensive Guide. It provides a deep dive into Magento’s URL architecture and offers practical tips for maximizing SEO benefits while minimizing database growth.

Remember, the key to successful eCommerce management lies in understanding your platform’s core mechanics. By embracing Magento’s URL rewrite system and following best practices, you can create a robust foundation for your online store that drives traffic and converts customers.

Catalog Indexing Database Configuration

Our network