I'm currently working on a new Magento ecommerce solution for our website. Basically, I've migrated all the old data over using a tool for this purpose. However, the old orders have come over having a currency of $. I'm not sure why, as the base currency etc was set to £.
In any case, to fix it, the migration tool support suggested a re-migration of all the data again, not just the orders. However, we've updated the Magento data a fair amount and didn't really want to migrate again. So I'm wondering if there is another, safe solution to change older orders' currency, so it displays in £ and not $.
EDIT: Ok so on inspecting the table sales_flat_order, I can see that old orders have "USD" in the columns base_currency_code, global_currency_code, order_currency_code and store_currency_code. I'm simply planning to update the values in these columns to have the value "GBP" (after backing up the table first of course!).