The cost attribute (not the price) is locked to "Website". We have a situation where we sell the same product in different countries and as such the cost of the product is actually different. For example the landed cost to the USA may be $5, but the landed cost to the UK is $7.50.
We'd like to be able to run Magento's reports and see the total product sales/profit. And we'd like to be able to see the sales/profit for the USA store and for the the UK store separately. We would do this based on Websites instead (and do Show Report For: All Websites), but we have other websites on the same Magento installation so this wouldn't give us the data we need.
There is no built in way to change the Cost attribute to Store View, but if we were to manually do so would it cause any problems?
What is the best way to make the change? Modifying the DB, or creating a module that does it, or?
What are the potential problems with doing this?