Hi Salva
Hi Salva
Thanks for getting back to me. I'm using ATUM PO's this does work fine with updating my stock qty's in woocommerce however, I would like to update the qty on the PO in a default stock location as well, which I have set as a custom taxonomy '_stock_at_597'.Note: I ONLY have ONE item on each PO!! I used below code in my functions.php but it doesn't work. If you have a solution please kindly let me know. TIA.
add_action('transition_post_status', 'po_receive_stock_at_597', 10, 3);
function po_receive_stock_at_597($new_status, $old_status, $post ){
$order_item_id = $wpdb->get_var($wpdb->prepare("SELECT order_item_id FROM wp_atum_order_items WHERE order_id= $post"));
$product_id = $wpdb->get_var($wpdb->prepare("SELECT `meta_value` FROM `wp_atum_order_itemmeta` WHERE `order_item_id` = $order_item_id AND `meta_key` = '_product_id'"));
$qty_on_po = $wpdb->get_var($wpdb->prepare("SELECT `meta_value` FROM `wp_atum_order_itemmeta` WHERE `order_item_id` = $order_item_id AND `meta_key` = '_qty'"));
$stock_at_597 = get_field('_stock_at_597',$product_id);
$updated_stock_at_597 = $stock_at_597 + $qty_on_po;
update_post_meta ($product_id,'_stock_at_597',$updated_stock_at_597);
}