Customer Order - VAT - Help

[rabz]

Hi everyone,

I was hoping someone would shed some light on my problem. Basically I have set up a CSV export of my orders, however i am missing a piece of information which is the order total before VAT is applied and the actual VAT value (not the precentage).

Can someone please tell me if Zencart already collects this information, and where in the database structure i can find it.

However if it doesn't collect it can somebody tell me where the file is, which processes the orders and inserts all the information into the tables so I can add it to the database and then pull it out when i do my exports.

Thanks Everyone!!!

[confused_aswell]

Hi

You can find the information in the orders_total table.

Hope this helps.

Phil

[rabz]

thanks.

I worked it out, for anyone else who may want to know how to insert additional information into the orders table.
Set up your field(s) in phpmyadmin (or whatever you want) then in root>includes>classes>orders.php at about line 567(ish) you will find an array called $sql_data_array. Its really long so you can't miss it.
It is within this array that you insert your extra custom field and the associated value.
Add the field name in the array so it corresponds with your table structure.