Magento 2 URL rewrite Issue : URL key already exists for specified store

Magento 2 URL rewrite Issue : URL key already exists for specified store

October 6, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento 2 URL rewrite Issue : URL key already exists for specified store

Solving the Magento 2 URL Rewrite Issue: “URL Key Already Exists for Specified Store”

In the world of e-commerce development, one of the most common issues faced by developers is the dreaded “URL key already exists for specified store” error in Magento 2. This usually arises when trying to save multiple products programmatically or during bulk imports. In this post, we’ll delve into a specific instance of this issue on Magento 2.2.5 and provide a step-by-step solution that respects the integrity of your codebase.

Understanding the Issue

When you attempt to save a product using $product->save() or via the product repository in a loop, Magento might throw an PDOException due to duplicate entries in the url_rewrite table. This happens when the same URL key is used for different stores or websites within the multi-store setup.

$product = $this->productFactory->create();
$product->setName('The Lipstick');
$product->save();

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'the-lipstick.html-1' for key 'URL_REWRITE_REQUEST_PATH_STORE_ID' in /home/dev3/www/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228

What You’ve Tried So Far

You’ve attempted fixes suggested by the Magento community, including:

  1. Modifying the DBStorage class as mentioned here. However, these core hacks might cause compatibility issues with future updates or other parts of your system.

  2. The proposed solution on StackExchange involves setting the URL key explicitly before saving the product. While this works in some cases, it might not cover all edge scenarios and could lead to inconsistencies.

The Optimal Solution for Magento 2.2.5

To resolve this issue without modifying core files, follow these steps:

Step 1: Check Existing URLs Before Saving

Before saving a product, check if the desired URL key already exists in the database for the specified store view. You can achieve this using the urlRewriteRepository and the getList method.

$existingUrlKeys = $this->urlRewriteRepository->getList([
    'searchCriteria' => [
        'filter_groups' => [
            0 => [
                'filters' => [
                    ['field' => 'request_path', 'value' => $desiredUrlKey, 'condition_type' => 'eq'],
                    ['field' => 'store_id', 'value' => $targetStoreId, 'condition_type' => 'eq']
                ]
            ]
        ]
    ]
]);

Step 2: Generate a Unique URL Key if Necessary

If the URL key doesn’t exist or is already used in another store view, append a unique identifier to make it exclusive for the current product and store combination.

if ($existingUrlKeys->getTotalCount() > 0) {
    $urlKey = $desiredUrlKey . '_' . uniqid();
} else {
    $urlKey = $desiredUrlKey;
}

Step 3: Save the Product with the Unique URL Key

Finally, set the unique URL key and save the product. By following this approach, you ensure that each product has a unique URL key for each store view, preventing conflicts and maintaining data integrity.

$product->setUrlKey($urlKey);
$product->save();

Conclusion: Resolving Magento 2 URL Rewrite Issues Gracefully

In the world of e-commerce development, it’s crucial to handle edge cases gracefully without compromising the stability of your core system. By understanding and following the steps outlined above, you can resolve the “URL key already exists for specified store” issue in Magento 2.2.5 while preserving your codebase integrity.

To learn more about optimizing performance and security in your e-commerce platform, explore our comprehensive tutorials and guides on LaravelCompany.

Magento 2 Catalog Database Import/Export

Our network