This issue may sound a little similar to Order total is not updated after a new item is added by API but instead of just adding a new order item, I want to UPDATE/EDIT an existing order item, and have the order’s total also be updated.
But right now, when I update an order item, I can see it’s successfully being updated, but the order’s total remains unchanged.
E.g., I start off with an order like this: https://s.nimbus.everhelper.me/share/1139832/1ws144ysrmx0l0uv0133
Then I add an order item (the “Percent discount affect tax” line) AND I also update the “TPS” item to be $0.25 instead of $0.50, but the order’s total isn’t updated; see https://s.nimbus.everhelper.me/share/1139838/z6eb2l0lw7ukno4q7u5g. 10 + 0.25 - 4 = 10.25, not 10.50.
For context, this happens when people initially create an order in our system, but then later use a promotion code that should also reduce the tax “TPS”.
I’m updating the order item using the PHP xml rpc library, using “DataService.update” on the “OrderItem” table.
I also tried updating the corresponding InvoiceItem but that didn’t change the order’s total, either. I tried updating the invoice’s total directly, but it’s read-only. I tried to delete the order item and then re-add it, but Infusionsoft has an error if you try to delete an order item.
It seems my only option is to totally delete the order and create a new one. Is that correct?