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

20 votes335 views3 answers
Json url decode php
PHP
0 vote362 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
2 votes431 views1 answer
Cakephp 2 savefield
PHP CakePHP
2 votes323 views4 answers
Php require_once
PHP
2 votes381 views1 answer
Laravel scout import command
PHP Laravel
0 vote391 views1 answer
Auto check a category when creating new post
PHP
0 vote342 views1 answer
Laravel blade php variable concatenate javascript variable
PHP
1 vote324 views2 answers
In PackageManifest.php line 122:
PHP
0 vote330 views1 answer
Symfony form get errors
PHP
1 vote320 views1 answer
Php is daylight savings
PHP