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 vote187 views1 answer
Php remove wordpress shortcodes
PHP Wordpress
1 vote195 views3 answers
Delete a migration laravel
PHP Laravel
4 votes133 views1 answer
Laravel model insert
PHP
0 vote228 views1 answer
Laravel passport generate key
PHP Laravel
0 vote190 views1 answer
Create laravel project 8.16.1
PHP Laravel
1 vote185 views2 answers
In PackageManifest.php line 122:
PHP
27 votes160 views10 answers
Google translate
PHP
0 vote159 views1 answer
$tmpmembershipfee = MembershipFee::orderBy('created_at','DESC') ->first();
PHP
0 vote248 views2 answers
Laravel query where and
PHP
0 vote171 views1 answer
Add Empty Cart Button WooCommerce
PHP