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 vote267 views1 answer
Onbeforeunload com mysql php
PHP
0 vote181 views1 answer
WPML - Add a floating language switcher to the footer
PHP
0 vote195 views1 answer
Wp ajax error handling
PHP Wordpress
0 vote227 views1 answer
Laravel nginx
PHP Laravel
25 votes194 views1 answer
Write php online
PHP
0 vote235 views1 answer
Check if value exists in object php
PHP
0 vote207 views9 answers
Laravel view-model
PHP
2 votes238 views1 answer
Laravel blade file naming conventine
PHP Laravel
0 vote190 views1 answer
Php static dropdown list example
PHP
3 votes191 views2 answers
Get woocommerce order details
PHP