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

0 vote263 views3 answers
Https://stackoverflow.com/questions/58589741/angular-8-hide-divs-and-show-div-on-button-click
PHP
2 votes272 views1 answer
Composer install requirements skip
PHP
0 vote282 views1 answer
Extract all audio tracks / streams
PHP
7 votes327 views4 answers
With message in laravel
PHP Laravel
0 vote377 views1 answer
Laravel command Retrieve a specific option
PHP Laravel
11 votes301 views5 answers
PHP array sum
PHP
0 vote294 views1 answer
Laravel create registration bootstrap
PHP
2 votes305 views2 answers
Php mod
PHP
0 vote342 views1 answer
How check the time of operation in laravel
PHP Laravel
3 votes321 views2 answers
Php var exists
PHP