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 vote185 views2 answers
Laravel retain old value
PHP
0 vote175 views2 answers
Codeigniter 4 delete redirect with data
PHP
0 vote136 views1 answer
Concat object php
PHP
0 vote166 views1 answer
Pass php variable in onclick function
PHP
0 vote219 views1 answer
Publish spatie
PHP
0 vote180 views1 answer
Php array_walk_recursive
PHP
0 vote186 views1 answer
Return view('user.profile', ['User' => UserController3::fineOrFail($id)]);
PHP
0 vote324 views1 answer
Requires ext-pcntl
PHP
0 vote186 views1 answer
What template files are used for our custom post type in wordpress?
PHP Wordpress
1 vote213 views1 answer
Laravel realation with has
PHP Laravel