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

4 votes102 views1 answer
Uuid package generator laravel
PHP
1 vote102 views2 answers
Insert data using mysqli in php
PHP
0 vote113 views1 answer
How to on debugger in wordpress
PHP Wordpress
0 vote92 views1 answer
Laravel route match
PHP
3 votes130 views3 answers
Get order details by id woocommerce
PHP
18 votes112 views6 answers
Laravel unique validation
PHP Laravel
0 vote103 views1 answer
Automatic Subdomain with PHP
PHP
21 votes104 views6 answers
Php empty array
PHP
3 votes111 views1 answer
Php encode url parameters
PHP
3 votes114 views1 answer
Date time laravel
PHP Laravel