Edit Checkout Pages: Translate Billing Country or State Fields Dropdown

Link: https://support.brilliantdirectories.com/support/solutions/articles/12000063347

Editing States or Provinces


To edit states or provinces, contact support by Clicking Here and request to enable this Advanced Setting "Use Custom State / Provinces List". 


The system will use the website's local list of states/provinces in the drop-down menu when it is turned on. 

This is useful to set on if needed to use a custom set of states or translate the states and provinces into an alternative language. When this is turned on, the admin can modify the states directly in the MySQL Database.


Editing Countries 


In the meantime, the only way to translate the country names is through the database.

NOTE: No need to contact support to do this.  


 

Steps to edit Countries and States / Provinces


1. Go to Developer Tools >> MySQL Database:




2. Click on the "Directory" option in the left sidebar, it will open a lot of tables that are inside the "Directory" folder: 




3. In the left sidebar, find the table called "list_countries" to edit the Countries.
And find the table called "list_states" to edit States and Provinces.

4. Double click on the name country that needs to be translated (Step 2 below) and hit enter when finished.   

Changes are saved automatically. 




Example: Let's say that it needs to be translated to Spanish:




To go to the next page click here: 




Once the translation/edition has been completed close the database and go back to the admin and navigate to Dashboard >> Refresh Live Website.


State Dropdowns


If the "Country" field is hidden in the form (for example, in the Checkout or Signup pages), the State/Province dropdown will not load any values unless a default country value is defined.


This happens because the State field is dynamically populated based on the Country field selection. If the country is not selected or preset, the system doesn't know which states to load.


How to Fix:


For example, if the statedropdown should show U.S. states, but the  Country field is hidden, add the country code as the default value (US) to that field:



You can do this in the Form Manager:

  1. Go to Settings > Form Manager.

  2. Find the Member - Sign Up form (or the form you're editing).

  3. Locate the country_code field (even if it's hidden).

  4. Click on the Gear icon to open the Field Settings

  5. Add US as the Default Value.

  6. Save the form.

Once set, the state dropdown will correctly populate with U.S. states even if the Country field is hidden.