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 vote151 views1 answer
Laravel create on model
PHP Laravel
0 vote162 views1 answer
Laravel Pusher 401 Unauthorized
PHP Laravel
0 vote230 views1 answer
Comment définir un délimiteur de fil d’Ariane personnalisé dans WooCommerce
PHP
9 votes140 views3 answers
Relative path
PHP
30 votes155 views4 answers
Date diff php
PHP
0 vote134 views1 answer
Show widget using the shortcode from php
PHP
21 votes165 views6 answers
Laravel route parameters
PHP Laravel
-2 votes170 views3 answers
Laravel when condition
PHP Laravel
2 votes139 views1 answer
Php file_get_contents disable ssl check
PHP
1 vote143 views1 answer
Date format in laravel month name day name
PHP Laravel