Hello @
ant99,
1) Here is an external script that can generate SEO-friendly urls for your products and categories:
PHP Code:
<?php
include_once('top.inc.php');
foreach(\XLite\Core\Database::getRepo('\XLite\Model\Category')->findAll() as $category) {
$category->setCleanURL(\XLite\Core\Database::getRepo('\XLite\Model\Category')->generateCleanURL());
\XLite\Core\Database::getEM()->flush();
}
foreach(\XLite\Core\Database::getRepo('\XLite\Model\Product')->findAll() as $product) {
$product->setCleanURL(\XLite\Core\Database::getRepo('\XLite\Model\Product')
->generateCleanURL());
\XLite\Core\Database::getEM()->flush();
}
Of course, make a backup of your DB before running it.
2) There is no way of importing SEO-friendly urls, but you can put the history of them directly to the xc_clean_urls table. The value with highest ID is used as actual SEO-friendly url. The record with the same product_id, but lesser ID will be assumed as a history url.
Hopefully, it will help.
Tony