Duplicating product gives ERR_TOO_MANY_REDIRECTS

[arjenbruinning]

I have the following problem:

When I duplicate a product the new product url get a -1 after it, f.e.

Original product: book-a4-brown

New product: book-a4-brown-1

Then I change the new url when editing the product to f.e.

book-a4-yellow

I save the product and check it on the website

What I see then is when I do a mouse over the new product (not click to open it). I see the copied url

book-a4-brown-1.html

But when I click it goes to the new, changed url (book-a4-yellow), except the product will not open. It gives an error: ERR_TOO_MANY_REDIRECTS

When i use the tool of Oleg Koval

https://github.com/olegkoval/magento2-regenerate_url_rewrites

to regenerate the url, it solves the problem. But is quite annoying. I expect it should work directly from my edit and not because I use this tool.

Do you have any idea what could cause this situation, this url issue? Any help is very appreciated.

[Bhanu Periwal]

Hi @arjenbruinning 

To correct this, please try to set Use Secure URLs in Admin to true, in System -> Config -> General -> Web

Or with database access, change following record value to 1 :

SELECT * FROM core_config_data where path like '%web/secure/use_in_adminhtml%';

If issue resolve, please click on 'Kudos' & Accept as Solution!

[arjenbruinning]

Thank you for your quick reaction. Unfortunately that was not he solution. 

Kind regards, Arjen

[Manish Mittal]

@arjenbruinning 

Error can be caused by a non-existing url_key value and it can be fixed by extending the ProductUrlPathGenerator class in your custom module.

Sharing same issue faced by others too:

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