Create new billings column
-
I’m trying to add a total billings column but I can’t get it to add correctly for each row of the spreadsheet since they are separate items
How do you access which is the current item that a row is accessing?
My current code is this:
add_filter( "woe_fetch_order", function($row, $order){ foreach( $order->get_items() as $order_item_id => $line ) { $row["net_billings"] = $row['products'][$order_item_id]['qty'] * $row['products'][$order_item_id]['item_price'] - $row['order_refund']; } return $row; },10,2);
-
Follow up question. How can I take the net_billings we just created and multiply it by a static field?
I have a static field that’s a commission percentage that I’d like to multiply the net billings with. I can see that the static field is called “static_field_2”, but searching the forums didn’t reveal a way to access it.
Here’s what I got with a hard coded .6, but I’d like to just grab that value from the static field.
add_filter('woe_get_order_product_value_commission_amount', function ($value, $order, $item, $product, $item_meta) { return ($item->get_subtotal() - $order->get_qty_refunded_for_item( $item->get_id())) * .6; }, 10, 5);Hi, this little bit of code you gave above to use “Order Line Total (- Refund)” actually doesn’t seem to be getting the correct amount. I’ve got a line that has a item price of 500 and a refund of 505 and the “net billings” column we created shows as 500, but it should be -5. So it isn’t getting the right calculation.
I tried to look in to it and this bit seems to always return 0 even if there is a refunded amount:
$order->get_qty_refunded_for_item( $item->get_id())I tried switching to using
get_qty_refunded_for_itembut it still gets the 0.I think the problem may be that we are using the ‘Order Refund Amount’ under totals, and not the ‘Order Line Total Refunded’ under Products.
The code for finding the static value works great though! Thank you for that!
The topic ‘Create new billings column’ is closed to new replies.
