Generate list of WooCommerce variable products.

list-variable-products.php

<?php
/*
Plugin Name: List Variable Products
Plugin URI: https://www.philwylie.co.uk/
Description: Generate list of WooCommerce variable products.
Version: 1.0.0
Author: Phil Wylie
Author URI: https://www.philwylie.co.uk/
License: GPL2
*/

/**
 * Class PW_List_Variable_Products.
 */
class PW_List_Variable_Products {

	/**
	 * Initialize the plugin by hooking into WordPress.
	 */
	public function __construct() {
		add_action( 'init', array( $this, 'generate_list' ) );
	}

	/**
	 * Hit example.com/?export-products. Use at your own risk. Backup first!
	 */
	public function generate_list() {
		if ( ! isset( $_GET['export-products'] ) ) {
			return;
		}

		$args  = array(
			'posts_per_page' => '-1',
			'post_type'      => 'product',
			'tax_query' => array(
				array(
					'taxonomy' => 'product_type',
					'field'    => 'slug',
					'terms'    => 'variable',
				),
			),
			'no_found_rows'  => true,
			'cache_results'  => false,
		);
		$posts = new WP_Query( $args );
		if ( $posts->have_posts() ) {
			foreach ( $posts->posts as $post ) {
				echo get_permalink( $post->ID ) . "\n";
			}
		}

		echo 'Done.';
		exit;
	}
}
new PW_List_Variable_Products();