Common Magento Tables - sales_order. The sales_order table ( sales_flat_order on M1) is where each order is captured. In most cases, ...
sales_flat_order_grid works like an index to make displaying, sorting and filtering in the order grid faster and not blocking the real order tables.
I am trying to understand the use of different columns present in magento sales_flat_order table.. this is what i have got so far.
Try: getConnection(' core_write'); ?> And: query("UPDATE sales_flat_order SET grand_total ...
In your module's config.xml file user this event
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopdb. sales_flat_order' doesn't exist, query was: SELECT `main_table`.
Where is it generated? If you look in app/code/core/Mage/Sales/Model/Order.php on around line 2052 , you will find the following:
Solved: Hello, I created a new column ( CHECK_CUSTOMER ) in sales_flat_order table. When i place an order from frontend, i need to insert ...
Custom Reports in Magento with Clean_SqlReports
OpenMage / magento-lts · Add two indexes, in sales_flat_order & sales_flat_order_item #384 · Add two indexes, in sales_flat_order & ...