How does WooCommerce store customer data?

Go to your WooCommerce dashboard and click "Analytics" which will open the overview page. You can filter the details by choosing the date range first. Then below is the "Performance section" click on the 3 dots menu on the right side to choose what you want to see. Click "orders" and you'll see all the orders during that period.

WooCommerce does not have a separate table to store customer data, so the plugin uses WordPress and its custom tables to store the data. Hence, the data is stored in different databases making retrieval quite challenging.

By default, the customers abandoned cart data gets stored by WooCommerce, regardless of whether the customer is a new or already an existing member. To extract customer data, you need to refer to each order. The orders are stored in the wp_posts database table.