SP Property add coins - Forum | JoomShaper
Staff replied Extensions

SP Property add coins

Asked by infolocal 7 months ago Last activity 7 months ago

Hello, how can I add the Colombian currency to SP Property and add the price in millions and square meters? Thanks

3 replies

Oldest first Newest first Most helpful
Ofi Khan Staff
7 months ago

Hello infolocal,

Thank you for reaching out to our technical support forum. I’m sorry to hear about the trouble you’re experiencing.

Please add your currency in these files: 

administrator/components/com_spproperty/models/fields/spcurrency.php
administrator/components/com_spproperty/config.xml

Then you will be able to use the currency on SP Property.

Best regards

infolocal Asked this
7 months ago

Great, thank you very much, I was able to add the Colombian currency.

Now, for the fixed price option, I need to enter the value of a property, which could be 550 million COP. The field doesn't allow it. How can I configure it to allow larger amounts? For example: 550.000.000 COP

Thanks

Ofi Khan Staff
7 months ago

You are welcome 😊

You cannot add more than 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.

Log in to reply.