If you want to get all the WooCommerce products ready to be saved into a CSV / Excel file run the following query:

 

SELECT ID, post_status, post_title, post_content, post_excerpt, guid  FROM `wp_posts` WHERE (`post_status` = 'publish' OR `post_status` = 'draft') AND `post_type` = 'product' ORDER BY `ID` ASC