subcategory solution

[eluser]cahva[/eluser]

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