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

11 votes167 views3 answers
Laravel get last 5 records
PHP Laravel
0 vote133 views1 answer
Php inside html tag
PHP
1 vote165 views1 answer
Laravel insert or ignore
PHP
0 vote170 views1 answer
Laravel validation if another record is not deleted / not null
PHP Laravel
2 votes148 views1 answer
Laravel mix purge css
PHP
0 vote214 views1 answer
Check if config exist laravel
PHP Laravel
20 votes144 views4 answers
Change php version in ubuntu
PHP
21 votes144 views6 answers
Change php version ubuntu
PHP
13 votes145 views6 answers
Prefix laravel route
PHP
0 vote154 views1 answer
Image_lib codeigniter add _thumb
PHP