I'm building a custom function for Woocommerce where I need to get product SKU and if 'variation' product get variation specific SKU.
What I currently have is the following:
// Query order data
$order = new WC_Order($order_id);
$items = $order->get_items();
// Output the loop
foreach ($order->get_items() as $item) {
// Getting some information
$product_name = $item['name'];
$product_id = $item['product_id'];
$product_qty = $item['qty'];
$product_variation_id = $item['variation_id'];
$product = new WC_Product($item['product_id']);
// SKU
$SKU = $product->get_sku();
It works good except when it comes to variations, I Have spent much time trying to figure this out and to find a good answer without any succes.
I come to understand that I should use something like this:
$available_variations = $product->get_available_variations();
The crazy thing is that I did have this working but I didn't made a Git commit, thus I'm not able to revert the correct code. All the examples I found pretty much exist of a lot of code, but I'm sure this can be done using a much simpler and better performing method.
Talk about tunnel vision..
$product_variation_id = $item['variation_id'];
$product = new WC_Product($item['product_id']);
Solution was switching 'product_id' for my already in place 'variation_id'
$product = new WC_Product($item['variation_id']);
Voila, problem solved !
Working example
To get the expected output on $sku
i did go for this solution
// Get order data
$order = new WC_Order($order_id);
$items = $order->get_items();
// Loop through ordered items
foreach ($items as $item) {
$product_name = $item['name'];
$product_id = $item['product_id'];
$product_qty = $item['qty'];
$product_variation_id = $item['variation_id'];
// Check if product has variation.
if ($product_variation_id) {
$product = new WC_Product($item['variation_id']);
} else {
$product = new WC_Product($item['product_id']);
}
// Get SKU
$sku = $product->get_sku();
}