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

3 votes319 views1 answer
How to change add to cart button in wordpress
PHP Wordpress
15 votes399 views4 answers
Wordpress thumbnail url
PHP Wordpress
0 vote295 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP
0 vote271 views1 answer
Http error code php
PHP
0 vote274 views1 answer
Update button
PHP
1 vote273 views1 answer
How to protect your website from DDos Attack?
PHP
0 vote305 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP Laravel
0 vote310 views1 answer
Laravel reset autoload
PHP Laravel
4 votes321 views6 answers
Jwt laravel
PHP
3 votes272 views3 answers
Vc_map type number
PHP