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 vote77 views1 answer
How to get parameter value from request symfony
PHP
0 vote112 views1 answer
Multi file delete in php
PHP
9 votes85 views3 answers
Laravel validate time
PHP
2 votes135 views3 answers
Laravel migration drop foreign keys
PHP Laravel
0 vote112 views1 answer
Check backend post type
PHP
3 votes129 views1 answer
Laravel check if array is empty
PHP Laravel
45 votes146 views6 answers
Laravel run seeder
PHP
11 votes103 views3 answers
Get full url php
PHP
0 vote270 views1 answer
Drupal 7 db_query example
PHP Drupal
0 vote133 views1 answer
Pdf watermark dengan laravel
PHP