WooCommerce is the most popular eCommerce plugin for WordPress. It stores product data in the WordPress database. Here's a basic overview of how it organizes that data:

• Posts Table (`wp_posts`): WooCommerce uses the WordPress `wp_posts` table to store products. Each product is stored as a custom post type called `product`. This allows products to leverage WordPress's built-in post management features.
• Post Meta Table (`wp_postmeta`): Additional product information, such as price, SKU, stock status, and custom fields, is stored in the `wp_postmeta` table. Each piece of metadata is associated with a product via its post ID.
• Taxonomy Tables: WooCommerce uses WordPress's taxonomy system to manage product categories and tags. Product categories are stored in the `wp_terms`, `wp_term_taxonomy`, and `wp_term_relationships` tables.

• Basic product information (title, description, etc.) is stored in the `wp_posts` table.
• Product-specific metadata (like price, weight, dimensions, etc.) are stored in the `wp_postmeta` table and have keys that begin with `_`, such as `_price`, `_sku`, `_stock`, and so on.

WooCommerce may also create additional tables for certain features, such as managing product attributes or orders, depending on the version and any extensions or customizations in use. It is also the case for plugins that add a new search engine to the products database.

For variable (or digital and download) products, the structure includes parent products (grouped products) and their variations, which also have their own records in the `wp_posts` table and are linked through the `wp_postmeta` table.

You can directly export products data to a CSV files from WooCommerce>Products in your e-commerce dashboard.

All Woocommerce documentations: https://woocommerce.com/