add_filter( 'posts_search', 'dubai_store_search_by_sku', 999, 2 );
function dubai_store_search_by_sku( $search, $wp_query ) {
global $wpdb;
if ( is_admin() || ! $wp_query->is_main_query() || ! $wp_query->is_search() ) return $search;
$query = $wp_query->get( 's' );
if ( empty( $query ) ) return $search;
$search .= $wpdb->prepare( " OR EXISTS (
SELECT 1 FROM {$wpdb->postmeta}
WHERE post_id = {$wpdb->posts}.ID
AND meta_key = '_sku'
AND meta_value LIKE %s
)", '%' . $wpdb->esc_like( $query ) . '%' );
return $search;
}
Shop - Page 53 of 67 - Dubai Store
Product has been added to your cart
Compare
(0)
