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

0 vote179 views1 answer
How to use php echo data in javascript
PHP
3 votes167 views3 answers
Fillable property to allow mass assignment
PHP
0 vote169 views2 answers
Php check if parameter exists in url
PHP
1 vote156 views1 answer
How to upload pdf file using php
PHP
0 vote148 views5 answers
Laravel authentication in laravel 8
PHP Laravel
3 votes151 views3 answers
Send attachment in mail php
PHP
1 vote164 views1 answer
Php filter_var boolean
PHP
2 votes190 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
2 votes172 views3 answers
For each loop syntax in laravel
PHP Laravel
7 votes184 views4 answers
Str slug laravel
PHP