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

asked Jul 19, 2016 by gmxindia (370 points)
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

1 Answer

answered Aug 2, 2016 by Pavel.g (3,580 points)
selected Nov 15, 2016 by seotoaster
Best answer
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.