Lotus theme SQL data export assistance required

We have inherited site A ( standard WordPress build) with all product items we need to export built in a “product tab” in a theme called “Lotus we think was bought from Theme forest”, the client has now outgrown this theme.

We need to take the data of each product – Name, description, price, media file, url, etc and get that into a csv to import into site B with a different theme that we intend to run Woo commerce as a catalogue to manage the products.

We have found the Woo commerce csv importer plugin for site B so that looks fine.

We have webmin access to server to get to the SQL files and folders and also RDP access so can get to any files anywhere.

Do we need to export the SQL to access the build the relationships of the tables or is there a plugin anyone has seen that will do it?

The question is how do we extract the data from the original site A into csv format?, any ideas would be really helpful and very gratefully received.