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 votes130 views2 answers
Print average result in php
PHP
0 vote173 views1 answer
Laravel firstorcreate with multiple parameters
PHP Laravel
0 vote128 views1 answer
Post is empty php api
PHP
5 votes149 views1 answer
Laravel model method like foreach parts of
PHP Laravel
40 votes135 views3 answers
Replace all numbers in string php
PHP
1 vote217 views1 answer
Cake tmp name
PHP
2 votes137 views1 answer
Laravel upload image to public folder
PHP
1 vote142 views3 answers
Wordpress admin url
PHP Wordpress
0 vote161 views1 answer
Nested with laravel
PHP Laravel
0 vote123 views1 answer
Redirect wordpress core login
PHP