Magento – Magento 2: URL for key for specified store already exists in categories

categorydatabasemagento2product

We are having a problem in our Magento 2.1.3 shop when we try to save the categories. We are getting the message URL for a key for specified store already exists.

The shop is a migration from a Magento 1 shop and has several root categories and stores. There are in the different root categories with the same name.

Till now we could not really find connections where it gives the error and sometimes it does not give the error.

Is there anyone with experience with this error that knows why this is happening?

Best Answer

This issue happens when the URL rewrite you are trying to create already exists for that store.

For example, if you had 2 categories both named clothing and tried to set the url_key for each to clothing-category Magento wouldn't let you save the 2nd category because the URL example.com/clothing-category is already being used.

It might not necessarily be another category URL rewrite that is conflicting either. If you had a cms page or any other entity already using that URL Magento would show that same error.

Related Solutions

Fix URL Key for Specified Store Already Exists Error – Magento 2

Use body like this.

{
  "parent_id": 2,
  "name": "Category 1",
  "is_active": true,
  "include_in_menu": true,
  "custom_attributes": [
    {
      "attribute_code": "is_anchor",
      "value": "1"
    },
    {
      "attribute_code": "url_key",
      "value": "category-1"
    }  
 ]
}

Custom attributes "url_key" must be unique for all categories (and products)

Magento – Magento 2 : URL key For Specified Store Already Exists

I've fixed this issue. And I have 2 solutions for that.

The first one: Clean up your database in table url_rewrite (Change the url_key of all category). You can write UpgradeData script for this solution.

The second one: Remove the duplication data when saving category. This data is throw in method doReplace($urls) in \vendor\magento\module-url-rewrite\Model\Storage\DbStorage.php file.

protected function doReplace($urls)
    {
        foreach ($this->createFilterDataBasedOnUrls($urls) as $type => $urlData) {
            $urlData[UrlRewrite::ENTITY_TYPE] = $type;
            $this->deleteByData($urlData);
        }
        $data = [];
        foreach ($urls as $url) {
            $data[] = $url->toArray();
        }
        $this->insertMultiple($data);
    }

After debugging, I found out $data variable has a duplicate record. If you want this method to work without any errors. Rewrite this method above to:

protected function doReplace($urls)
{
    foreach ($this->createFilterDataBasedOnUrls($urls) as $type => $urlData) {
        $urlData[UrlRewrite::ENTITY_TYPE] = $type;
        $this->deleteByData($urlData);
    }
    $data = [];
    $storeId_requestPaths = [];
    foreach ($urls as $url) {
        $storeId = $url->getStoreId();
        $requestPath = $url->getRequestPath();
        // Skip if is exist in the database
        $sql = "SELECT * FROM url_rewrite where store_id = $storeId and request_path = '$requestPath'";
        $exists = $this->connection->fetchOne($sql);

        if ($exists) continue;

        $storeId_requestPaths[] = $storeId . '-' . $requestPath;
        $data[] = $url->toArray();
    }

    // Remove duplication data;
    $n = count($storeId_requestPaths);
    for ($i = 0; $i < $n - 1; $i++) {
        for ($j = $i + 1; $j < $n; $j++) {
            if ($storeId_requestPaths[$i] == $storeId_requestPaths[$j]) {
                unset($data[$j]);
            }
        }
    }
    $this->insertMultiple($data);
}

If you want to get more details. Please, read my comment in

https://github.com/magento/magento2/issues/7298

Hope this will help you.

Best Answer

Related Solutions

Fix URL Key for Specified Store Already Exists Error – Magento 2

Magento – Magento 2 : URL key For Specified Store Already Exists

Related Topic