The sales_order table ( sales_flat_order on M1) is where each order is captured. ... with the customer's second purchase, this column will return a value of 1-2 .
You have to dump for these tables for all orders records: sales_invoice; sales_invoice_comment; sales_invoice_grid; sales_invoice_item ...
http://anna.voelkl.at/uploads/magento/ce1922.png shows tables in a diagram, I can see sales_flat_order table for instance. Also sales_order_* ...
[Note] : Please take database backup prior to executing these queries. I went through all tables and came up with following list of tables that should be truncated ...
CORNER OF BLOG: "Save Rain Water"
for save custom field value in database table using magento 2.
Magento Version: 1.5.0.1. More modern version of Magento have abandoned the EAV storage method for sales order information. Don't worry ...
Adding column to sales_order_grid database table. Columns are added to database tables using InstallSchema script. To be consistent, this script should be ...
-2-x- Programming/How-to-add-custom-field-in-order-sales-tabl.
You can go to the configuration of the order grid by going to Sales -> Orders. Go ...