Price Issue

[yoyoypy]

**Ideally we would expect you to raise a bug on AvoRed Official Website **
https://www.avored.com/discussion/category/general

Describe the bug
i was edit product price from USD to local currency. but it show up error in SQL

To Reproduce
Steps to reproduce the behavior:

1. Go to Product
2. Click on Edit/create
3. Scroll down to price
4. change to 4000000
5. boom error

Screenshots

**Desktop (please complete the following information):

• Version 3.0.1

[yoyoypy]

my product on local currency start from millions btw

[indpurvesh]

@yoyoypy
Usually, how big the price goes?
Right now to save some MySQL memory I have setup field with 10, 6 I have to come up some kind of alter in the case like yours.

[yoyoypy]

is this happen in update product ?
or maybe in customer check out too?
in case some customer check out more than 1 item or price of exclusive product, can we change it to 100.000.000?

[indpurvesh]

@yoyoypy I would suggest to open your database and alter the database field in products table

[yoyoypy]

done changing from decimal to INT

[yoyoypy]

@indpurvesh

changing decimal to INT will get error on checkout page, but i just changing dec 10.6 to 10.2 which is work in homepage but still got error in checkout page..

do i miss something or i can change that total cart to 11.2?
which one i should change?