How to search by sku woocommerce

function get_product_by_sku( $sku ) {
  global $wpdb;

  $product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $sku ) );

  if ( $product_id ) return new WC_Product( $product_id );

  return null;
}

Source: skyverge.com

Similar codes

4 votes141 views5 answers
Wordpress logout link
PHP
9 votes132 views3 answers
Laravel join 2 tables eloquent
PHP
0 vote87 views1 answer
How to remove one element from array
PHP
40 votes145 views6 answers
Rand string php
PHP
1 vote134 views3 answers
Hide php extension htaccess
PHP
7 votes149 views2 answers
Date time format for laravel validation
PHP Laravel
0 vote145 views1 answer
Counting time execution duration in time laravel
PHP Laravel
0 vote146 views1 answer
Get am pm 12 hour timee laravel
PHP Laravel
0 vote131 views3 answers
Is_unique in codeigniter form validation
PHP
0 vote130 views1 answer
Php ord deprecated
PHP