Add Montenegro - ME to the country list

Imar Spaanjaars

Posted on 05/06/2018 22:34:31

A customer reported that Montenegro is missing from the Ecom country list. "Serbia and Montenegro" is there, but that's no longer a country. Can that be added to the list? And maybe review the entire list?

Thanks,

Imar

Replies

Nicolai Pedersen

Posted on 12/06/2018 09:54:41

Yes, of course. Why change the world ? :-).

You can run this:

IF NOT EXISTS( SELECT [ISOCode2] FROM [EcomGlobalISO] WHERE ( ISOCode2 = 'ME' ) )
                        INSERT INTO EcomGlobalISO (
       [ISOCode2]
      ,[ISOCode3]
      ,[ISOCountryNameDK]
      ,[ISOCountryNameUK]
      ,[ISOCurrencyDK]
      ,[ISOCurrencyUK]
      ,[ISOCurrencyCode]
      ,[ISOCurrencyCodeOld]
      ,[ISOCurrencySymbol]
       )
                        VALUES ( 'ME', 'MNE', 'Montenegro', 'Montenegro', 'Euro', '', '978', '40', 'EUR' )

Should probably change this to use Globalisation API instead!

Imar Spaanjaars

Posted on 12/06/2018 20:37:55

Yeah, we fixed it in a similar, if not identical way. My post was mostly about getting it done on the core product so it's just there by default. Is that the plan?

Thanks!

Imar

Nicolai Pedersen

Posted on 12/06/2018 23:23:41

This post has been marked as an answer

Yes, it was added for 9.5 in the same go :-). TFS#51382

Votes for this answer: 1

Developer forum

Add Montenegro - ME to the country list

Replies