# List recent orders — WooCommerce WP-CLI commands
wp wc shop_order list --status=processing --per_page=20 --user=1

# Get a specific order as JSON
wp wc shop_order get 12345 --user=1 --format=json

# Update order status with WooCommerce WP-CLI commands
wp wc shop_order update 12345 --status=completed --user=1

# Count orders by status — useful for WooCommerce WP-CLI commands dashboards
wp wc shop_order list --status=on-hold --format=count --user=1

# Bulk export orders to CSV
wp wc shop_order list --per_page=100 --format=csv > orders-export.csv

# Delete test orders in bulk using WooCommerce WP-CLI commands
wp wc shop_order list --status=pending --per_page=50 --format=ids --user=1 
  | xargs -I{} wp wc shop_order delete {} --force=true --user=1

# List all published products
wp wc product list --status=publish --per_page=100 --user=1

# Create a product with WooCommerce WP-CLI commands
wp wc product create 
  --name="Test Product" 
  --type=simple 
  --regular_price=19.99 
  --status=publish 
  --user=1

# Update product price in bulk using WooCommerce WP-CLI commands
for id in $(wp wc product list --category=12 --format=ids --user=1); do
  wp wc product update $id --regular_price=24.99 --user=1
done

# Search products by SKU
wp wc product list --sku=SKU-001 --user=1

# Delete all draft products with WooCommerce WP-CLI commands
wp wc product list --status=draft --format=ids --user=1 
  | xargs -I{} wp wc product delete {} --force=true --user=1

# List all available tools
wp wc tool list --user=1

# Clear transients with WooCommerce WP-CLI commands
wp wc tool run clear_transients --user=1

# Recount product stock with WooCommerce WP-CLI commands
wp wc tool run recount_terms --user=1

# Create missing WooCommerce pages
wp wc tool run install_pages --user=1

# Clear customer sessions — useful WooCommerce WP-CLI commands for session bloat
wp wc tool run clear_sessions --user=1

# System status — show server environment for WooCommerce WP-CLI commands debugging
wp wc system_status --user=1 --format=json

# Check HPOS migration status
wp wc hpos verify-order-data --all --user=1

<?php
// Register custom WooCommerce WP-CLI commands in your plugin
if ( defined( 'WP_CLI' ) && WP_CLI ) {
    WP_CLI::add_command( 'wc-mystore', 'CAZ_WC_CLI_Commands' );
}

class CAZ_WC_CLI_Commands {

    /**
     * Sync all product prices from the ERP
     *
     * ## OPTIONS
     * [--dry-run]
     * : Preview changes without saving
     *
     * ## EXAMPLES
     * wp wc-mystore sync-prices
     * wp wc-mystore sync-prices --dry-run
     *
     * @subcommand sync-prices
     */
    public function sync_prices( array $args, array $assoc_args ): void {
        $dry_run = WP_CLIUtilsget_flag_value( $assoc_args, 'dry-run', false );
        WP_CLI::log( 'Starting price sync WooCommerce WP-CLI commands...' );
        $count = 0;
        $products = wc_get_products([ 'limit' => -1, 'return' => 'ids' ]);
        $progress = WP_CLIUtilsmake_progress_bar( 'Syncing', count( $products ) );

        foreach ( $products as $id ) {
            // fetch price from ERP...
            $new_price = '19.99'; // replace with real ERP call
            if ( ! $dry_run ) {
                $p = wc_get_product( $id );
                $p->set_regular_price( $new_price );
                $p->save();
            }
            $count++;
            $progress->tick();
        }

        $progress->finish();
        WP_CLI::success( "WooCommerce WP-CLI commands: synced {$count} products." . ( $dry_run ? ' (dry run)' : '' ) );
    }

    /**
     * Export order report as CSV
     * @subcommand export-orders
     */
    public function export_orders( array $args, array $assoc_args ): void {
        $status = $assoc_args['status'] ?? 'completed';
        $orders = wc_get_orders([ 'status' => $status, 'limit' => -1 ]);
        $file   = 'orders-' . $status . '-' . date('Y-m-d') . '.csv';
        $fp     = fopen( $file, 'w' );
        fputcsv( $fp, ['ID','Status','Total','Date','Customer'] );
        foreach ( $orders as $order ) {
            fputcsv( $fp, [
                $order->get_order_number(),
                $order->get_status(),
                $order->get_total(),
                $order->get_date_created()->date('Y-m-d'),
                $order->get_billing_email(),
            ]);
        }
        fclose( $fp );
        WP_CLI::success( "WooCommerce WP-CLI commands: exported to {$file}" );
    }
}