(Solved) Duplicating a Product, Friendly URL does not update/change.

[sc157]

I duplicated a product in Prestashop and changed the name. The friendly URL did not change.

For Example:
-------------------
Original Product Name: Apples and Bananas
Original Product URL http://www.abcstore.com/category-1/20-apples-and-bananas.html

Then I duplicated the original product and changed the name of the new duplicated product from "Apples and Bananas" to "Oranges and Strawberries"
The new product URL should be http://www.abcstore.com/category-1/21-oranges-and-strawberries.html
But no.... instead, it is http://www.abcstore.com/category-1/21-apples-and-bananas.html

In the example above, the product ID successfully changed from "20" to "21", but everything after the product ID did not change.

How do I fix this? Any ideas?

I tried regenerating the htaccess file but that made no difference.

[ncandelier]

Hello ,

I am facing exactly the same problem.
I just set up the lateste prestashop.
In the admin when i duplicate product called "lavabo rehausse" , even if i rename the product in the product edition the name "lavabo rehausse" remains in the product list
This has for consequence to give me the same friendly url for all the duplicated products.

Any idea ?

Update :

When i change the langage : the Name of the product in the admin listing change... but the Friendly URL remains the same and contains the name of the original duplicated product...

[shokinro]

I don't see any place on the Back Office that you can change that. But I think you can fix them by change at database directly. You have to change the link_rewrite field in ps_product_lang table. You can change them by database admin tool such as PhpMyAdmin.

1. Find your product id in the ps_product table
2. Change link_rewrite in the table ps_product_lang

Hope this help

[ncandelier]

Thank you shokinro for your answer.

I found the table.
I would like to purge the link_rewrite entries...
Do you think i can delete all the entries without problem in phpmyadmin ?

[shokinro]

I don't think you should delete them, you must keep them, otherwise the SEO friendly URL will not work.
What you need to do is to change them to what you want it to be. For example, you have to change "Apples and Bananas" to "Oranges and Strawberries" for the record with id_product =21

After modifying all record, then try to re-generate .htaccess file, the link URLs will become correct.

[sc157]

Solved! Thank you Shokinro for the help! Such an easy fix.

[tomerg3]

Please add (Solved) to the title of the first post...

[tinek]

Do you really consider this fixed? It is fiddling with the database directly - hardly a solution. Is there really no other way to change a url in presta after you have modified a product name?

[tomerg3]

You can change it for each product manually, in the product editor, "Click here to improve product's rank in search engines (SEO)" will display the meta tags and the friendly URL

[louissss]

Indeed, it is not a very good solution. Isn't there a way in the back office to refresh all link_rewrite ?

[orlovskyy]

Hello,

I have a problem to duplicate products, so when I click duplicate it says duplicated successful, but not showing the product. I have checked the DB and the product was duplicated, but not showing in the back office.

What is the problem?

Thanks.