Post by Dana » Tue Feb 05, 2013 9:20 pm

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.
Last edited by Dana on Thu Feb 07, 2013 6:09 am, edited 1 time in total.

User avatar
New member

Posts

Joined
Tue Jun 29, 2010 8:13 pm

Post by Avvici » Thu Feb 07, 2013 5:15 am

order_total

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by Johnathan » Thu Feb 07, 2013 6:04 am

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)"

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by Dana » Thu Feb 07, 2013 6:09 am

Thank you so much, I have found it on my own. It confused me because I expected the values to be all in one row and not multiple rows for the same order. :)

User avatar
New member

Posts

Joined
Tue Jun 29, 2010 8:13 pm
Who is online

Users browsing this forum: No registered users and 120 guests