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 vote190 views1 answer
Fehler beim Uploadtest der ausgewählten Datei.
PHP
44 votes175 views4 answers
Laravel random string
PHP
0 vote195 views1 answer
How to get all post fields in wordpress
PHP Wordpress
1 vote200 views1 answer
Laravel iseed
PHP Laravel
30 votes159 views6 answers
Laravel auth
PHP
3 votes200 views1 answer
Laravel carbon get year number
PHP Laravel
0 vote165 views1 answer
Xampp php 5.6 download 64 bit
PHP
0 vote158 views5 answers
Download file laravel s3
PHP
0 vote223 views1 answer
Creating random number betwwen ranges in php
PHP
1 vote184 views3 answers
Insert key-value pair into array php
PHP