Problem with insert price

[Schilo]

Hello! When I add product on my website and I insert a 6-digit amount I have no problem but once I insert an amount to 9 or 11 numbers as amount, it does not work.

For example if I insert $ 25,000 I have no problem, but I insert $ 250,000,000, after saving the addition of this product I find as price $ 100,000,000 and not the amount I inserted. 

Can you help me to fix this problem?

[Sinisa]

That's Magento's limitation on prices. If you want to increase price maximum, you have to modify tables in where all prices are set. Those tables are:

catalog_product_entity_decimal
catalog_product_index_price
catalog_product_index_price_tmp
catalog_product_index_price_final_tmp

But, also you'll have to modify all quote/order/invoice/creditmemo related tables, which means all tables with prefix sales_*.

What do you have to change? You have to modify every column whose type is decimal(12,2) to something like decimal(20,2).

For example, if you want to do that on catalog_product_entity_decimal table and its column value, you have to execute following SQL query:

ALTER TABLE catalog_product_entity_decimal MODIFY COLUMN `value` decimal(20,4) DEFAULT NULL COMMENT 'Value';

I'm pretty sure that there are a lot of such places.