Price more than 100 million

The question:

How to set a price more than 100 million? Tried this solution, 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.

The Solutions:

Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.

Method 1

You have to change value column in database table catalog_product_entity_decimal. Also you have to change all price columns in these tables: catalog_product_index_price, catalog_product_index_price_tmp, catalog_product_index_price_final_tmp.

Method 2

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.

All methods was sourced from or, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Comment