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 vote183 views1 answer
Laravel Mix npm run production error
PHP
1 vote198 views1 answer
Laravel storage check file exists
PHP
0 vote198 views1 answer
Wordpress wpdb delete
PHP Wordpress
0 vote195 views1 answer
Créer projet laravel
PHP Laravel
0 vote210 views1 answer
How to set db table type in laravel
PHP
6 votes217 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
2 votes173 views2 answers
Nl2br() php
PHP
1 vote216 views1 answer
Stack once laravel
PHP Laravel
31 votes197 views6 answers
Php difference between two dates
PHP
1 vote240 views1 answer
Why job laravel do not worl
PHP Laravel