alpenweide

I have the same problem...

Hi, Is there a function to only show tax to logged in clients? We have multiple tax rules (Belgium and France) with a very small difference, so this is confusing when clients are not logged in when browsing an filling a cart. Any tips? Thank you, Daan

Hi, thanks for pointing me in the right direction I should realy take the time to learn mysql this did the job: DELETE FROM `ps_country_lang` WHERE `id_lang`=2 SET `id_lang`=2 WHERE `id_lang`=4 Duplicated the database to test Thank you

Yes, that is the plan. But I was wondering if somebody could help with a command to edit all lines at once.. delete Id_lang 2 in this table and renaming id_lang 4 tot id_lang 2 Piece by piece will take forever to edit

Hi, Thanks for your reply In al the other tables the lang_id is correct, its just the ps_country_lang that isnt correct.. So searching for commands to just edit this table..

Nobody?

Hi, www.ahb-france.com is the website; It has two languages active: FR (id=2) and NL (id=3) The french country list is in the database but has the wrong ID. Can somebody help me to remove current id_lang 2 and change the current id_lang 4 to id_lang 2 Thank you verry much! Daan Sileghem

Searching for the same module.. no updates yet? (to add express service with a product = 25% of total price of only that product) Maybe with an "one time only" fee in the same module to add startcosts to a product?

Nobody?

Hi, Struggeling to get the permanent links working in my theme. In the theme permanent links (header) module is a dropdown menu in this theme, but I want it back as in the default theme. On top in a banner. Site is www.ahb-france.com (testsite, not active) Prestashop version 1.6.1.3 This is now: I want it like this: Moved the different folders and files and the css files but I'm forgetting something because it does not work Solution does not have to include the module, I could add links in the header, but I prefer the module.. Thanks in advance!

Thank you!

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');

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?