Woocommerce Question posted in
The official Woocommerce documentation can be found here.

Delete WooCommerce coupons 30 days after they expire

I have the following function, which deletes WooCommerce coupons on the day they expire.

How do you make it delete them 30 days after their expiry date instead?

function delete_expired_coupons() {
  $args = array(
    'posts_per_page' => -1,
    'post_type'      => 'shop_coupon',
    'post_status'    => 'publish',
    'meta_query'     => array(
      'relation'   => 'AND',
      array(
        'key'     => 'date_expires',
        'value'   => current_time( 'timestamp' ),
        'compare' => '<='
      ),
      array(
        'key'     => 'date_expires',
        'value'   => '',
        'compare' => '!='
      )
    )
  );

  $coupons = get_posts( $args );

  if ( ! empty( $coupons ) ) {
    foreach ( $coupons as $coupon ) {
      wp_trash_post( $coupon->ID );
    }
  }
}
add_action( 'delete_expired_coupons', 'delete_expired_coupons' );
Tags:

2

Answers


  1. 0

    Can you please try this code

    function wp_delete_expired_coupons() {
    $args = array(
        'posts_per_page' => -1,
        'post_type'      => 'shop_coupon',
        'post_status'    => 'publish',
        'meta_query'     => array(
            'relation'   => 'AND',
            array(
                'key'     => 'expiry_date',
                'value'   => current_time( 'Y-m-d' ),
                'compare' => '<='
            ),
            array(
                'key'     => 'expiry_date',
                'value'   => '',
                'compare' => '!='
            )
        )
    );

    $coupons = get_posts( $args );

    if ( ! empty( $coupons ) ) {
        <!-- $current_time = current_time( 'timestamp' ); -->

        foreach ( $coupons as $coupon ) {
            wp_trash_post( $coupon->ID );
        }
    }
}
add_action( 'delete_expired_coupons', 'wp_delete_expired_coupons' );
    Login or Signup to reply.
  2. 0

    You have to compare the current date with the past 30 days date. check the below code.

    function delete_expired_coupons() {

    $args = array(
        'posts_per_page' => -1,
        'post_type'      => 'shop_coupon',
        'post_status'    => 'publish',
        'meta_query'     => array(
            'relation'   => 'AND',
            array(
                'key'     => 'date_expires',
                'value'   => strtotime( '-30 days', current_time( 'timestamp' ) ),
                'compare' => '<='
            ),
            array(
                'key'     => 'date_expires',
                'value'   => '',
                'compare' => '!='
            )
        )
    );

    $coupons = get_posts( $args );

    if ( ! empty( $coupons ) ) {
        foreach ( $coupons as $coupon ) {
            wp_trash_post( $coupon->ID );
        }
    }
    
}
add_action( 'delete_expired_coupons', 'delete_expired_coupons' );
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search