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

13 votes141 views6 answers
Route group in laravel
PHP Laravel
-1 vote122 views2 answers
Laravel eloquent update multiple records
PHP
2 votes146 views2 answers
Php get epoch timestamp of date
PHP
0 vote143 views1 answer
Laravelda urlga keladigan so`rovlarni cheklash
PHP Laravel
3 votes127 views2 answers
Smarty assign var
PHP
2 votes124 views2 answers
Update kali
PHP
1 vote188 views3 answers
Check image exist or not in laravel
PHP Laravel
0 vote135 views1 answer
Wp wc php out of stock product to bottom
PHP
0 vote153 views1 answer
Get all users created in a month laravel
PHP Laravel
0 vote105 views1 answer
Wordpress search for post id in wp_query
PHP Wordpress