Tienda
All Products
This is where visitors can browse products in your store.
Social Media Posts
This is a gallery to showcase images from your recent social posts
Customer Reviews
★★★★★ 5/5
“A review from a customer who benefited from your product. Reviews can be a highly effective way of establishing credibility and increasing your company’s reputation.”
Customer Name
★★★★★ 5/5
“A review from a customer who benefited from your product. Reviews can be a highly effective way of establishing credibility and increasing your company’s reputation.”
Customer Name
Join Our Newsletter
function custom_search_by_sku( $where, $wp_query ) {
global $wpdb;
if ( empty( $where ) || ! is_search() ) {
return $where;
}
$search_term = $wp_query->query_vars[‘s’];
if ( ! $search_term ) {
return $where;
}
$where .= ” OR ({$wpdb->prefix}postmeta.meta_key = ‘_sku’ AND {$wpdb->prefix}postmeta.meta_value LIKE ‘%” . esc_sql( $search_term ) . “%’)”;
return $where;
}
function custom_join_search_sku( $join ) {
global $wpdb;
if ( is_search() ) {
$join .= ” LEFT JOIN {$wpdb->prefix}postmeta ON {$wpdb->prefix}posts.ID = {$wpdb->prefix}postmeta.post_id “;
}
return $join;
}
function custom_search_distinct( $distinct ) {
if ( is_search() ) {
return ‘DISTINCT’;
}
return $distinct;
}
add_filter( ‘posts_where’, ‘custom_search_by_sku’, 10, 2 );
add_filter( ‘posts_join’, ‘custom_join_search_sku’ );
add_filter( ‘posts_distinct’, ‘custom_search_distinct’ );
