To optimize the database, I would still disable all zones that you are not using since the payment and shipping extensions may still rely on the geo zone IDs whereas unused locations might still be used. Other than that, you are correct to state that where the countries are enabled, the dropdown menus should also be relative based on the selected country.Live_Life wrote: ↑Sat Jul 15, 2023 2:10 amOk, just updating this. Backup your Database.
MyPHPAdmin > Choose Your DataBase > SQL Tab > UPDATE `xxxx_country` SET `status`='0' WHERE 1
In the UPDATE command, you need to change xxxx whatever prefix your database uses. > Go
This changes all counties to disabled status.
You can then enable all country(s) you need in Settings>Localization>Countries like just the USA or UK or whatever.
As far as, I can tell you don't need to worry about zone settings because Zones will only work if the Country is enabled. So like you enable US Country only those Zones and States show up in drop-downs. Though, I am not sure if I have tested it all.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: Amazon [Bot], Bing [Bot], Majestic-12 [Bot] and 24 guests