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 votes239 views1 answer
Php migrate comand
PHP
0 vote178 views1 answer
Catch wp ajax error
PHP
0 vote236 views1 answer
Migration status php
PHP
3 votes287 views1 answer
Check file size validation laravel
PHP
12 votes231 views4 answers
Laravel auth setup
PHP Laravel
0 vote246 views1 answer
Get action name in yii2
PHP
24 votes271 views2 answers
How to use join in laravel 5.4
PHP Laravel
0 vote245 views1 answer
Function is not defined laravel
PHP Laravel
2 votes224 views3 answers
How to get the previous page url in php
PHP
0 vote236 views1 answer
Drupal sync directory in settings.php
PHP