Change field type

For future users who might be facing the same problem:

Go to [wp_prefix]_wpl_dbst table and look up for the field you want to edit. You can change its type in the ‘type’ column.

Changing back to unresolved. The solution above caused problems in my database that I wasn’t able to add listings.

Hi,

The simplest way is the following:

1- Create a new price field using Flex menu.
2- Run a SQL and insert value of field[text_field_id] to field_[new_field_id] and field_[new_field_id]_si columns.
3- Fill field_[new_field_id]_unit with your desired currency ID. You can find currency IDs in the [wp_prefix]_wpl_units (type = 4). For example 260 is ID of USD.
4- Remove the text field from Flex menu and use new price field from now on.

Note: If your selected currency ID is not USD then you should write a PHP script to convert the value of field_[new_field_id] to USD and then store it in the field_[new_field_id]_si column. You can find the exchange rates on [wp_prefix]_wpl_units table. As another approach you can write a PHP script to finalize all of your listings automatically. Then WPL converts the price to USD itself.

Regards,
Realtyna support team