Price and currency in SP Property Component - Forum | JoomShaper
Staff replied Extensions

Price and currency in SP Property Component

Asked by Afunaduula Isaac 4 years ago Last activity 4 years ago
  1. Adding a new currency to the exisiting list is not easy although i have been advised to edidt the php file.
  2. I cant add a price in millions, it says the value entered exceeds the limit
  3. It lists the price of property at cost per sqft, i cant put a single full price of the property.

3 replies

Oldest first Newest first Most helpful
Ofi Khan Staff
4 years ago

Hello Afunaduula Isaac

Here are the answers:

  1. For Currency, go to this location: administrator/components/com_spproperty/models/fields and edit spcurrency.php file.
  2. 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.

  1. Set the property price to Fixed
    https://prnt.sc/26iju5s

Best regards

Afunaduula Isaac Asked this
4 years ago

thabks,thanks,

nb, i dont have coding skills. i am using basic knowledge.
i need to increase the amount because shillings are too low compared to dollar.
30,000 usd =shsshs 100100,000,000

Ofi Khan Staff
4 years ago

In that case, please share your administrator access here to check the issue. Use the Hidden Content box to share the credentials. Also, what is the highest value that you need for the price? I will try to make it for you.

Log in to reply.