How to display SubTotal, Discounts and Charges once an order is completed using data from the Order and OrderDetails table?
We are trying to build a CMS and we'd like customers, and the site owner, to be able to review orders.
What is the easiest way to display the SubTotal, Discounts and Charges once an order is completed? These details aren't stored in the Order or OrderDetails tables so should I just add them as additional fields in the Order table and bind them to the cart values for SubTotal, Discounts and Charges?
Appreciate the advice. Thank you.