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 vote203 views1 answer
Select selected fields in laravel join
PHP Laravel
0 vote288 views3 answers
Best wordpress functions to include
PHP Wordpress
10 votes216 views2 answers
Create model in laravel command line
PHP Laravel
4 votes191 views2 answers
Php loop through start and end date
PHP
0 vote211 views1 answer
"data:text/vcard;
PHP
0 vote203 views1 answer
Get current tax page
PHP
0 vote191 views1 answer
Php conditionally remove element from array
PHP
4 votes220 views2 answers
Get permalink by id wordpress
PHP Wordpress
0 vote221 views1 answer
Laravel get current domain
PHP Laravel
15 votes189 views4 answers
Remove space from start and end of string in php
PHP