SKU in variations dropdown

in functions.php

// Laat SKU zien in dropdown met variaties
function wbmz_display_price_in_variation_option_name( $term ) {
    global $wpdb, $product;

    if( isset( $product ) ) {
        $query = sprintf( "SELECT postmeta.post_id AS product_id
            FROM {$wpdb->prefix}postmeta postmeta
            LEFT JOIN {$wpdb->prefix}posts products ON ( products.id = postmeta.post_id )
            WHERE postmeta.meta_key LIKE 'attribute_%%'
            AND postmeta.meta_value = '%s'
            AND products.post_parent = %d", $term, $product->get_id() );

        $results = $wpdb->get_results( $query );

        foreach ($results as $key => $result) {
            $variation_id = $result->product_id;
        }

        $variation_sku = get_post_meta( $variation_id , '_sku', TRUE );

        $term = $term . ' ('. $variation_sku .')';
    }

    return $term;
}
add_filter( 'woocommerce_variation_option_name', 'wbmz_display_price_in_variation_option_name', 10, 1 );

#dropdown #product #sku #variatie #variations #woocommerce