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

2 votes169 views2 answers
Assign multiple variables php
PHP
0 vote178 views1 answer
Php input seperated by space
PHP
6 votes195 views4 answers
Install laravel on windows
PHP
3 votes195 views6 answers
Last insert id in laravel
PHP
7 votes171 views1 answer
Php detect request type
PHP
1 vote201 views2 answers
Page expire in laravel
PHP
0 vote179 views1 answer
Docker php-fpm-apline add imagick
PHP
0 vote180 views1 answer
Wordpress wp_enqueue_script footer
PHP Wordpress
1 vote196 views1 answer
How to insert multiple data at a time with create method in laravel
PHP Laravel
3 votes273 views3 answers
Laravel collection combine
PHP