Webentwickler Blog

DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');
  
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
DELETE FROM wp_posts WHERE post_type = 'product';

/* change default from eamil worpdress */
function change_my_from_address( $original_email_address ) {
    return 'jobs@droidcon.com';
}
add_filter( 'wp_mail_from', 'change_my_from_address' );

// Function to change sender name
function change_my_sender_name( $original_email_from ) {
    return 'droidcon';
}
add_filter( 'wp_mail_from_name', 'change_my_sender_name' );

add_filter( 'wp_nav_menu_items', 'ag_dynamic_menu_item_label', 9999, 2 );

function ag_dynamic_menu_item_label( $items, $args ) {
    if ( ! is_user_logged_in() ) {
        $items = str_replace( "Mein Konto", "Login", $items );
    }
    if( is_user_logged_in() ){

        $items =str_replace( "Mein Konto", "Hallo " . wp_get_current_user()->user_firstname, $items);
    }
    return $items;
}

add_action( 'admin_footer', 'disable_backorder_option_from_product_settings' );
function disable_backorder_option_from_product_settings() {
    global $pagenow, $post_type;

    if( in_array( $pagenow,  array('post-new.php', 'post.php') ) && $post_type === 'product' ) :
    ?>
    <script>
    jQuery(function($){
        // For product variations
        $('#variable_product_options').on('change', function(){
            $('select[name^=variable_backorders]').each( function(){
                $(this).prop('disabled','disabled').val('no');
            });
        });
        // For all other product types
        $('select#_backorders').prop('disabled','disabled').val('no');
    });
    </script>
    <?php
    endif;
}

add_filter( 'woocommerce_product_backorders_allowed', '__return_false', 1000 );
add_filter( 'woocommerce_product_backorders_require_notification', '__return_false', 1000 );

add_filter( 'woocommerce_product_get_backorders', 'get_backorders_return_no' );
add_filter( 'woocommerce_product_variation_get_backorders', 'get_backorders_return_no' );
function get_backorders_return_no( $backorders ){
    return 'no';
}

add_filter( 'woocommerce_product_get_stock_status', 'filter_product_stock_status', 10, 2 );
add_filter( 'woocommerce_product_variation_get_stock_status', 'filter_product_stock_status', 10, 2 );
function filter_product_stock_status( $stock_status, $product ){
    return $product->get_stock_quantity() <= 0  ? 'outofstock' : $stock_status;
}