dedeziel Posted December 2, 2011 Share Posted December 2, 2011 I have looked through the forums pretty extensively and cannot find a solved thread or module that can help with this. Is there any way at all either in the BO or through a database to export the product URLS. I need to update our Google Adwords landing URLS and if I have an export of the product URLS it will help with this and a few other things. Link to comment Share on other sites More sharing options...
OC2PS Posted December 2, 2011 Share Posted December 2, 2011 You may want to export directly from the database. Log into your MySQL, go to the SQL tab and run a query like SELECT `name` , `link_rewrite` , `id_product` FROM `ps_product_lang` ; (of course, things are a bit more complex in real life due to multiple languages, categories, etc) Then click on export and export to an MS Excel file. Open the file and you will see a list of product names, with URL stubs next to them. You can easily create URL from this info, e.g. by putting the formula =CONCATENATE("www.yoursite.com/prestashop/",C1,"-",B1) in cell D1 And then you can just copy this down all the way to the last product 1 Link to comment Share on other sites More sharing options...
dedeziel Posted December 7, 2011 Author Share Posted December 7, 2011 with a couple of quick mods I was able to get exactly what I wanted using your method OC2! Thanks a ton saved me a butt load of time Link to comment Share on other sites More sharing options...
Mike Kranzler Posted December 7, 2011 Share Posted December 7, 2011 Thanks OC2PS! I'll go ahead and mark this as solved for you. -Mike Link to comment Share on other sites More sharing options...
Recommended Posts