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 vote153 views1 answer
Laravel unknown column updated at
PHP
3 votes128 views1 answer
Php explode end
PHP
0 vote201 views1 answer
Unnamed place placeholders pdo
PHP
0 vote156 views1 answer
Single row data from table in laravel
PHP Laravel
0 vote105 views1 answer
Laravel collection tap
PHP
1 vote162 views1 answer
How validate the value of object in arraye in laravel
PHP Laravel
0 vote150 views1 answer
Adding days in datetime php
PHP
16 votes124 views2 answers
How to save information on pdf file in laravel project
PHP Laravel
0 vote178 views2 answers
Yii2 get cookie
PHP Yii
0 vote147 views1 answer
Learndash logo link
PHP