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 votes162 views4 answers
Carbon get difference between two dates in years and months
PHP
0 vote148 views1 answer
Php empy a file
PHP
0 vote177 views1 answer
Time zone set in codeigniter
PHP CodeIgniter
1 vote158 views1 answer
Laravel inverse seeder
PHP Laravel
0 vote137 views1 answer
Laravel query with optional filter
PHP
0 vote207 views1 answer
Laravel request not returning errors
PHP Laravel
0 vote132 views1 answer
Run a server php terminal
PHP
0 vote109 views1 answer
Laravel blade trim whitespace
PHP Laravel
0 vote143 views1 answer
Php form action self
PHP
46 votes215 views6 answers
Add column to migration laravel
PHP Laravel