[eluser]cahva[/eluser]
Quote:L.E: But if you have 1000 products and you change a category name , doesn’t this mean that you need to update all the url’s in database ?
Hmm.. I dont really see the problem here. Its just matter of replacing products seo according to the new category name. For example:
Code:
if ($old_path != $new_path)
{
$this->db->query("UPDATE products_description SET full_path=REPLACE(full_path,'{$old_path}','{$new_path}') WHERE full_path LIKE '{$old_path}%'");
}
The old_path != new_path is just that I dont update if not necessary.
Speedwise that doesnt take long. Atleast with 1000 products in database and 10 products to be changed