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.
2 Answers
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
- subtotal_incl_tax
- base_subtotal_incl_tax
- subtotal
- base_subtotal
Also check the sales_flat_invoice_grid
table if you want to make sure the change also reflects in your invoice grid
-
Hi sander, sorry for being dumb again, where do i find the sales_flat_invoice? coz i was looking for it in phymyadmin. i dont see anything with name of sales. Sep 7, 2015 at 9:10
-
-
Hi Sander, That was just perfect on the second page, But i tried editing the shipping charge, i added like 30$ extra on an complete order both the sales_flat_invoice and sales_flat_invoice_grid but still doesnt have effect o n the admin panel. Sep 7, 2015 at 9:47
-
Are you looking at the invoice or order? Try editing the
sales_flat_order
too. Make a backup of the data first tho. You never know.– Sander Mangel ♦Sep 7, 2015 at 9:56 -
Hi sander, you the best, you have saved my day.. it worked perfectly fine and the dashboard values has also changed.. Sep 7, 2015 at 10:56
- sales_flat_invoice
- sales_flat_invoice_grid
- sales_flat_order
These are the database rows where you can edit the values of invoice and order accordingly,
This table can be found in the database of your website, phpmyadmin on the second and third page respectively.