store two decimals

This support ticket is created 4 years, 8 months ago. There's a good chance that you are reading advice that it now obsolete.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-	-	9:00 – 13:00
14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-	-	14:00 – 18:00

Supporter timezone: Africa/Casablanca (GMT+01:00)

This topic contains 0 reply, has 1 voice.

Last updated by matthewL-7 4 years, 8 months ago.

Assisted by: Jamal.

Author

Posts

October 17, 2020 at 2:42 pm #1814779

matthewL-7

Hi, I have implemented the code mentioned here to limit a field to 2 decimal places - https://toolset.com/forums/topic/types-number-field-set-number-of-decimal-places-to-2-for-product-price-in-gbp/. However imports still allow more than 2 decimal places, and I am mostly importing records, so this doesn't really solve my issue. My question is, is there a way to limit the field, e.g. could I edit it in MySQL or does it not actually exist as a field in the database where I could change may decimal places?