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

1 vote309 views1 answer
Get random posts wordpress
PHP
1 vote295 views1 answer
Recursive function in php
PHP
0 vote315 views1 answer
Real time update using ajax php
PHP
0 vote312 views1 answer
If file is not selected in file input type php
PHP
5 votes305 views2 answers
Throwexception laravel
PHP
0 vote317 views1 answer
Reply to wp_mail
PHP
2 votes289 views1 answer
Php start of day epoch
PHP
0 vote345 views1 answer
String to slug php
PHP
0 vote295 views1 answer
Back end
PHP
4 votes365 views1 answer
Password match laravel
PHP Laravel