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 votes333 views5 answers
Php last day of month
PHP
0 vote253 views1 answer
Laravel truncate string laravel 8
PHP
11 votes269 views6 answers
Php object to array
PHP
0 vote247 views1 answer
Drupal 8 entity query
PHP
0 vote328 views1 answer
Solution for unseting an array
PHP
0 vote238 views1 answer
Call function from default parameter php
PHP
16 votes336 views5 answers
Get user auth in laravel
PHP Laravel
4 votes229 views1 answer
Php find multiple strings in string
PHP
6 votes269 views2 answers
Nav active in laravel
PHP Laravel
4 votes257 views3 answers
How to get the url parameter in blade laravel
PHP