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

4 votes273 views3 answers
Laravel description substring
PHP Laravel
0 vote303 views1 answer
Export txt php
PHP
11 votes276 views6 answers
Redirect route with parameters laravel
PHP
3 votes262 views1 answer
Laravel validation pdf
PHP
1 vote252 views1 answer
Php get current datetime mysql format
PHP
4 votes322 views3 answers
Laravel eloquent remove from db
PHP Laravel
7 votes253 views2 answers
How do I check if a string contains a specific word?
PHP
5 votes323 views4 answers
Update column type laravel migration
PHP Laravel
1 vote252 views1 answer
Laravel check if in production
PHP
0 vote309 views1 answer
Laravel str library
PHP Laravel