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 votes358 views4 answers
Install laravel on windows
PHP Laravel
0 vote337 views2 answers
Mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
PHP
18 votes337 views5 answers
Alert in php
PHP
98 votes401 views6 answers
Array_push
PHP
9 votes359 views3 answers
Laravel validation image or file
PHP
0 vote362 views1 answer
Laravel get file name
PHP
0 vote429 views1 answer
Laravel weekly data
PHP Laravel
1 vote309 views1 answer
Jwt decode php
PHP
0 vote334 views1 answer
Php composer copy library to public vendor folder
PHP
0 vote431 views1 answer
Laravel view not created using foreign keys
PHP Laravel