Update catalog_category_entity set 
path= concat(path,<@KEY@>)
where entity_id = <@KEY@>
@@GO@@
update core_url_rewrite
set 
id_path = concat('category/', '<@KEY@>'), 
request_path = concat(REPLACE('<@SDESCRIPTION@>',' ','-'), '.html'),  
target_path = concat('catalog/category/view/id/', '<@KEY@>')
where 
category_id = <@KEY@>
@@GO@@
Update index_process set started_at = now(), ended_at = now() where indexer_code = 'catalog_url';
@@GO@@
Update index_process set started_at = now(), ended_at = now() where indexer_code = 'catalog_category_product';
@@GO@@
Update index_process set started_at = now(), ended_at = now() where indexer_code = 'catalogsearch_fulltext';
@@GO@@
