Programmatically extending a WooCommerce Subscription

Question

I have over 30,000 users with expired WooCommerce Subscriptions that I am looking to easily extend. Is there a way that I can do this programmatically? Or a simple MySQL statement that I can run? Has anyone done this before? Any help will be greatly appreciated!

Answer 1

add_action( 'admin_init', 'change_expired_subscription_to_active' );

function change_expired_subscription_to_active() {
    $expired_subscriptions = get_posts( array( 'post_type' => 'shop_subscription', 'post_status' => 'wc-expired' ) );
    if(!empty(expired_subscriptions)){
      foreach ( $expired_subscriptions as $post ) {
        update_post_meta( $post->ID, '_requires_manual_renewal', true );
        wp_update_post( array( 'ID' => $post->ID, 'post_status' => 'wc-active' ) );
    }
  }
}

Try this code