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

1 vote319 views1 answer
Php single quote vs double quote
PHP
0 vote312 views1 answer
Php instance class from string
PHP
1 vote380 views1 answer
Definir una constante para llamar archivos en puglins de WordPress
PHP Wordpress
1 vote315 views1 answer
PHP Warning: Module 'grpc' already loaded in Unknown on line 0
PHP
1 vote298 views1 answer
Jwt decode php
PHP
0 vote315 views1 answer
Get taxonomies for custom post type
PHP
3 votes417 views1 answer
Check file size validation laravel
PHP
0 vote334 views1 answer
Create if not exist laravel
PHP
0 vote374 views1 answer
How to create table for every user in laravel
PHP Laravel
0 vote397 views1 answer
Change the date format in laravel view page
PHP Laravel