If the product does not have the "_price" meta key, remove the product

user_18681609 0
Viewed 34

I have created code as below and the focus part is PM.meta_key !='_price' and I don't know how true it is, it didn't work but it's also possible to remove all products otherwise, I need a correct way.

Also here is a picture, some products don't have the "_price" key and this way the product looks very bad, the strange thing is that they are still in stock.

Here is an example photo.

Example, this product does not have the "_price" key

add_action( 'init', 'automatically_trash_instock_empty_price' );
  function automatically_trash_instock_empty_price() {
              
    // Get any existing copy of our transient data
    if ( false === ( $automatically_trash_instock_empty_price = get_transient( 'automatically_trash_instock_empty_price' ) ) ) {
        
        // It wasn't there, so regenerate the data and save the transient
        global $wpdb;
        $wpdb->query( "UPDATE {$wpdb->posts} P JOIN {$wpdb->postmeta} PM ON P.ID = PM.post_id SET P.post_status='trash' WHERE P.post_type='product' and PM.meta_key != '_price'" );

        set_transient( 'automatically_trash_instock_empty_price', true, 1 * HOUR_IN_SECONDS );
    }
}
woocommerce wordpress mysql
1 Answers

I know you asked for MySQL query but why not use native functions for this? You can query all your products and foreach create a product object using the following function:

$product = wc_get_product( $post_id );

And after that you will be able to access all product's data. All available methods can be found here, but the ones you probably need are:

$product->get_regular_price();
$product->get_sale_price();
$product->get_price();

Then check if $product->get_price(); is null, empty and/or zero and just:

wp_trash_post($product->get_id());

Trash post doc

Finally, you could also set this up as a cron job to run daily/weekly and clean up your products regularly.

EDIT

As per your comments here is a full working example of a scheduled function via wp-cron to do what you asked regularly:

 // Your scheduled function
function trash_products_without_price_stock() {
    $get_all = new WP_Query(
        array(
            'post_type'      => 'product',
            'posts_per_page' => -1,
        )
    );
    if ( $get_all->have_posts() ) :
        while ( $get_all->have_posts() ) :
            $get_all->the_post();
            // Start : Your conditionals here
            if ( ! get_post_meta( get_the_ID(), '_price', true ) && get_post_meta( get_the_ID(), '_stock', true ) ) {
                wp_trash_post( get_the_ID() );
            }
            // End
        endwhile;
        wp_reset_postdata();
    endif;
}
 
// Schedule Cron Job Event
if ( ! wp_next_scheduled( 'clean_my_products' ) ) {
    // here you can use 'hourly', 'twicedaily', 'daily', and 'weekly'
    wp_schedule_event( time(), 'daily', 'clean_my_products' );
}
add_action( 'clean_my_products', 'trash_products_without_price_stock' );

Put the above in functions.php

user_53971170
Related