CODEWITHSUNDEEP
phpmysqlwordpresswoocommercecustom-fields
Suneth Kalhara
Suneth Kalhara

Reputation: 1208

Woocommerce get Product id using product SKU

I'm working on a separate templates page, which page gets woocommece product sku using custom field of wordpress post. i need to get product id of that sku for create woocommece object and do further things, here is my code.

global $woocommerce;
//this return sku (custom field on a wordpress post)
$sku=get_field( "product_sku" );
if($sku!=''){
  //need to create object, but using sku cannot create a object, 
  $product = new WC_Product($sku); 
  echo $product->get_price_html();
}

is there way to get product id before create object, then i can pass the product id to WC_Product class constructor and create object.thank you

Upvotes: 25

Views: 67789

Answers (4)

WP Developer
WP Developer

Reputation: 1

you can use query

 $product_id = $wpdb->get_var($wpdb->prepare("
        SELECT p.ID 
        FROM {$wpdb->posts} AS p
        INNER JOIN {$wpdb->postmeta} AS pm 
        ON p.ID = pm.post_id
        WHERE p.post_type = 'product' 
        AND pm.meta_key = '_sku' 
        AND pm.meta_value = %s
    ", $sku));

and you can also use simply wc_get_product_id_by_sku('you_product_sku') it will return product id

    wc_get_product_id_by_sku('you_product_sku')

Upvotes: 0

Victor Smirnov
Victor Smirnov

Reputation: 3780

WooCommerce product is a special post type. Because of this WP_Query might be used to find product by SKU and other parameters. This might be used as an alternative when you need to restrict your search by some other criterias.

For example you might want to specify language if you use Polylang (or other plugins) for site translations. Or you can restrict search by product type.

They do direct SQL query in the WooCommerce method get_product_id_by_sku which I think is perfectly fine in many cases. But might not work if you use translations, it will return random product but not the one in current language.

Example code to find product by SKU using WP_Query (with restriction by product type and language):

public function find( string $lang, string $sku ) {
    $query = [
        'lang'       => $lang,
        'post_type'  => 'product',
        'meta_query' => [
            [
                'key'     => '_sku',
                'value'   => $sku,
                'compare' => '='
            ]
        ],
        'tax_query'  => [
            [
                'taxonomy' => 'product_type',
                'terms'    => [ 'grouped' ],
                'field'    => 'name',
            ]
        ]
    ];
    $posts = ( new WP_Query() )->query( $query );

    return count( $posts ) > 0 ? $posts[0] : null;
}

Upvotes: 1

Akshay Agarwal
Akshay Agarwal

Reputation: 2039

WooCommerce 2.3 finally adds support for this in core.

If you are using this version, you can call

wc_get_product_id_by_sku( $sku )

Upvotes: 99

pmandell
pmandell

Reputation: 4328

You can use this function (found here). Google is your friend!

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;
}

Upvotes: 21

Related Questions