Delete old (not current year) WooCommerce shop orders

wc-delete-old-shop-orders.sql

DELETE
FROM wp_postmeta
WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'shop_order' AND YEAR(post_date) != YEAR(NOW()));

DELETE
FROM wp_commentmeta
WHERE comment_id IN (SELECT comment_ID
                     FROM wp_comments
                     WHERE comment_post_id IN
                           (SELECT ID FROM wp_posts WHERE post_type = 'shop_order' AND YEAR(post_date) != YEAR(NOW()))
);

DELETE
FROM wp_comments
WHERE comment_post_id IN
      (SELECT ID FROM wp_posts WHERE post_type = 'shop_order' AND YEAR(post_date) != YEAR(NOW()));

DELETE
FROM wp_woocommerce_order_itemmeta
WHERE order_item_id IN
      (SELECT order_item_id
       FROM wp_woocommerce_order_items
       WHERE order_id IN
             (SELECT ID
              FROM wp_posts
              WHERE post_type = 'shop_order'
                AND YEAR(post_date) != YEAR(NOW())));

DELETE
FROM wp_woocommerce_order_items
WHERE order_id IN
      (SELECT ID
       FROM wp_posts
       WHERE post_type = 'shop_order'
         AND YEAR(post_date) != YEAR(NOW()));

DELETE
FROM wp_wcpdf_invoice_number
WHERE order_id IN
      (SELECT ID
       FROM wp_posts
       WHERE post_type = 'shop_order'
         AND YEAR(post_date) != YEAR(NOW()));

DELETE
FROM wp_posts
WHERE post_type = 'shop_order'
  AND YEAR(post_date) != YEAR(NOW());