Use this plugin and it’s add-ons:

Login: https://www.wpallimport.com/portal/

Downloads: https://www.wpallimport.com/portal/downloads/

You’ll need:

WP All Import Pro

WP All Export Pro

WooCommerce Export Add-On Pro

WooCommerce Import Add-On Pro

If the live site has ACFs on the products you’ll need the ACF add-ons as well ACF Import Add-On Pro, ACF Export Add-On Pro

Documentation – Importing Products: https://www.wpallimport.com/documentation/how-to-import-woocommerce-products/

Documentation – Exporting Products: https://www.wpallimport.com/documentation/how-to-export-woocommerce-products-to-csv-or-xml/