cancel
Showing results for 
Search instead for 
Did you mean: 

Incorrect Total and Subtotal in my orders

Incorrect Total and Subtotal in my orders

While inserting data manually into Magento db , Customer>My orders grand total and sub total data are populated incorrectly. Could someone please help me to know the table and columns from which these data are populated. How can we insert data into tables such that  grand total and sub total are  sum of items in the order list. Thanks in advance. 

1 REPLY 1

Re: Incorrect Total and Subtotal in my orders

Hello @vineesh_pullara 

 

You can check below shared tables for Magento 2 sales order:

sales_order
sales_order_grid
sales_order_item
sales_order_payment
Manish Mittal
https://www.manishmittal.com/