Jump to content

[SOLVED] Export Product URLS


Recommended Posts

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

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

  • Like 1
Link to comment
Share on other sites

×
×
  • Create New...