PrestaShop regenerate product rewrites

regenerate_product_rewrites.php

<?php

require_once __DIR__ . '/config/config.inc.php';

$db = Db::getInstance();

$rows = $db->executeS("
    SELECT id_product, id_lang, id_shop, name
    FROM " . _DB_PREFIX_ . "product_lang
    WHERE name IS NOT NULL AND name != ''
");

foreach ($rows as $row) {

    $id_product = (int)$row['id_product'];
    $id_lang    = (int)$row['id_lang'];
    $id_shop    = (int)$row['id_shop'];
    $name       = $row['name'];

    $rewrite = Tools::link_rewrite($name, $id_lang);

    if (!$rewrite) {
        continue;
    }

    $db->execute("
        UPDATE " . _DB_PREFIX_ . "product_lang
        SET link_rewrite = '" . pSQL($rewrite) . "'
        WHERE id_product = $id_product
          AND id_lang = $id_lang
          AND id_shop = $id_shop
    ");
}

echo "DONE\n";