Archived

This topic is now archived and is closed to further replies.

ISO_countries updated

0 posts in this topic

Posted · Report post

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,

Share this post


Link to post
Share on other sites

Posted · Report post

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

Share this post


Link to post
Share on other sites

Posted · Report post

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.

Share this post


Link to post
Share on other sites

Posted · Report post

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?

Share this post


Link to post
Share on other sites