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 vote138 views1 answer
Datediff in hour query builder laravel
PHP Laravel
48 votes225 views2 answers
Laravel check my laravel version
PHP
0 vote137 views1 answer
Use php artisan command through controller
PHP
0 vote231 views1 answer
Yii1 findall as array listData
PHP Yii
10 votes186 views2 answers
Laravel array to string conversion
PHP
1 vote130 views1 answer
Get elasticsearch data magento 2
PHP
0 vote150 views2 answers
Laravel collection collect
PHP Laravel
0 vote148 views4 answers
Installing bootstrap on laravel8
PHP Laravel
0 vote117 views1 answer
Multe data on database laravel
PHP
1 vote118 views1 answer
Select values from mysql using php array of ids
PHP