Need to export Products with their URLs

Hi!
for Google Merchant Center I need to export all the products with their URLs also. Is it possible to do it? If the export function has not this functionality, is it possible to get it from Database maybe?

Second usage of this functionality is when someone is creating a new post (by submission form) is there a way to get the URL from this post from Database?

would be happy to hear from you!
Lukas

Replies are visible only to logged in members with an active subscription.