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 vote249 views1 answer
Laravel 8 date difference in days
PHP Laravel
0 vote281 views1 answer
Comment désactiver la barre latérale Widgets sur des pages spécifiques WordPress
PHP Wordpress
-1 vote191 views2 answers
Php echo alert js
PHP
2 votes216 views1 answer
Laravel model wherein update
PHP
0 vote160 views1 answer
150 charachter display only php
PHP
63 votes277 views6 answers
Laravel artisan clear cache
PHP Laravel
1 vote198 views3 answers
Firebase update realtime database
PHP
0 vote191 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP
4 votes159 views1 answer
Php in javascript
PHP
1 vote209 views1 answer
How change the languge of fie manager in laravel
PHP