Seo & Url Translation

[alpenweide]

Hi,

 

I worked on a spanish instalation and was asked to add French and Dutch translations.

(and translate all the products aswell, but that doenst matter here)

 

In Bo no problem ofcourse, its all automated with the language packs.

 

The SEO and URL do not change, where can I find the file/option to import/copy and overwrite the existing translation?

 

Dutch fields are filled in with spanish text..

 

Yes I can do this manualy, but there are existing dutch and french translations, so should be possible to automate it?

 

[alpenweide]

Solved it:

 

Made a new instalation in the languages I wanted.

 

Found this line in an other topic: https://www.prestashop.com/forums/topic/307616-seo-urls-and-countries-not-in-translation-packs/

SELECT CONCAT('UPDATE ps_meta_lang SET id_shop=',id_shop,',title=\'',title,'\',description=\'',description,'\',keywords=\'',keywords,'\',url_rewrite=\'',url_rewrite,'\' WHERE id_lang=',id_lang,' AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = \'',ps_meta.page,'\');') FROM `ps_meta_lang`,ps_meta WHERE `ps_meta_lang`.id_meta=ps_meta.id_meta LIMIT 0,1000 

The dutch / french / german output is this: (change language ID to the ones you use!!!)

 

Gave an error on this line, just removed it:

UPDATE ps_meta_lang SET id_shop=1,title='Mot de passe oublié',description='Entrez l'adresse e-mail que vous utilisez pour vous connecter afin de recevoir un e-mail avec un nouveau mot de passe',keywords='',url_rewrite='recuperation-mot-de-passe' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'password');

