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.

Sometimes handling multiple store views/stores/websites within a single Magento installation may mess up attribute values on the different scope levels. We’ve recently faced similar problem with product prices. Some price values were changed on the scope level after data migration and it was almost impossible to detect and remove such values from the Magento admin panel. So we’ve decided to create a shell script for that purpose and share it with you.