Recently, we’ve faced a data inconsistency in the Magento sales_flat_order_grid db table. Some of the values in custom columns look like they were shifted. This issue may occur if the order grid has multiple custom fields and when a user archives orders in the Enterprise Edition.

Does your Magento order grid have all of the fields you need? Adding or removing columns is fairly simple. Let’s explore how.