Is One Million Max Value In SP Property? - Question | JoomShaper
SP Page Builder 6 is Here! Learn More →
Back to the questions

Is One Million Max Value In SP Property?

HH

H.G.P. Hendriks

Extension 3 years ago

Hi,

I use SP Property for my clients website. They sell villa's in Spain for -sometimes- over One million euro. But it seems 1.000.000 is the max value we can fill in. If we say the property costs 2 million (2000000) and click save, the amount is set back to 1 million (1000000). Is there indeed a max value set up? And if yes, where can i change this?

Regards, Remco Henk ICT Services

0
Website
https://www.resa-estates.com
3 Answers
Order by
Oldest Newest Votes
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 3 years ago #41360

Hello H.G.P. Hendriks

Yes, you are right. You cannot add more that 10,00,000 in SP Property -> Property Price. If you want to increase the digits, then you have to change in the database. Please run this SQL query on your database. By default, the value is FLOAT(8,2). If you make it FLOAT(9,2), then you can add 1 more digit in the price 1,00,00,000

ALTER TABLE `xxxxx_spproperty_properties` CHANGE `price` `price` FLOAT(9,2) NOT NULL DEFAULT '0.00';

Use your table prefix instead of xxxxx on the table name.

Best regards

0
S
Siniša Ravlić
Accepted Answer
3 years ago #52218

Hello, I have this problem when trying to change values:

https://prnt.sc/26db729

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 3 years ago #52254

Hello Siniša Ravlić

I need to check your site. Please post a new question with your site credentials on the hidden content. I will check and fix your issue.

Best regards

0