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

18 votes300 views3 answers
Php pop off the first character of string
PHP
12 votes503 views6 answers
Email validation in laravel
PHP Laravel
0 vote315 views1 answer
Laravel collection union
PHP
0 vote358 views1 answer
Laravel count distance lat/longtidue
PHP Laravel
0 vote376 views1 answer
Onclick call route laravel
PHP Laravel
1 vote307 views1 answer
Typo3 inline if
PHP
5 votes333 views2 answers
Laravel print exception message
PHP Laravel
0 vote319 views1 answer
Php registration form and login in same page
PHP
0 vote359 views1 answer
Php increment sum
PHP
0 vote310 views1 answer
Sql update views +1
PHP