wc_update_260_refunds()
Update refunds for 2.6
Description Description
Return Return
(void)
Source Source
File: includes/wc-update-functions.php
function wc_update_260_refunds() {
global $wpdb;
/**
* Refund item qty should be negative.
*/
$wpdb->query(
"UPDATE {$wpdb->prefix}woocommerce_order_itemmeta as item_meta
LEFT JOIN {$wpdb->prefix}woocommerce_order_items as items ON item_meta.order_item_id = items.order_item_id
LEFT JOIN {$wpdb->posts} as posts ON items.order_id = posts.ID
SET item_meta.meta_value = item_meta.meta_value * -1
WHERE item_meta.meta_value > 0 AND item_meta.meta_key = '_qty' AND posts.post_type = 'shop_order_refund'"
);
}