store two decimals

This support ticket is created hace 4 años, 4 meses. 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)

Este tema contiene 0 respuestas, tiene 1 mensaje.

Última actualización por matthewL-7 hace 4 años, 4 meses.

Asistido por: Jamal.

Autor

Mensajes

octubre 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?