Enabling friendly urls shows correct product, but url shows different product in my site

[ndst]

Www.starshinearts.com. I have enabled friendly urls, but they show a different product. I think it is because I used "duplicate product" when creating my products to streamline product entering. I was wondering if there is a way to display the correct url for the product.

[ndst]

http://alvinjiang.blogspot.com/2010/11/prestashop-tips-how-to-fix-duplicated.html

I found this, but it seems like a ton of work for 1000's of products...any way to do this via script?

[Bazze]

http://alvinjiang.bl...duplicated.html

I found this, but it seems like a ton of work for 1000's of products...any way to do this via script?

 

Yes, I did this to help one of my customers a time ago. This is what I used:

 

$sql = "SELECT pl.`id_product`, pl.`name`, pl.`id_lang` FROM `"._DB_PREFIX_."product_lang` pl";
$res = Db::getInstance()->ExecuteS($sql);
foreach ($res as $p) {
$sql = "UPDATE `"._DB_PREFIX_."product_lang` SET `link_rewrite` = '".Tools::link_rewrite($p['name'])."'
  WHERE `id_product` = '{$p['id_product']}' AND `id_lang` = '{$p['id_lang']}'";
Db::getInstance()->Execute($sql);
}

 

Please make sure to backup your database before running the script.

Edited April 27, 2012 by Bazze (see edit history)

[Bazze]

I made some updates to the script, just to let you know.

[ndst]

thanks a bunch!