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 vote180 views1 answer
How to disable a button in a blade file
PHP
2 votes183 views2 answers
Overloading and overriding in php
PHP
2 votes161 views1 answer
Codeigniter row count returns 1 always
PHP CodeIgniter
13 votes208 views3 answers
Is null php
PHP
1 vote254 views1 answer
Htaccess replace url parameter with slash prameter
PHP
37 votes218 views6 answers
Laravel order by
PHP Laravel
0 vote192 views3 answers
Move_uploaded_file
PHP
8 votes252 views3 answers
Php delay
PHP
0 vote195 views1 answer
Laravel datatable render html
PHP
1 vote200 views2 answers
Remove product from cart by id woocommerce
PHP