The default WooCommerce frontend product search returns results based on whether the search term is present in the product title, SKU, short and long description.
But what if you also want to search inside a custom field i.e. you have a custom field called “_brand” and you also want to search by “_brand”?
Now, I’m not sure I’ve explained this in plain English, so let’s take a look at a practical example. Enjoy!
PHP Snippet: Search Products By Custom Field Value @ WooCommerce Search
The only thing you need to change in the snippet below is ‘_brand‘. Change it to the key of your custom field, and you should get results based on that. Let me know in the comments if it works!
/**
* @snippet Search By Custom Field @ WooCommerce Search
* @how-to Get CustomizeWoo.com FREE
* @author Rodolfo Melogli
* @compatible WooCommerce 6
* @donate $9 https://businessbloomer.com/bloomer-armada/
*/
add_filter( 'posts_search', 'bbloomer_product_search_by_custom_field' );
function bbloomer_product_search_by_custom_field( $where ) {
global $wpdb, $wp;
if ( is_admin() || ! is_search() || ! isset( $wp->query_vars['s'] ) || 'product' != $wp->query_vars['post_type'] ) {
return $where;
}
$product_ids = array();
$terms = explode( ',', $wp->query_vars['s'] );
foreach ( $terms as $term ) {
$products = $wpdb->get_results( $wpdb->prepare( "SELECT ID, post_parent FROM {$wpdb->posts} LEFT JOIN {$wpdb->postmeta} ON {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id WHERE meta_key IN ( '_brand' ) AND meta_value LIKE %s;", '%' . $wpdb->esc_like( wc_clean( $term ) ) . '%' ) );
$products = array_merge( wp_list_pluck( $products, 'ID' ), wp_list_pluck( $products, 'post_parent' ) );
if ( sizeof( $products ) > 0 ) {
$product_ids = array_merge( $product_ids, $products );
}
}
$product_ids = array_filter( array_unique( array_map( 'absint', $product_ids ) ) );
if ( sizeof( $product_ids ) > 0 ) {
$where = str_replace( 'AND (((', "AND ( ({$wpdb->posts}.ID IN (" . implode( ',', $product_ids ) . ")) OR ((", $where );
}
return $where;
}
Was this article helpful?
YesNo
thanks this worked for me. So, is it possible to add more than one meta field to this structure?
Hello Mehmet, thanks so much for your comment! Yes, this is definitely possible, but I’m afraid it’s custom work. If you’d like to get a quote, feel free to contact me here. Thanks a lot for your understanding!
Hi there,
When I use your code in a Code Snippet, it generates a warning in the logs:
Any suggestions to improve this code?
Kind regards,
Marc
I don’t see any “post_type” array key in my snippet, so this may be because of something else (a plugin or theme)