3 replies to this topic

[sexyinlace]

Greetings all,
I thought I would share the information I found today. ISO_countries updates and a few new countries added for those of us that ship globally.

Updated lines that are currently NULL (ISO3 and numcode) in ISO_countries DB

id iso printable_name iso3 numcode
8 AQ Antarctica ATA 10
29 BV Bouvet Island BVT 74
31 IO British Indian Ocean Territory IOT 86
45 CX Christmas Island CXR 162
46 CC Cocos (Keeling) Islands CCK 166
76 TF French Southern Territories ATF 260
93 HM Heard Island and Mcdonald Islands HMD 334
137 YT Mayotte MYT 175
164 PS Palestinian Territory, Occupied PSE 275
189 RS Serbia SRB 688
198 GS South Georgia , the South Sandwich Islands SGS 239
212 TL Timor-Leste TLS 626
227 UM United States Minor Outlying Islands UMI 581
240 ME Montenegro MNE 499

New Countires to add to DB

id iso printable_name iso3 numcode
241 AX Aland Islands ALA 248
242 JE Jersey JEY 832
243 GG Guernsey GGY 831
244 IM Isle of Man IMN 833

There is also Serbia and Montenegro to add which seems a bit redundant since they are still on the list seperately. Looks a bit messy in the previews but I am sure you will get the point!
245 CS Serbia and Montenegro SCG 891


Hope this helps sombody!
Regards,

[Bibi20]

Greetings all,
I thought I would share the information I found today. ISO_countries updates and a few new countries added for those of us that ship globally.

Updated lines that are currently NULL (ISO3 and numcode) in ISO_countries DB

id iso printable_name iso3 numcode
8 AQ Antarctica ATA 10
29 BV Bouvet Island BVT 74
31 IO British Indian Ocean Territory IOT 86
45 CX Christmas Island CXR 162
46 CC Cocos (Keeling) Islands CCK 166
76 TF French Southern Territories ATF 260
93 HM Heard Island and Mcdonald Islands HMD 334
137 YT Mayotte MYT 175
164 PS Palestinian Territory, Occupied PSE 275
189 RS Serbia SRB 688
198 GS South Georgia , the South Sandwich Islands SGS 239
212 TL Timor-Leste TLS 626
227 UM United States Minor Outlying Islands UMI 581
240 ME Montenegro MNE 499

New Countires to add to DB

id iso printable_name iso3 numcode
241 AX Aland Islands ALA 248
242 JE Jersey JEY 832
243 GG Guernsey GGY 831
244 IM Isle of Man IMN 833

There is also Serbia and Montenegro to add which seems a bit redundant since they are still on the list seperately. Looks a bit messy in the previews but I am sure you will get the point!
245 CS Serbia and Montenegro SCG 891


Hope this helps sombody!
Regards,

Hi Lynn,
Thank you so much for doing this list! It was exactly what I needed - a customer from Montenegro couldn't order from us as we still had Serbia & Montenegro together and I thought it was going to be a lost sale as I had no clue what to do. I registered with cubecart forums just so I could write you a thank you note!
Thanks again
Bibi

[sexyinlace]

Hi Lynn,
Thank you so much for doing this list! It was exactly what I needed - a customer from Montenegro couldn't order from us as we still had Serbia & Montenegro together and I thought it was going to be a lost sale as I had no clue what to do. I registered with cubecart forums just so I could write you a thank you note!
Thanks again
Bibi

Hi Bibi,
Thanks, I am glad I could make a contribution after all this time. Since I have been using everybody elses tips for so many years.

[salvador21]

Thanks, I am confused by the ID number. In cubecart countries and zones there is no field to enter that number, all the other fields are there (ISO, name ISO3 and num code). Where do we add the ID number please?