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 vote144 views1 answer
Laravel get all vendor files
PHP Laravel
8 votes129 views3 answers
Laravel redirect back with errors and input
PHP Laravel
0 vote133 views1 answer
How to take last entry in database in laravel Method Two
PHP Laravel
0 vote111 views2 answers
Iteration over jQuery object
PHP
0 vote107 views1 answer
Php check if cli mode
PHP
1 vote102 views1 answer
Sendinblue send mail
PHP
2 votes106 views2 answers
Laravel valet 504 gateway time-out
PHP
0 vote112 views1 answer
Function to find total number of students in wplms
PHP
0 vote121 views1 answer
Laravel flutter save image in data
PHP Laravel
2 votes96 views2 answers
Add seconds to datetime carbon
PHP