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

3 votes260 views6 answers
Failed to open stream: Permission denied
PHP
0 vote255 views1 answer
Skäller västgötaspetsar
PHP
5 votes252 views4 answers
Laravel auth register false
PHP
0 vote330 views1 answer
How to disable opcache
PHP
5 votes275 views4 answers
Php url parameters
PHP
0 vote252 views1 answer
Php is_a
PHP
0 vote338 views1 answer
Drupal 8 custom form image field
PHP Drupal
1 vote277 views1 answer
How to alias table name in laravel model
PHP
1 vote240 views2 answers
Check installed php modules in linux
PHP
1 vote298 views1 answer
Laravel string builder
PHP Laravel