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

6 votes333 views6 answers
Search query in laravel
PHP Laravel
8 votes308 views6 answers
Laravel command not found
PHP
1 vote259 views1 answer
Wp query search
PHP
0 vote296 views1 answer
Parent directory in php
PHP
0 vote343 views1 answer
Php array common element
PHP
10 votes297 views4 answers
Unset php
PHP
0 vote325 views1 answer
Filter_var filter_validate_url
PHP
1 vote382 views1 answer
Laravel end date greater than start date validation
PHP Laravel
0 vote363 views1 answer
Laravel repository update multiple row
PHP Laravel
0 vote312 views1 answer
Updateorinsert laravel for large data
PHP