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

1 vote155 views1 answer
Laravel model increase the value by one
PHP
0 vote163 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
0 vote191 views1 answer
Laravel console example
PHP Laravel
2 votes189 views4 answers
Foreach in laravel
PHP Laravel
0 vote144 views1 answer
Php get files in folder
PHP
-2 votes136 views1 answer
Php boolean
PHP
1 vote155 views1 answer
Change verify email template laravel
PHP
0 vote169 views1 answer
Uncaught ReferenceError: commonL10n is not defined
PHP
1 vote252 views1 answer
Laravel return list of ids
PHP Laravel
0 vote191 views1 answer
Php get latest file in directory
PHP