please help me edit the subtotal of a completed order, There was an order placed for COD and it was delivered with invoice photoshoped with new values however i want to change the subtotal in the system. I knew it is possible through database edit. some one please guide me.
Data for invoices can be found in the
sales_flat_invoice table in the database. You can edit whichever field you like.
In your case with subtotal it's 4 fields
Also check the
sales_flat_invoice_grid table if you want to make sure the change also reflects in your invoice grid