Is there any built-in process, a plug-in, or does someone have any experience with the recalculation of an order total when the quantities of the line items are modified. For example, an order comes in for:
Product A:
Price: $10.00 excl tax and $10.90 incl tax
Quantity 2,
Total: $20.00 excl tax and $21.80 incl tax
Order Subtotal (excl tax): $20.00
Order Tax: $ 1.80
Order Total (incl tax): $21.80
The store is short one, and since the user is in a hurry he updates the quantity field and forgets to recalculate the totals. The resulting order is:
Product A:
Price: $10.00 excl tax and $10.90 incl tax
Quantity 1,
Total: $20.00 excl tax and $21.80 incl tax
Order Subtotal (excl tax): $20.00
Order Tax: $ 1.80
Order Total (incl tax): $21.80
If the user doesn't remember to update the totals, sub-totals, and tax amounts, they will be charged the original amount even though they were shorted.
I'm hoping there's something that will allow the line item's totals to be automatically calculated, as well as the order's totals. Ideally for me, it would best if the page prompted the user to see if they wanted to re-calculate the order.
Product A:
Price: $10.00 excl tax and $10.90 incl tax
Quantity 1,
Total: $10.00 excl tax and $10.90 incl tax
Order Subtotal (excl tax): $10.00
Order Tax: $ 0.90
Order Total (incl tax): $10.90
And the same goes when adding a new product to an existing order from the Administrative site. Adding a new product should pickup the existing price and add it to the order and update the totals.