cancel
Showing results for 
Search instead for 
Did you mean: 

Grand Total (Excl.tax) value in database

Grand Total (Excl.tax) value in database

Hi all.

Does anyone know which database table the Grand Total (Excl.tax) of an order is saved please?

In fact, it would a great help if any knows where all of the order totals values are stored.

I know they're spread across multiple tables, but to help me get a grip on where all of these values are stored would be a big help.

If not, I'm mainly interested in the Grand Total (Excl.tax) value.

Many Thanks in advance

Andy

1 REPLY 1

Re: Grand Total (Excl.tax) value in database

Hello @Andy_Acute ,

 

you'll find all details(tax, shipping amount, subtotal etc) in sales_order and sales_order_grid table for all orders. and for specific item detail, you can check in sales_order_item table.

 

Hope it helps.

Problem Solved ? Click on 'Kudos' & Accept as Solution ! Smiley Happy