Traducir prestashop back office

En instalaciones de Prestashop 1.7 en ocasiones no se traduce el panel de administración o back office, pero se puede traducir fácilmente con unas sentencias sql en la base de datos.

Índice

Traducir prestashop 1.7 a español

Traducir prestashop 1.7 a español

Primero conocer el identificador o id del idioma español.

ir a menú > Internacional > Localización > Pestaña Idiomas

Actualizar traducción en la base de datos

Entrar en phpMyAdmin y abrir un script SQL, para pegar las siguientes sentencias sql de actualización.

Sentencias update

A tener en cuenta de cambiar el ID, en caso de que no sea el 1, por ejemplo fuera el 2

UPDATE `ps_tab_lang` SET `name`=’Objetivos’ WHERE `id_lang`=2 AND `name`=’Dashgoals’;

Entonces copiar y pegar el la ventana SQL:

UPDATE ps_tab_lang SET name='Objetivos' WHERE id_lang=1 AND name='Dashgoals';
UPDATE ps_tab_lang SET name='Inicio' WHERE id_lang=1 AND name='Dashboard';
UPDATE ps_tab_lang SET name='Ventas' WHERE id_lang=1 AND name='Sell';
UPDATE ps_tab_lang SET name='Pedidos' WHERE id_lang=1 AND name='Orders';
UPDATE ps_tab_lang SET name='Facturas' WHERE id_lang=1 AND name='Invoices';
UPDATE ps_tab_lang SET name='Vales descuento' WHERE id_lang=1 AND name='Credit Slips';
UPDATE ps_tab_lang SET name='Albaranes' WHERE id_lang=1 AND name='Delivery Slips';
UPDATE ps_tab_lang SET name='Carritos' WHERE id_lang=1 AND name='Shopping Carts';
UPDATE ps_tab_lang SET name='Catálogo' WHERE id_lang=1 AND name='Catalog';
UPDATE ps_tab_lang SET name='Productos' WHERE id_lang=1 AND name='Products';
UPDATE ps_tab_lang SET name='Categorías' WHERE id_lang=1 AND name='Categories';
UPDATE ps_tab_lang SET name='Monitoreo' WHERE id_lang=1 AND name='Monitoring';
UPDATE ps_tab_lang SET name='Atributos & Características' WHERE id_lang=1 AND name='Attributes & Features';
UPDATE ps_tab_lang SET name='Atributos' WHERE id_lang=1 AND name='Attributes';
UPDATE ps_tab_lang SET name='Características' WHERE id_lang=1 AND name='Features';
UPDATE ps_tab_lang SET name='Marcas & Proveedores' WHERE id_lang=1 AND name='Brands & Suppliers';
UPDATE ps_tab_lang SET name='Marcas' WHERE id_lang=1 AND name='Brands';
UPDATE ps_tab_lang SET name='Proveedores' WHERE id_lang=1 AND name='Suppliers';
UPDATE ps_tab_lang SET name='Archivos' WHERE id_lang=1 AND name='Files';
UPDATE ps_tab_lang SET name='Descuentos' WHERE id_lang=1 AND name='Discounts';
UPDATE ps_tab_lang SET name='Reglas de compra' WHERE id_lang=1 AND name='Cart Rules';
UPDATE ps_tab_lang SET name='Reglas de catálogo' WHERE id_lang=1 AND name='Catalog Price Rules';
UPDATE ps_tab_lang SET name='Inventario' WHERE id_lang=1 AND name='Stocks';
UPDATE ps_tab_lang SET name='Clientes' WHERE id_lang=1 AND name='Customers';
UPDATE ps_tab_lang SET name='Direcciones' WHERE id_lang=1 AND name='Addresses';
UPDATE ps_tab_lang SET name='Atención al Cliente' WHERE id_lang=1 AND name='Customer Service';
UPDATE ps_tab_lang SET name='Mensajes de pedidos' WHERE id_lang=1 AND name='Order Messages';
UPDATE ps_tab_lang SET name='Devoluciones' WHERE id_lang=1 AND name='Merchandise Returns';
UPDATE ps_tab_lang SET name='Estadísticas' WHERE id_lang=1 AND name='Stats';
UPDATE ps_tab_lang SET name='Almacenes' WHERE id_lang=1 AND name='Warehouses';
UPDATE ps_tab_lang SET name='Gestor de stock' WHERE id_lang=1 AND name='Stock Management';
UPDATE ps_tab_lang SET name='Movimiento de stock' WHERE id_lang=1 AND name='Stock Movement';
UPDATE ps_tab_lang SET name='Estado instantáneo de stock' WHERE id_lang=1 AND name='Instant Stock Status';
UPDATE ps_tab_lang SET name='Cobertura de stock' WHERE id_lang=1 AND name='Stock Coverage';
UPDATE ps_tab_lang SET name='Pedidos a Proveedores' WHERE id_lang=1 AND name='Supply orders';
UPDATE ps_tab_lang SET name='Configuración' WHERE id_lang=1 AND name='Configuration';
UPDATE ps_tab_lang SET name='Personalización' WHERE id_lang=1 AND name='Improve';
UPDATE ps_tab_lang SET name='Módulos' WHERE id_lang=1 AND name='Modules';
UPDATE ps_tab_lang SET name='Catálogo de Módulos' WHERE id_lang=1 AND name='Module Catalog';
UPDATE ps_tab_lang SET name='Selección de Módulos' WHERE id_lang=1 AND name='Module Selections';
UPDATE ps_tab_lang SET name='Gestor de Módulos' WHERE id_lang=1 AND name='Module Manager';
UPDATE ps_tab_lang SET name='Alertas' WHERE id_lang=1 AND name='Alerts';
UPDATE ps_tab_lang SET name='Actualizaciones' WHERE id_lang=1 AND name='Updates';
UPDATE ps_tab_lang SET name='Diseño' WHERE id_lang=1 AND name='Design';
UPDATE ps_tab_lang SET name='Tema & Logo' WHERE id_lang=1 AND name='Theme & Logo';
UPDATE ps_tab_lang SET name='Catálogo de Temas' WHERE id_lang=1 AND name='Theme Catalog';
UPDATE ps_tab_lang SET name='Páginas' WHERE id_lang=1 AND name='Pages';
UPDATE ps_tab_lang SET name='Posiciones' WHERE id_lang=1 AND name='Positions';
UPDATE ps_tab_lang SET name='Configuración de Imágenes' WHERE id_lang=1 AND name='Image Settings';
UPDATE ps_tab_lang SET name='Envíos' WHERE id_lang=1 AND name='Shipping';
UPDATE ps_tab_lang SET name='Transportistas' WHERE id_lang=1 AND name='Carriers';
UPDATE ps_tab_lang SET name='Preferencias' WHERE id_lang=1 AND name='Preferences';
UPDATE ps_tab_lang SET name='Pagos' WHERE id_lang=1 AND name='Payment';
UPDATE ps_tab_lang SET name='Métodos de Pago' WHERE id_lang=1 AND name='Payment Methods';
UPDATE ps_tab_lang SET name='Internacional' WHERE id_lang=1 AND name='International';
UPDATE ps_tab_lang SET name='Localización' WHERE id_lang=1 AND name='Localization';
UPDATE ps_tab_lang SET name='Idiomas' WHERE id_lang=1 AND name='Languages';
UPDATE ps_tab_lang SET name='Monedas' WHERE id_lang=1 AND name='Currencies';
UPDATE ps_tab_lang SET name='Geolocalización' WHERE id_lang=1 AND name='Geolocation';
UPDATE ps_tab_lang SET name='Localizaciones' WHERE id_lang=1 AND name='Locations';
UPDATE ps_tab_lang SET name='Zonas' WHERE id_lang=1 AND name='Zones';
UPDATE ps_tab_lang SET name='Países' WHERE id_lang=1 AND name='Countries';
UPDATE ps_tab_lang SET name='Provincias' WHERE id_lang=1 AND name='States';
UPDATE ps_tab_lang SET name='Impuestos' WHERE id_lang=1 AND name='Taxes';
UPDATE ps_tab_lang SET name='Reglas de Impuestos' WHERE id_lang=1 AND name='Tax Rules';
UPDATE ps_tab_lang SET name='Traducciones' WHERE id_lang=1 AND name='Translations';
UPDATE ps_tab_lang SET name='Configuración' WHERE id_lang=1 AND name='Configure';
UPDATE ps_tab_lang SET name='Párametros de tienda' WHERE id_lang=1 AND name='Shop Parameters';
UPDATE ps_tab_lang SET name='General' WHERE id_lang=1 AND name='General';
UPDATE ps_tab_lang SET name='Mantenimiento' WHERE id_lang=1 AND name='Maintenance';
UPDATE ps_tab_lang SET name='Pedidos' WHERE id_lang=1 AND name='Order Settings';
UPDATE ps_tab_lang SET name='Estados' WHERE id_lang=1 AND name='Statuses';
UPDATE ps_tab_lang SET name='Productos' WHERE id_lang=1 AND name='Product Settings';
UPDATE ps_tab_lang SET name='Clientes' WHERE id_lang=1 AND name='Customer Settings';
UPDATE ps_tab_lang SET name='Clientes' WHERE id_lang=1 AND name='Customers';
UPDATE ps_tab_lang SET name='Grupos' WHERE id_lang=1 AND name='Groups';
UPDATE ps_tab_lang SET name='Título' WHERE id_lang=1 AND name='Titles';
UPDATE ps_tab_lang SET name='Contacto' WHERE id_lang=1 AND name='Contact';
UPDATE ps_tab_lang SET name='Contactos' WHERE id_lang=1 AND name='Contacts';
UPDATE ps_tab_lang SET name='Tiendas' WHERE id_lang=1 AND name='Stores';
UPDATE ps_tab_lang SET name='Tráfico & SEO' WHERE id_lang=1 AND name='Traffic & SEO';
UPDATE ps_tab_lang SET name='SEO & URLs' WHERE id_lang=1 AND name='SEO & URLs';
UPDATE ps_tab_lang SET name='Buscador' WHERE id_lang=1 AND name='Search Engines';
UPDATE ps_tab_lang SET name='Referidos' WHERE id_lang=1 AND name='Referrers';
UPDATE ps_tab_lang SET name='Buscar' WHERE id_lang=1 AND name='Search';
UPDATE ps_tab_lang SET name='Parámetros Avanzados' WHERE id_lang=1 AND name='Advanced Parameters';
UPDATE ps_tab_lang SET name='Información' WHERE id_lang=1 AND name='Information';
UPDATE ps_tab_lang SET name='Rendimiento' WHERE id_lang=1 AND name='Performance';
UPDATE ps_tab_lang SET name='Administración' WHERE id_lang=1 AND name='Administration';
UPDATE ps_tab_lang SET name='Importar' WHERE id_lang=1 AND name='Import';
UPDATE ps_tab_lang SET name='Equipo' WHERE id_lang=1 AND name='Team';
UPDATE ps_tab_lang SET name='Empleados' WHERE id_lang=1 AND name='Employees';
UPDATE ps_tab_lang SET name='Perfiles' WHERE id_lang=1 AND name='Profiles';
UPDATE ps_tab_lang SET name='Permisos' WHERE id_lang=1 AND name='Permissions';
UPDATE ps_tab_lang SET name='Base de Datos' WHERE id_lang=1 AND name='Database';
UPDATE ps_tab_lang SET name='Gestor SQL' WHERE id_lang=1 AND name='SQL Manager';
UPDATE ps_tab_lang SET name='Backup BD' WHERE id_lang=1 AND name='DB Backup';
UPDATE ps_tab_lang SET name='Multitienda' WHERE id_lang=1 AND name='Multistore';
UPDATE ps_tab_lang SET name='Acceso rápido' WHERE id_lang=1 AND name='Quick Access';
UPDATE ps_tab_lang SET name='Más' WHERE id_lang=1 AND name='More';