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

2 votes251 views2 answers
Echo query in laravel
PHP Laravel
0 vote275 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
70 votes245 views6 answers
Php truncate string
PHP
37 votes262 views6 answers
Carbon now format
PHP
0 vote240 views1 answer
Php foreach random
PHP
7 votes234 views3 answers
Laravel get latest
PHP Laravel
0 vote225 views3 answers
Chrome web driver
PHP
0 vote252 views1 answer
Laravel 8 clear compiled class files
PHP
0 vote235 views1 answer
Laravel array to string error
PHP
6 votes248 views3 answers
Laravel ecommerce
PHP Laravel