Try to add the following PHP code snippet to the child theme functions.php file to fix this
function woodmart_sku_search_query_new( $where, $s ) {
global $wpdb;
$search_ids = array();
$terms = explode( ',', $s );
foreach ( $terms as $term ) {
//Include the search by id if admin area.
if ( is_admin() && is_numeric( $term ) ) {
$search_ids[] = $term;
}
// search for variations with a matching sku and return the parent.
$sku_to_parent_id = $wpdb->get_col( $wpdb->prepare( "SELECT p.post_parent as post_id FROM {$wpdb->posts} as p join {$wpdb->wc_product_meta_lookup} ml on p.ID = ml.product_id and ml.sku LIKE '%%%s%%' where p.post_parent <> 0 group by p.post_parent", wc_clean( $term ) ) );
//Search for a regular product that matches the sku.
$clean_term = wc_clean( $term );
$sku_to_id = $wpdb->get_results( "SELECT product_id FROM {$wpdb->wc_product_meta_lookup} WHERE sku LIKE '%{$clean_term}%';", ARRAY_N );
$sku_to_id_results = array();
if ( is_array( $sku_to_id ) ) {
foreach ( $sku_to_id as $id ) {
$sku_to_id_results[] = $id[0];
}
}
$search_ids = array_merge( $search_ids, $sku_to_id_results, $sku_to_parent_id );
}
$search_ids = array_filter( array_map( 'absint', $search_ids ) );
if ( sizeof( $search_ids ) > 0 ) {
$where = str_replace( ')))', ")) OR ( {$wpdb->posts}.ID IN (" . implode( ',', $search_ids ) . ")))", $where );
}
return $where;
}
.
