IF the price of a product is greater than 1000000 then its taking value as 1000000

Question

if the product price is greater than 1000000 then its displaying as 1000000

we tried to enter the price of product as 4905000. Its displaying as 1000000. Can you please look into this

Answer 1

Hello gmxindia.

Thank you for question.

Yes, now there is such a restriction.
To change this please run this query to its database:

ALTER TABLE `shopping_product`
CHANGE `price` `price` decimal(20,4) NULL AFTER `full_description`;

Regards, Pavel.