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

15 votes183 views4 answers
Php Error Reporting
PHP
0 vote151 views1 answer
Laravel where on relationsship column
PHP Laravel
0 vote139 views2 answers
Laravel filesystem
PHP
1 vote188 views1 answer
How to reverse fetch assoc in php
PHP
0 vote177 views1 answer
Eager loading in hasmany belongsto relationship
PHP
0 vote159 views1 answer
Laravel blade all syntex description
PHP Laravel
4 votes118 views1 answer
Create view from route laravel
PHP
0 vote126 views1 answer
Laravel collection last
PHP
0 vote132 views1 answer
Set default value for column in laravel model
PHP
4 votes201 views3 answers
Laravel restore deleted
PHP Laravel