2

I am new to magento, If I want to add custom fields to sales_flat_order table how Can I do?

sales_flat_order

sales_flat_order_address

sales_flat_order_grid

sales_flat_order_item

sales_flat_order_payment

sales_flat_order_status_history

there are 6 tables are link up one to another. So if I want to add custom field/column to sales_flat_order table.

Is there required to add another 5 tables to reference field/column? please guide me in-detail?

guide/suggest me what is the relation between those 6 tables how it forms together at the run time when saving/updating/deleting/reading orders.

Thanks.

1

You don't need to add columns to all the tables.
If you need it in the sales_flat_order add it there.
If you need to view the column value in the orders grid then you should add it for the table sales_flat_order_grid. If this is the case see a nice explanation on how you can continue with the new column in the grid

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.