Hello,
Within CB Subs settings > Invoice I have mapped the country field to cb_country as an SQL query field.
I used the following code:
SELECT `country_name` FROM `#__comprofiler_countries`
and edited Great Britain to be United Kingdom within comprofiler_countries which shows United Kingdom within the registration process however, when going through the checkout process the country field is blank.
If the user edits their details within the checkout United Kingdom does not appear but Great Britain does.
The field cb_subs_inv_address_country has Great Britain rather than United Kingdom and most people would not search for Great Britain.
I have searched the tables in the database for cb_subs_inv_address_country with no results.
I tried Great Britain and GB but couldn't find that either.
I tried the tables subs_geo_zones and subs_geo_zones_entries but it is not in there either.
Can you please tell me which table I need to find so as to change Great Britain to United Kingdom please?
Many thanks in advance.
Life is a constant learning curve and I've just started out!