0

Good morning, i'm trying to extend backend product search by using this function without success.

This snippet works only in Title and i need to add also in Metakey SKU.

I have tried extend by using post_join and post_where as in this example https://codex.wordpress.org/Plugin_API/Filter_Reference/posts_join but i'm not expert on queries.

Please anyone can help me ? Thanks in advance.

function __search_by_title_only( $where, &$wp_query )
{
    global $wpdb,$typenow,$pagenow;

    if ( 'product' === $typenow && isset( $_GET['s'] ) && 'edit.php' === $pagenow ) {
        $search_ids = array();
        $terms      = explode( ' ', $_GET['s'] );

        foreach ( $terms as $term ) {
                if ( is_numeric( $term ) ) {
                    $search_ids[] = $term;
                }

                if ( $search_term = $_GET['s'] ) {
                    $where .= ' AND ' . $wpdb->posts . '.post_title LIKE \'%' . esc_sql( like_escape( $term ) ) . '%\'';
                }

        }
        return $where;  
    }
}
add_filter('posts_search', '__search_by_title_only', 500, 2);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.