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 vote133 views1 answer
Laravel check if in production
PHP Laravel
31 votes129 views3 answers
Carbon laravel use
PHP Laravel
0 vote176 views1 answer
Laravel nova field required
PHP Laravel
0 vote121 views1 answer
Get count array php
PHP
0 vote118 views1 answer
Php call method from another class
PHP
0 vote95 views1 answer
Image_lib codeigniter add _thumb
PHP CodeIgniter
1 vote120 views1 answer
Insert php mysql
PHP
2 votes148 views3 answers
Php laravel dump
PHP Laravel
0 vote144 views1 answer
Docker php 7.2 add ext-mongodb
PHP
11 votes232 views6 answers
Redirect route with parameters laravel
PHP Laravel