Magento URL rewrite append random number in Url

Magento URL rewrite append random number in Url

September 11, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento URL rewrite append random number in Url

Resolving Magento URL Rewrite Issues with Random Numbers

As an experienced developer, I understand your frustration when dealing with Magento’s persistent insertion of random numbers into product URLs, even after ensuring unique product names. This issue can cause confusion for both customers and search engines.

Understanding the Core Problem

The problem lies in how Magento generates product URLs. By default, it checks if a URL key already exists in the core_url_rewrite table before creating a new one. If a similar URL key is found (even with slight differences), it appends a random number to maintain uniqueness.

Initial Troubleshooting Steps

You’ve taken several correct steps so far:

  1. Truncated the core_url_rewrite table
  2. Reindexed Catalog URL Rewrites
  3. Attempted to modify the app/code/core/Mage/Catalog/Model/Url.php file as suggested in this stack exchange post.

However, it seems that these steps haven’t resolved your issue completely.

A Deeper Dive

The core issue might be related to how Magento handles URL rewrites during the product creation or update process. When you create a new product with a unique name but similar attributes (like SKU), Magento could still consider it as a duplicate and append a random number.

My Recommendations

  1. Manual Intervention: Review your Catalog URL Rewrites in the Magento admin panel (Marketing > SEO & Search > URL Rewrite Management). Manually delete any entries that have appended numbers.

  2. Database Cleanup Script: Write a custom script to clean up the core_url_rewrite table based on specific criteria (e.g., only keep the most recent entry for each product). You can use Magento’s Mage_Core_Model_Resource_Url_Rewrite_Collection class to query and manipulate the data.

    Here’s a basic example:

    $collection = Mage::getModel('core/url_rewrite')->getCollection();
    foreach ($collection as $item) {
        // Add your conditions here, e.g., based on product ID or URL key
        $productId = Mage::getModel('catalog/product')->getIdBySku($item->getProduct_id());
        if ($productId) {
            // Keep only the most recent entry for each product
            $collection->addFieldToFilter('product_id', array('eq' => $productId));
        }
    }
    
  3. Avoid Similar Attributes: Ensure that your products have distinct names, SKUs, and other identifying attributes to prevent Magento from considering them as duplicates.

Conclusion

Resolving this issue requires a combination of manual cleanup in the admin panel and potentially writing custom scripts to manage the core_url_rewrite data more effectively. It’s important to understand how Magento handles URL rewrites and work within its limitations.

Remember, any changes to core files should be done carefully or ideally through an extension, as they can be overwritten during updates. If you find this process complex, consider hiring a Magento developer from Laravel Company for professional assistance.

With these steps and some patience, you should be able to rid your site of those pesky appended random numbers in product URLs.

Catalog Indexing Database Admin

Our network