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 vote228 views6 answers
Laravel tips
PHP Laravel
0 vote239 views3 answers
Php remove slashes from json
PHP
92 votes219 views6 answers
Replace php
PHP
0 vote235 views1 answer
Php implode as key value of object
PHP
91 votes236 views6 answers
How to check if a string contains a substring in php
PHP
1 vote249 views1 answer
Laravel eloquent where id not equal to
PHP Laravel
3 votes242 views4 answers
PHP executable not found. Install PHP 7 and add it to your PATH or set the php.executablePath setting
PHP
0 vote231 views1 answer
Laravel withcount change name
PHP Laravel
0 vote220 views3 answers
Laravel model where in
PHP Laravel
0 vote226 views1 answer
Php retrieve data from database and show in text area greeper
PHP