How to set a price more than 100 million? Tried this solution http://www.magentocommerce.com/boards/v/viewthread/210738/P15/#t454441, but no luck. Now I can set price more than 100 million, but on the frontend it automatically converts to 100 million special price. If changing values in DB directly, everything fine, before you make changes in admin panel. Thanks in advance.
You have to change
value column in database table
catalog_product_entity_decimal. Also you have to change all price columns in these tables:
Export your database, edit your sql file using text editor like sublime or atom or etc that can find and replace text. Search for decimal(12,4) and replaced it with decimal(13,4), 13&12 means how much number you will save in database colum structure including 4 decimal places. Then finally you can import your database.