Black Friday 2026 50% off every plan Our biggest deal of the year on #1 Joomla products.
Ends in 11d 18h 25m 32s
Claim 50% off
Solved Templates

Estate Template - Fixed price problem

Asked by Douglas 5 years ago Last activity 5 years ago

Hi guys,

I'm having a problem with the fixed price.

On the item page the price displayed is correct. On the home page I have the same items, but all prices are incorrect.

There's also another issue, the maximum price is $1,000,000 , any price bigger than that is not being displayed.

Thank you.

Accepted answer

Marked as the solution
Ofi Khan Staff

Hello Douglas

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.

Please share your administrator access here to check the price issue. Use the Hidden Content box to share the credentials.

Best regards

7 more replies

Douglas Asked this
5 years ago · edited

Hello Ofi,

Thank you very much for your attention.

Done. Now it's working on the item page, but it's not working on the home page, where all the properties are listed.

Ofi Khan Staff

Please share your Super Administrator access here to check the issue. I could not access SP Property with the credentials.

Douglas Asked this

Done!

Ofi Khan Staff

Your issue is fixed now. Please check your site.

Douglas Asked this

Thank you very much!

I would like to know what was going on and how to fix that.

Ofi Khan Staff

You are welcome. I have modified this file: templates/shaper_estate/html/mod_spproperty_properties/default.php

Log in to reply.