Magento – Magento2 : URL key for specified store already exists while updating the existing product

admincategorymagento2

I am using the magento version 2.0.9 version for my site.

I am getting this Url key for specified store is already exist while updating the product or assigning the product for custom option and click on Save button.

I have deleted all entries in URL rewrite table in the database also. But I am still getting this error while updating any product.

Any idea for this error?

Best Answer

I came here searching for a similar issue but with Category save. So when I tried to save the category it threw same error "URL key for specified store already exists.".

After debugging by removing the try..catch block at insertMultiple() method of Magento\UrlRewrite\Model\Storage\DbStorage. I identified that while saving the category Magento was trying to re-build url rewrites for assigned products also. And few products had same url_key and that was throwing duplicate records error. As url_rewrite table has a UNIQUE contraint on request_path, store_id columns.

See exception.log to find out the url_key that is creating issue.

So I just made the url_key unique for products and that resolved the issue.

Hope these debugging steps may prove helpful to somebody who stumbles here again.

Related Solutions

Magento – Error, “URL key for specified store already exists” When I’m Adding Products or Moving a Category

We had a similar issue where we couldn't save categories and after much database searching and debugging I found the issue was when it updated the product url's for the category. We'd imported and deleted products previously but found out they still had entries in the url_rewrite table. So the request_path already existed.

To clear it out I had to run the query

delete from url_rewrite where entity_type='product' and entity_id NOT IN (Select entity_id from catalog_product_entity);

To check if you do have ghost records you can run

select count(*) from url_rewrite where entity_type='product' and entity_id NOT IN (Select entity_id from catalog_product_entity);

Good luck

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

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.

Best Answer

Related Solutions

Magento – Error, “URL key for specified store already exists” When I’m Adding Products or Moving a Category

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

Related Topic