get woocommerce product ID by sku

getProductIDBySku

/**
 * Title: getProductIDBySku
 * Author: Mattias Ghodsian
 * Description: get woocommerce product ID by sku
 * Donate a cup of coffee: https://www.buymeacoffee.com/mattiasghodsian
 **/
Public function getProductIDBySku( $sku ) 
{
	if (empty($sku)) { return false; }
    global $wpdb;
    // $product_id = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE meta_key='_sku' AND post_id='%s' LIMIT 1", $sku ) );

    $data = $wpdb->get_results(" SELECT * FROM $wpdb->postmeta WHERE meta_key = '_sku' ");
    foreach ($data as $key => $row) {
    	if ( $row->meta_value == $sku ) {
    		return $row->post_id;
    	}
    }
}