SergioE Posted January 23, 2016 Share Posted January 23, 2016 (edited) Buenas, me gustaría saber si hay alguna forma ya sea desde back office de prestashop o mediante una consulta sql, para exportar todas las url's amigables de los productos que actualmente hay en la tienda. He visto esta web pero esa consulta no funciona; http://www.sistemasolutions.com/sql-url-prestashop/ Gracias Edited January 27, 2016 by SergioE (see edit history) Link to comment Share on other sites More sharing options...
ventura Posted January 23, 2016 Share Posted January 23, 2016 (edited) Seria algo asi SELECT CONCAT( 'http://midominio.com/', cl.`link_rewrite` , '/', pl.`link_rewrite` , '-', p.`id_product` , '.html' ) AS ProductURL FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON pl.`id_product` = p.`id_product` LEFT JOIN `ps_category_lang` cl ON cl.`id_category` = p.`id_category_default` GROUP BY p.`id_product` Edited January 23, 2016 by ventura (see edit history) 1 Link to comment Share on other sites More sharing options...
SergioE Posted January 24, 2016 Author Share Posted January 24, 2016 Perfecto, lo que no me sale la url completa, se queda a la mitad con 3 puntos (http://midominio.com/categoria...) Como hago para que se vea toda la URL y pueda copiarlas todas o exportarlas? Gracias ventura! Link to comment Share on other sites More sharing options...
SergioE Posted January 26, 2016 Author Share Posted January 26, 2016 Nada? Link to comment Share on other sites More sharing options...
SergioE Posted January 26, 2016 Author Share Posted January 26, 2016 uP! Link to comment Share on other sites More sharing options...
ventura Posted January 26, 2016 Share Posted January 26, 2016 Con la configuracion de enlace de productos que viene por defecto y la query que te puse en el primer mensaje. Link to comment Share on other sites More sharing options...
SergioE Posted January 27, 2016 Author Share Posted January 27, 2016 A mi no me sale la url entera, a partir de la categoria se corta y muestra ... , nada mas. Luego como exporto la lista en un csv por ejemplo ? Link to comment Share on other sites More sharing options...
ventura Posted January 27, 2016 Share Posted January 27, 2016 A mi no me sale la url entera, a partir de la categoria se corta y muestra ... , nada mas. Luego como exporto la lista en un csv por ejemplo ? SQL Manager -> Consulta SQL | Exportar Link to comment Share on other sites More sharing options...
SergioE Posted January 27, 2016 Author Share Posted January 27, 2016 Gracias! Link to comment Share on other sites More sharing options...
juanrojas Posted May 9, 2017 Share Posted May 9, 2017 y cuando se trata de multiidioma? no me esta saliendo el prefijo del idioma /es/ /en/ Link to comment Share on other sites More sharing options...
SergioE Posted May 9, 2017 Author Share Posted May 9, 2017 Como pones la consulta? Link to comment Share on other sites More sharing options...
juanrojas Posted May 9, 2017 Share Posted May 9, 2017 SELECT CONCAT( 'http://midominio.com/de/' cl.`link_rewrite` , '/', pl.`link_rewrite` , '-', p.`id_product` , '.html' ) AS ProductURL FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON pl.`id_product` = p.`id_product` LEFT JOIN `ps_category_lang` cl ON cl.`id_category` = p.`id_category_default` GROUP BY p.`id_product` he visto que funciona si marco la opcion que dice "Ocultar transformación del navegador " funciona para español, ingles, pero para aleman no funciona, me sigue dando la url en español Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now