Urls of All Products

[calvis]

What is the easiest way to find all the urls of all products in a store? (not custom urls)

I am not finding anything useful in the databases.

[mazhar]

Well you don't see anything in database becuase Url is a calculated field. I think the easiest way to find all URLs is to write small peice of code to load all products and then export their URLs in CSV. Here is small test sample. Extract and upload the page to root of your website and then visit this page. You need to click export button on this page and it will let you download CSV file with productid, name and URL in it.

[calvis]

What a sweet piece of code. Works perfect.

Thanks,

Mazhar