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 vote146 views1 answer
Wp_create_user
PHP
1 vote140 views1 answer
How get just one parameter of all objects in one array in laravel
PHP
11 votes138 views5 answers
Php post form to self
PHP
10 votes134 views3 answers
Migrate to an existing table in laravel commad
PHP
0 vote146 views1 answer
Laravel custom validation check if valid url
PHP
1 vote153 views2 answers
Laravel request all except
PHP Laravel
0 vote157 views1 answer
Create or update laravel 5.8 stackoverflow
PHP Laravel
0 vote153 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
0 vote143 views1 answer
Php print character x times
PHP
2 votes166 views1 answer
Acf options page
PHP