Best way to export user, orders, and customer data for re-import on a new site?

https://www.google.com/search?q=woocommerce+how+to+export+customers+and+orders

First thing first.
Make a 2 backups and when I mean backups, I mean really offsite backup using a tool like duplicator pro or updraft etc etc.

Next you need access to PHPADMIN.

In addition do you know how to append tables in the database ?

YOU NEED TO BE VERY CAREFUL.

But this is a huge job to be done right because there are many many tables and it is just not the obvious tables you need, but you need others as well, that are not going to be obvious for you

Users and User-Related Data
wp_users: Stores core user information (username, password, email).

wp_usermeta: Stores additional user metadata, including WooCommerce-specific data like billing and shipping addresses

Customer Orders
wp_posts: This table stores the orders themselves as a custom post type (shop_order).

wp_postmeta: This table stores metadata for each order, such as billing and shipping information, order totals, and other order-specific data.

Customer Data
wp_users: This table stores user data, such as usernames, passwords, and email addresses.

Customers who create accounts are stored here.

wp_usermeta: This table stores metadata for users, including WooCommerce-specific data like billing and shipping addresses

Order Items
wp_woocommerce_order_items: This table stores individual items within an order.

wp_woocommerce_order_itemmeta: This table stores metadata for each item within an order, such as product IDs, quantities, and item-specific details.

Other Associated Tables
wp_woocommerce_payment_tokens: This table stores payment tokens for customers, which are used for saved payment methods.

wp_woocommerce_payment_tokenmeta: This table stores metadata for payment tokens.

wp_woocommerce_sessions: This table stores session data for customers, including cart contents before an order is placed.

wp_woocommerce_api_keys: This table stores API keys for WooCommerce, used for integrations and third-party applications.

wp_woocommerce_downloadable_product_permissions:
This table stores permissions for downloadable products, such as links and access rights for digital downloads.

wp_woocommerce_tax_rates: This table stores tax rate data.

wp_woocommerce_tax_rate_locations: This table stores the locations to which specific tax rates apply
.
wp_woocommerce_shipping_zones: This table stores shipping zones.

wp_woocommerce_shipping_zone_locations: This table stores locations within shipping zones.

wp_woocommerce_shipping_zone_methods: This table stores shipping methods within shipping zones.

wp_woocommerce_attribute_taxonomies: This table stores attribute taxonomies for products.

wp_woocommerce_termmeta: This table stores metadata for product terms (categories, tags, and attributes).

Surprised nobody’s asked if any of these are subscription orders – these get tricky to migrate. WP All Import & WP All Export with the woocommerce add on, great a migration orders, and users etc. subscriptions, these can be tricky. Historically, I’ve found the best way to migrate subscriptions is to clone the site, stop it down of its garbage and build a new. There are a few other ways to migrate subscriptions, but this is a simple way to ensure the recurring payments don’t get screwed up.