Post by iSupply3D » Fri Apr 20, 2012 7:43 pm

Hi,
Using v1.5.2.1.

I'm trying to get a report which lists completed orders between certain dates.
Most of the info I can find no problem and have successfully linked Excel to the opencart mySQL via ODBC.
However, I can't find how to show each order's shipping costs.
Have also tried Apsona and created an order report in there, but still can't find the shipping costs.
I know it'll be in the .php related to invoicing somewhere ???

Ultimately, I'd like everything the appears on the invoice to be spread out into a report for tax purposes.
Without the shipping amounts in the report, the total amounts will differ from the amounts actually recieved (and will need accounting for)

Thanks in advance.

Newbie

Posts

Joined
Fri Apr 20, 2012 7:29 pm

Post by iSupply3D » Mon Apr 23, 2012 8:08 pm

It looks like I'll have to use the order_total table...it seems to be the only one that includes subtotal, shipping, tax and total.

Newbie

Posts

Joined
Fri Apr 20, 2012 7:29 pm
Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 48 guests