How to Delete Products from WooCommerce Shop After Specific Time Period

WooCommerce users often require a functionality using which products can be made available on the shop page for a specific time duration. After the specific time duration has passed by there should be a functionality to auto delete products. 

When would you need to Delete Products from WooCommerce? 

Such a requirement could arise for a subscription-based multi-vendor site. So, for example, you have a multi-vendor WooCommerce website. Vendors can sell their products from your website by subscribing to various packages that might be available on your site. But what happens after a particular vendor’s subscription expires?? The vendor should now not be able to continue selling any products from your website. For this purpose, there would be a need to either delete products from shop page or save it as a draft to be accessed later from the dashboard.

Steps to Automatically Delete Products from WooCommerce Shop

So, the question still remains is how are we going to delete products from the shop page after a particular time interval. This process would involve the following three steps.

Step 1: Set Time After which a Product should be Deleted

• The foremost step would be to set a time duration after which system should delete products. This step will be implemented at the time of adding a product to the shop page.
• The code for this will be written in a function that will be called on the ‘wp_insert_code’ hook. The code to set the time will be as below.

function set_delete_product_meta($id) {
global $wpdb,$current_user;
$posttype = get_post_type($id);
if ( $posttype =='revision' )
   return;
   if($posttype=='product')
   {
        $val=get_post_meta( $id, 'wdm_set_expiry',true);
             if($val!=1)
             {
                $month     = date('m');
                $day      = date('d')+X;
                $year      = date('Y');
                $hour      = date('H');
                $minute  =date('i');        
                $dt = get_gmt_from_date("$year-$month-$day $hour:$minute:0",'U');
                $vars = $id;
                wdm_delete_product($dt,$id,$vars);
                update_post_meta($id,'wdm_set_expiry',1);
             }
    }
    else
    return;
}
add_action('wp_insert_post','set_delete_product_meta');

• The variable ‘X’ on line 12 should be replaced with the actual duration after which you want the product to be removed from the shop page.

Step 2: Schedule a Cron Job for Product Deletion

• Now that the time after which product should be deleted from shop page has been set the next step would be to schedule a cron job to actually initiate the deletion process after the set time.
• In this step it will first be checked if a cron job has been already scheduled for the product. If it has been done then no change will be made to the scheduled time of the existing cron job.
• In the above code a call has been made to the function ‘wdm_delete_product’ on line 18. It is this function that will actually schedule the cron job and we will need the code below to achieve this functionality.

function wdm_delete_product($remove_date,$id,$vars) {
    if (wp_next_scheduled('wdm_remove_product',array($id)) !== false) 
        wp_clear_scheduled_hook('wdm_remove_product',array($id));
        wp_schedule_single_event($ts,'wdm_remove_product',array($id));
        // Update Post Meta
        update_post_meta($id, 'wdm_product_remove_date', $remove_date);
        update_post_meta($id, 'wdm_product_remove_date-value', $vars);
}

Ensure that the Cron Job Runs as Expected

• As you might already know, the wp-cron.php triggers crons on your WordPress website. But this file does not always execute as expected. It only executes when someone visits your site. And this could be a problem.
• Due to the inefficiency of the WP cron, it may happen that the cron you’ve set to delete a product might not get executed as expected.
• So, to ensure that the cron gets executed, you could use a service like EasyCron
• The EasyCron service ensures that the wp-cron.php executes on a timely basis, thus it will ensure that the ‘wdm_delete_product’ function is called, and the products scheduled to be removed from the store, are deleted.

[space]

Step 3: Delete Products after Set Time has Passed By

• Now that the deletion process has been initiated it would require us to add a function which will delete products from the shop page after the deletion process has been initiated.
• As you can see in the code above a function ‘wdm_remove_product’ has been called. This function will carry out the deletion of products from the shop page and will be called on the ‘wdm_remove_product’ hook that has been defined in the ‘wdm_delete_product’ function defined in step two.

function wdm_remove_product($id){
         global $wpdb;
         if (empty($id)){ 
            return false;
         }
         if (is_null(get_post($id))){
            return false;
         }
         $pr_value = get_post_meta($id,'wdm_product_remove_date-value',true);
         // wp_delete_post($pr_value) ; //This will delete product
         $wpdb->query("Update $wpdb->posts set post_status='draft' where ID='$id'");// Change status to draft
}
add_action('wdm_remove_product','wdm_remove_product');