Mrthdrb

Is it appropriate to ask a job candidate if we can record their interview?

Inappropriate reference requests from Journal reviewers

How does buying out courses with grant money work?

Pole-zeros of a real-valued causal FIR system

Do the temporary hit points from the Battlerager barbarian's Reckless Abandon stack if I make multiple attacks on my turn?

What is the opposite of 'gravitas'?

How does Loki do this?

How to run a prison with the smallest amount of guards?

Roman Numeral Treatment of Suspensions

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Return the Closest Prime Number

Two monoidal structures and copowering

How does it work when somebody invests in my business?

How can I kill an app using Terminal?

A particular customize with green line and letters for subfloat

How do I go from 300 unfinished/half written blog posts, to published posts?

What is the best translation for "slot" in the context of multiplayer video games?

Gears on left are inverse to gears on right?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

How do I extract a value from a time formatted value in excel?

Did Dumbledore lie to Harry about how long he had James Potter's invisibility cloak when he was examining it? If so, why?

How do we know the LHC results are robust?

Why not increase contact surface when reentering the atmosphere?

Would a high gravity rocky planet be guaranteed to have an atmosphere?

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

URL key for specified store already exists while updating the existing productAdditional data: URL key for specified store already exists even after deleting catalog_product_entity“URL key for specified store already exists.” when renameing categoryURL key for specified store already exists for category and product alsoMagento 2: URL for key for specified store already exists in categoriesProduct Url Key not working rewrite and category say url key specified store already existsWe change the root category to sub category url key is already exists errorURL key for specified store already exists on Category edit in Magento in Magento 2.1.6URL key for specified store already exists Magento 2import products csv file fails with 'Specified URL key already exists in row(s)' error

5

I'm getting the error, "URL key for specified store already exists" when I try moving or adding products to a category in Magento 2 (Version 2.1). I have searched all over for a fix and even tried the fix here on Gihub but still I keep getting the error. The other problem even is that when I manually add or change a "URL Key" to make it work I still get the error.

Any help would be much appreciated.

magento2 product url-key

share|improve this question

edited Dec 18 '17 at 13:24

7ochem

5,81493768

asked Jul 29 '16 at 5:21

P. PaulP. Paul

76110

add a comment | 

5

I'm getting the error, "URL key for specified store already exists" when I try moving or adding products to a category in Magento 2 (Version 2.1). I have searched all over for a fix and even tried the fix here on Gihub but still I keep getting the error. The other problem even is that when I manually add or change a "URL Key" to make it work I still get the error.

Any help would be much appreciated.

magento2 product url-key

share|improve this question

edited Dec 18 '17 at 13:24

7ochem

5,81493768

asked Jul 29 '16 at 5:21

P. PaulP. Paul

76110

add a comment | 

I'm getting the error, "URL key for specified store already exists" when I try moving or adding products to a category in Magento 2 (Version 2.1). I have searched all over for a fix and even tried the fix here on Gihub but still I keep getting the error. The other problem even is that when I manually add or change a "URL Key" to make it work I still get the error.

Any help would be much appreciated.

magento2 product url-key

share|improve this question

edited Dec 18 '17 at 13:24

7ochem

5,81493768

asked Jul 29 '16 at 5:21

P. PaulP. Paul

76110

share|improve this question

edited Dec 18 '17 at 13:24

7ochem

5,81493768

asked Jul 29 '16 at 5:21

P. PaulP. Paul

76110

share|improve this question

edited Dec 18 '17 at 13:24

7ochem

5,81493768

asked Jul 29 '16 at 5:21

P. PaulP. Paul

76110

edited Dec 18 '17 at 13:24

7ochem

5,81493768

edited Dec 18 '17 at 13:24

7ochem

5,81493768

asked Jul 29 '16 at 5:21

P. PaulP. Paul

76110

asked Jul 29 '16 at 5:21

P. PaulP. Paul

76110

1 Answer
1

active

oldest

votes

5

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

share|improve this answer

answered Aug 24 '16 at 7:10

Jason WattJason Watt

613

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank so much @JasonWatt for the help! When I ran both commands I got the error, "#1146 - Table 'magnetodatabase.url_rewrite' doesn't exist". So I thought maybe I don't have a "url_rewrite" table. But when I checked with "select "url_rewrite" command the "url_rewrite" table came up.
  
  – P. Paul
  Aug 26 '16 at 17:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Paul Not sure where you're running the sql from but if it's on the command line try running use magnetodatabase first before the queries. Always test with the select query I sent first.
  
  – Jason Watt
  Aug 29 '16 at 23:40
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the help. I surely did run it later with the prefix and the queries worked. But the other problem was is that the first query didn't didn't delete anything according to the message. Then I used the second one to check for the ghost records and that one also stated no record found. In effect, the problem still exists. Thanks!
  
  – P. Paul
  Aug 31 '16 at 0:40
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f128045%2ferror-url-key-for-specified-store-already-exists-when-im-adding-products-or%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

5

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

share|improve this answer

answered Aug 24 '16 at 7:10

Jason WattJason Watt

613

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank so much @JasonWatt for the help! When I ran both commands I got the error, "#1146 - Table 'magnetodatabase.url_rewrite' doesn't exist". So I thought maybe I don't have a "url_rewrite" table. But when I checked with "select "url_rewrite" command the "url_rewrite" table came up.
  
  – P. Paul
  Aug 26 '16 at 17:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Paul Not sure where you're running the sql from but if it's on the command line try running use magnetodatabase first before the queries. Always test with the select query I sent first.
  
  – Jason Watt
  Aug 29 '16 at 23:40
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the help. I surely did run it later with the prefix and the queries worked. But the other problem was is that the first query didn't didn't delete anything according to the message. Then I used the second one to check for the ghost records and that one also stated no record found. In effect, the problem still exists. Thanks!
  
  – P. Paul
  Aug 31 '16 at 0:40
  

  
  
  
  

add a comment | 

5

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

share|improve this answer

answered Aug 24 '16 at 7:10

Jason WattJason Watt

613

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank so much @JasonWatt for the help! When I ran both commands I got the error, "#1146 - Table 'magnetodatabase.url_rewrite' doesn't exist". So I thought maybe I don't have a "url_rewrite" table. But when I checked with "select "url_rewrite" command the "url_rewrite" table came up.
  
  – P. Paul
  Aug 26 '16 at 17:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Paul Not sure where you're running the sql from but if it's on the command line try running use magnetodatabase first before the queries. Always test with the select query I sent first.
  
  – Jason Watt
  Aug 29 '16 at 23:40
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the help. I surely did run it later with the prefix and the queries worked. But the other problem was is that the first query didn't didn't delete anything according to the message. Then I used the second one to check for the ghost records and that one also stated no record found. In effect, the problem still exists. Thanks!
  
  – P. Paul
  Aug 31 '16 at 0:40
  

  
  
  
  

add a comment | 

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

share|improve this answer

answered Aug 24 '16 at 7:10

Jason WattJason Watt

613

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

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

share|improve this answer

answered Aug 24 '16 at 7:10

Jason WattJason Watt

613

answered Aug 24 '16 at 7:10

Jason WattJason Watt

613

answered Aug 24 '16 at 7:10

Jason WattJason Watt

613