I'm using Magento2. When I add a new product with a price of 416000000 the price is reset to 100000000 after save. How can I fix it?
This is due to the restriction on database level where the product price is stored in a colum of type
This means there can be 8 digits to the left of the decimal point (12-4) and 4 to the right of the decimal point.
If you want to change this, wou will have to modify all tables and columns where the price is stored and set the type of the colums to at least
decimal(13,4) according to your example.
Check out these tables where the product price, quote and quote item totals, order and order item totals price are stored and identify colums which you need to update (no guarantee for completeness):
catalog price table
quote and sales tables
sales_order, quite a lot of columns. Most important are the
quote, similar/the same colums as in the
also check out the other index tables for bundle, configurable and downloadable products (if needed).
I hope this helps you getting started with it. I'd say that's a lot of work to update all the colums in your database.
Also you have to do some intensive testing to see and check if the price gets somewhere reset again after updating all your columns.