Hi,
can someone please tell me where in the table I can find the shipping price and subtotal (OC 1.4.9.1) for each order? I'd have thought it was in order_total but it's not there and I need to extract that shipping total and subtotal to edit my invoice template.
Or if there is another way I can display the shipping on the invoice both incl. tax and excl. tax and extract the subtotal, I'd love to know.
Any help appreciated.
It's in the order_total table -- to elaborate on what avvici said, you need to look for the lines that match up with the order_id. In the "title" column there should be "Sub-Total:" and "Shipping:", or something similar, with the associated text and value.
Probably the easiest way to do what you need is to edit the "text" column for the Shipping line item, and change it to something like "$50.00 ($46.30 + 8% tax)"
Probably the easiest way to do what you need is to edit the "text" column for the Shipping line item, and change it to something like "$50.00 ($46.30 + 8% tax)"
Who is online
Users browsing this forum: No registered users and 120 guests