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 vote248 views1 answer
Send email template via php
PHP
20 votes293 views3 answers
Make specific migration laravel
PHP Laravel
0 vote239 views1 answer
Email in ctf
PHP
1 vote339 views4 answers
Laravel flash message
PHP Laravel
0 vote218 views1 answer
Php replace blackslash
PHP
0 vote262 views1 answer
How to add javascript in php variable
PHP
0 vote230 views1 answer
Tailwindcss - bootstrap - vue - react
PHP
0 vote287 views2 answers
$petani = DB::table('tbl_user')->pluck('id_user', 'username', 'alamat', 'no_telp', 'id_lokasi'); return view('listpetani', ['petani' => $petani]);
PHP
0 vote239 views1 answer
Php get hour
PHP
0 vote306 views1 answer
Laravel sanctum Provoking tokens
PHP Laravel