Solved Templates

How to modify the 1 million $ price in Empire

Asked by Enrique 4 years ago Last activity 3 years ago

Hello,

I'm using the Shaper Empire template and there's a limitation when trying to display a property price over $1,000,000 (one million dollars), would be useful to provide intructions about how to deal with this:

Image link: https://prnt.sc/SLlxYhcQ1WW1

Please checl the image above to identify the referred template feature.

Regards!

Accepted answer

Marked as the solution
Ofi Khan Staff
4 years ago

Instead of xxxxx_spproperty_properties you have to use your database table name. Here xxxxx is your database table prefix name example. It could be anything. Please follow this screenshot:

https://prnt.sc/IHA1DHzWLbwe

4 more replies

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

Hello Luis

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

Enrique Asked this
4 years ago · edited

Hi,

Thanks for the answer, I checked my hosting and within there's only the option to access the phpMyAdmin element, could you provide more details about where to run the aforementioned query in data base. Please check the following screenshots:

PhpMyAdmin: https://prnt.sc/VcVBqjp3AZJm

I tested running the query here (replacing my database name): https://prnt.sc/5Lo3j7CCEXet

And I saw the following error: https://prnt.sc/2szUCRl9MOZ0

Thanks!

Enrique Asked this
3 years ago

Thanks for the help Ofi, the information allowed to fix the pricing issue.

Regards!

Ofi Khan Staff
3 years ago

You are welcome 😊

Please follow the steps:

  1. Select the database:
    https://prnt.sc/_WH6NBeXMWBP
  2. Now insert the SQL query. Check that I have changed the xxxxx part with g3jtd becuase g3jtd is my table prefix. So, you have to change according to your table prefix https://prnt.sc/vwOXeoYfVFgO
  3. Then run the SQL query
Log in to reply.