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

1 vote96 views2 answers
How to create a logout button in wordpress
PHP
1 vote116 views1 answer
How to return with open model popup in laravel
PHP Laravel
1 vote111 views1 answer
Php sql last 10 rows
PHP
0 vote115 views1 answer
How to display limited post content in wordpress
PHP Wordpress
0 vote146 views1 answer
Laravel random value from array
PHP
12 votes96 views4 answers
Php read csv
PHP
0 vote131 views1 answer
Symfony see all make commands
PHP Symfony
1 vote100 views1 answer
Laravel makeHidden
PHP
1 vote102 views1 answer
Insert php mysql
PHP
2 votes98 views2 answers
Wpdb last query
PHP