Export URL and sku only

Hello,

I have access to the backend and database to this site.

What is the best way to export just the URL and sku?

For example, I need it just like this:

A1234;http://www.domain.com/90-Mile-Stretc...ods-100ct.html
B5678;http://www.domain.com/Chickadee-Medium-Roast-16oz.html

I have search for quite some time and cannot find a definitive answer to which tables these are in. I can then export from mySQL.

Help.

Thanks

You can use this tutorials to get out all of product and get attributes to export. Or simply save to csv file on server.

http://magentoexpertforum.com/showth...-functionality