Price And Currency In SP Property Component - Question | JoomShaper
SP Page Builder 6 is Here! Learn More →

Price And Currency In SP Property Component

AI

Afunaduula Isaac

Extension 3 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.
0
3 Answers
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 3 years ago #53825

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

0
AI
Afunaduula Isaac
Accepted Answer
3 years ago #53830

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

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

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.

0