How can I download my store product links

[Ruu]

Hi all

 

Im trying to download my store product links.

Is SQL my best option, if so which file is best suited for this task.

This would give me direct link to each product etc mystore.com/45-rednikehoppers

 

thanks

[parsifal]

Hi Ruu.

 

You could start with an SQL query like the following:

 

SELECT
	CONCAT('http://mystore.com/', `id_product`, '-', `link_rewrite`) AS url
FROM
	ps_product_lang
;

It may need tweaking, depending on your particular setup (e.g. you are using more than one languages in your eshop etc.)