UPDATE ps_meta_lang SET id_shop=1,title='Adres',description='',keywords='',url_rewrite='adres' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'address');
UPDATE ps_meta_lang SET id_shop=1,title='Adresse',description='',keywords='',url_rewrite='adresse' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'address');
UPDATE ps_meta_lang SET id_shop=1,title='Adresse',description='',keywords='',url_rewrite='adresse' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'address');
UPDATE ps_meta_lang SET id_shop=1,title='Adressen',description='',keywords='',url_rewrite='adressen' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'addresses');
UPDATE ps_meta_lang SET id_shop=1,title='Adresses',description='',keywords='',url_rewrite='adresses' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'addresses');
UPDATE ps_meta_lang SET id_shop=1,title='Adressen',description='',keywords='',url_rewrite='adressen' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'addresses');
UPDATE ps_meta_lang SET id_shop=1,title='Login',description='',keywords='',url_rewrite='login' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'authentication');
UPDATE ps_meta_lang SET id_shop=1,title='Connexion',description='',keywords='',url_rewrite='connexion' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'authentication');
UPDATE ps_meta_lang SET id_shop=1,title='Authentifizierung',description='',keywords='',url_rewrite='authentifizierung' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'authentication');
UPDATE ps_meta_lang SET id_shop=1,title='Best verkochte artikelen',description='Onze best verkochte artikelen',keywords='best sales',url_rewrite='best-verkochte-artikelen' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'best-sales');
UPDATE ps_meta_lang SET id_shop=1,title='Meilleures ventes',description='Nos meilleures ventes',keywords='',url_rewrite='meilleures-ventes' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'best-sales');
UPDATE ps_meta_lang SET id_shop=1,title='Verkaufshits',description='Unsere Verkaufshits',keywords='Verkaufshits',url_rewrite='verkaufshits' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'best-sales');
UPDATE ps_meta_lang SET id_shop=1,title='Winkelmandje',description='',keywords='',url_rewrite='winkelmandje' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'cart');
UPDATE ps_meta_lang SET id_shop=1,title='Panier',description='',keywords='',url_rewrite='panier' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'cart');
UPDATE ps_meta_lang SET id_shop=1,title='Warenkorb',description='',keywords='',url_rewrite='warenkorb' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'cart');
UPDATE ps_meta_lang SET id_shop=1,title='Contact met ons opnemen',description='Neem contact met ons op via ons formulier',keywords='contact, form, e-mail',url_rewrite='contact-met-ons-opnemen' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'contact');
UPDATE ps_meta_lang SET id_shop=1,title='Nous contacter',description='Utiliser le formulaire pour nous contacter',keywords='',url_rewrite='nous-contacter' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'contact');
UPDATE ps_meta_lang SET id_shop=1,title='Kontaktieren Sie uns',description='Nutzen Sie unser Kontaktformular',keywords='Kontakt, Formular, E-Mail',url_rewrite='kontaktieren-sie-uns' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'contact');
UPDATE ps_meta_lang SET id_shop=1,title='Korting',description='',keywords='',url_rewrite='korting' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'discount');
UPDATE ps_meta_lang SET id_shop=1,title='Réduction',description='',keywords='',url_rewrite='reduction' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'discount');
UPDATE ps_meta_lang SET id_shop=1,title='Discount',description='',keywords='',url_rewrite='discount' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'discount');
UPDATE ps_meta_lang SET id_shop=1,title='Gast traceren',description='',keywords='',url_rewrite='gast traceren' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'guest-tracking');
UPDATE ps_meta_lang SET id_shop=1,title='Suivi de commande invité',description='',keywords='',url_rewrite='suivi-commande-invite' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'guest-tracking');
UPDATE ps_meta_lang SET id_shop=1,title='Auftragsverfolgung Gast',description='',keywords='',url_rewrite='auftragsverfolgung-gast' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'guest-tracking');
UPDATE ps_meta_lang SET id_shop=1,title='Besteloverzicht',description='',keywords='',url_rewrite='bestel-overzicht' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'history');
UPDATE ps_meta_lang SET id_shop=1,title='Historique des commandes',description='',keywords='',url_rewrite='historique-commandes' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'history');
UPDATE ps_meta_lang SET id_shop=1,title='Bestellungsverlauf',description='',keywords='',url_rewrite='bestellungsverlauf' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'history');
UPDATE ps_meta_lang SET id_shop=1,title='Identiteit',description='',keywords='',url_rewrite='identiteit' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'identity');
UPDATE ps_meta_lang SET id_shop=1,title='Identité',description='',keywords='',url_rewrite='identite' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'identity');
UPDATE ps_meta_lang SET id_shop=1,title='Kennung',description='',keywords='',url_rewrite='kennung' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'identity');
UPDATE ps_meta_lang SET id_shop=1,title='',description='Winkel gerund met behulp van PrestaShop',keywords='shop, prestashop',url_rewrite='' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'index');
UPDATE ps_meta_lang SET id_shop=1,title='',description='Boutique propulsée par PrestaShop',keywords='',url_rewrite='' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'index');
UPDATE ps_meta_lang SET id_shop=1,title='',description='Shop powered by PrestaShop',keywords='Shop, prestashop',url_rewrite='' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'index');
UPDATE ps_meta_lang SET id_shop=1,title='Fabrikanten',description='Lijst met fabrikanten',keywords='manufacturer',url_rewrite='fabrikanten' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'manufacturer');
UPDATE ps_meta_lang SET id_shop=1,title='Fabricants',description='Liste des fabricants',keywords='',url_rewrite='fabricants' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'manufacturer');
UPDATE ps_meta_lang SET id_shop=1,title='Hersteller',description='Herstellerliste',keywords='Hersteller',url_rewrite='hersteller' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'manufacturer');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blocknewsletter-verification');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blocknewsletter-verification');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blocknewsletter-verification');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blockwishlist-mywishlist');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blockwishlist-mywishlist');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blockwishlist-mywishlist');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blockwishlist-view');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blockwishlist-view');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-blockwishlist-view');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-cronjobs-callback');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-cronjobs-callback');
UPDATE ps_meta_lang SET id_shop=1,title='',description='',keywords='',url_rewrite='' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'module-cronjobs-callback');
UPDATE ps_meta_lang SET id_shop=1,title='Mijn account',description='',keywords='',url_rewrite='mijn-account' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'my-account');
UPDATE ps_meta_lang SET id_shop=1,title='Mon compte',description='',keywords='',url_rewrite='mon-compte' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'my-account');
UPDATE ps_meta_lang SET id_shop=1,title='Mein Konto',description='',keywords='',url_rewrite='mein-Konto' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'my-account');
UPDATE ps_meta_lang SET id_shop=1,title='Nieuwe producten',description='Onze nieuwe producten',keywords='new, products',url_rewrite='nieuwe-producten' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'new-products');
UPDATE ps_meta_lang SET id_shop=1,title='Nouveaux produits',description='Nos nouveaux produits',keywords='',url_rewrite='nouveaux-produits' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'new-products');
UPDATE ps_meta_lang SET id_shop=1,title='Neue Produkte',description='Unsere neuen Produkte',keywords='neu, Produkte',url_rewrite='neue-Produkte' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'new-products');
UPDATE ps_meta_lang SET id_shop=1,title='Bestelling',description='',keywords='',url_rewrite='bestelling' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order');
UPDATE ps_meta_lang SET id_shop=1,title='Commande',description='',keywords='',url_rewrite='commande' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order');
UPDATE ps_meta_lang SET id_shop=1,title='Bestellung',description='',keywords='',url_rewrite='bestellung' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order');
UPDATE ps_meta_lang SET id_shop=1,title='Orderbevestiging',description='',keywords='',url_rewrite='order-bevestiging' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-confirmation');
UPDATE ps_meta_lang SET id_shop=1,title='Confirmation de commande',description='',keywords='',url_rewrite='confirmation-commande' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-confirmation');
UPDATE ps_meta_lang SET id_shop=1,title='Bestellbestätigung',description='',keywords='',url_rewrite='bestellbestatigung' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-confirmation');
UPDATE ps_meta_lang SET id_shop=1,title='Bestelling volgen',description='',keywords='',url_rewrite='bestelling-volgen' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-follow');
UPDATE ps_meta_lang SET id_shop=1,title='Suivi de commande',description='',keywords='',url_rewrite='suivi-commande' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-follow');
UPDATE ps_meta_lang SET id_shop=1,title='Bestellungsverfolgung',description='',keywords='',url_rewrite='bestellungsverfolgung' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-follow');
UPDATE ps_meta_lang SET id_shop=1,title='Bestelling',description='',keywords='',url_rewrite='snel bestellen' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-opc');
UPDATE ps_meta_lang SET id_shop=1,title='Commande',description='',keywords='',url_rewrite='commande-rapide' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-opc');
UPDATE ps_meta_lang SET id_shop=1,title='Bestellung',description='',keywords='',url_rewrite='schnell-bestellung' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-opc');
UPDATE ps_meta_lang SET id_shop=1,title='Bestelbon',description='',keywords='',url_rewrite='bestel-bon' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-slip');
UPDATE ps_meta_lang SET id_shop=1,title='Avoirs',description='',keywords='',url_rewrite='avoirs' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-slip');
UPDATE ps_meta_lang SET id_shop=1,title='Bestellschein',description='',keywords='',url_rewrite='bestellschein' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'order-slip');
UPDATE ps_meta_lang SET id_shop=1,title='404 fout',description='We hebben de pagina niet gevonden',keywords='error, 404, not found',url_rewrite='pagina-niet-gevonden' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'pagenotfound');
UPDATE ps_meta_lang SET id_shop=1,title='Erreur 404',description='Impossible de trouver la page',keywords='',url_rewrite='page-introuvable' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'pagenotfound');
UPDATE ps_meta_lang SET id_shop=1,title='Fehler 404',description='Seite wurde nicht gefunden',keywords='Fehler 404, nicht gefunden',url_rewrite='seite-nicht-gefunden' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'pagenotfound');
UPDATE ps_meta_lang SET id_shop=1,title='Uw wachtwoord vergeten',description='Voer het e-mailadres in dat u heeft gebruikt voor uw aanmelding om een e-mail met een nieuw wachtwoord te ontvangen',keywords='forgot, password, e-mail, new, reset',url_rewrite='wachtwoord-opvragen' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'password');
UPDATE ps_meta_lang SET id_shop=1,title='Mot de passe oublié',description='Entrez l'adresse e-mail que vous utilisez pour vous connecter afin de recevoir un e-mail avec un nouveau mot de passe',keywords='',url_rewrite='recuperation-mot-de-passe' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'password');
UPDATE ps_meta_lang SET id_shop=1,title='Kennwort vergessen',description='Geben Sie die E-Mailadresse ein, die Sie zum Einloggen benutzen, damit Sie eine E-Mail mit dem neuen Kennwort erhalt',keywords='vergessen, Kennwort, E-Mail, neu, Reset',url_rewrite='kennwort-wiederherstellung' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'password');
UPDATE ps_meta_lang SET id_shop=1,title='Prijsverlaging',description='Onze speciale producten',keywords='special, prices drop',url_rewrite='prijs-verlaging' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'prices-drop');
UPDATE ps_meta_lang SET id_shop=1,title='Promotions',description='Nos promotions',keywords='',url_rewrite='promotions' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'prices-drop');
UPDATE ps_meta_lang SET id_shop=1,title='Angebote',description='Unsere Sonderangebote',keywords='besonders, Angebote',url_rewrite='angebote' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'prices-drop');
UPDATE ps_meta_lang SET id_shop=1,title='Productvergelijking',description='',keywords='',url_rewrite='product-vergelijking' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'products-comparison');
UPDATE ps_meta_lang SET id_shop=1,title='Comparaison de produits',description='',keywords='',url_rewrite='comparaison-produits' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'products-comparison');
UPDATE ps_meta_lang SET id_shop=1,title='Products Comparison',description='',keywords='',url_rewrite='products-comparison' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'products-comparison');
UPDATE ps_meta_lang SET id_shop=1,title='Zoeken',description='',keywords='',url_rewrite='zoeken' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'search');
UPDATE ps_meta_lang SET id_shop=1,title='Recherche',description='',keywords='',url_rewrite='recherche' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'search');
UPDATE ps_meta_lang SET id_shop=1,title='Suche',description='',keywords='',url_rewrite='suche' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'search');
UPDATE ps_meta_lang SET id_shop=1,title='Sitemap',description='De weg kwijt? Vinden wat u zoekt',keywords='sitemap',url_rewrite='sitemap' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'sitemap');
UPDATE ps_meta_lang SET id_shop=1,title='Plan du site',description='Vous êtes perdu ? Trouvez ce que vous cherchez',keywords='',url_rewrite='plan-site' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'sitemap');
UPDATE ps_meta_lang SET id_shop=1,title='Sitemap',description='Verloren? Finden Sie, was Sie suchen',keywords='sitemap',url_rewrite='sitemap' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'sitemap');
UPDATE ps_meta_lang SET id_shop=1,title='Winkels',description='',keywords='',url_rewrite='winkels' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'stores');
UPDATE ps_meta_lang SET id_shop=1,title='Magasins',description='',keywords='',url_rewrite='magasins' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'stores');
UPDATE ps_meta_lang SET id_shop=1,title='Shops',description='',keywords='',url_rewrite='shops' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'stores');
UPDATE ps_meta_lang SET id_shop=1,title='Leveranciers',description='Lijst met leveranciers',keywords='supplier',url_rewrite='leverancier' WHERE id_lang=1 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'supplier');
UPDATE ps_meta_lang SET id_shop=1,title='Fournisseurs',description='Liste des fournisseurs',keywords='',url_rewrite='fournisseur' WHERE id_lang=2 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'supplier');
UPDATE ps_meta_lang SET id_shop=1,title='Zulieferer',description='Zuliefererliste',keywords='Zulieferer',url_rewrite='zulieferer' WHERE id_lang=3 AND id_meta = (SELECT id_meta FROM ps_meta WHERE page = 'supplier');