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 vote173 views2 answers
Access paginator object attribute in laravel
PHP
2 votes159 views2 answers
Php factorial
PHP
0 vote198 views1 answer
Hasmany relationship with created at in laravel example
PHP Laravel
0 vote244 views1 answer
Laravel ailed: WebSocket opening handshake was canceled
PHP Laravel
0 vote176 views3 answers
Add ACF to single.php
PHP
84 votes183 views3 answers
Check if string contains substring php 8
PHP
15 votes225 views6 answers
Laravel migration delete column
PHP Laravel
5 votes161 views3 answers
Laravel model limit
PHP
0 vote204 views1 answer
Chart trong laravel
PHP
0 vote133 views1 answer
Numberformatter gujarati
PHP