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 vote344 views1 answer
Php get parent url from script location
PHP
0 vote341 views1 answer
Wordpress disallow_file_edit
PHP Wordpress
2 votes312 views3 answers
Php setinterval
PHP
2 votes275 views3 answers
Get current date from year input php
PHP
1 vote273 views1 answer
How to create a bot in telegram in php
PHP
1 vote345 views2 answers
Laravel model is dirty
PHP Laravel
2 votes273 views2 answers
Laravel websockets
PHP
0 vote284 views1 answer
Laravel dateinterval not found
PHP Laravel
0 vote311 views1 answer
Laravel keep old input
PHP
2 votes291 views3 answers
Foreach loop laravel
PHP Laravel