Resolving Missing Hong Kong and Taiwan Geo Locations in Salesforce

Information

Issue: Hong Kong and Taiwan Geo Locations not appearing under Geography in Salesforce.

Resolution Steps:

1. Verify Configuration:
   • Ensure that the inventorySyncStrategy.json file is correctly configured.
   • Check that "INCLUDE_ALL_TOP_LEVEL_GEO_ITEMS": true is set, but note that this alone may not include all regions.
2. Modify Configuration:
   • Explicitly list Hong Kong and Taiwan as "REGION" items in the configuration.
   • Example configuration:

     {
         "geoItems": {
             "synchronize": true,
             "geoItemFilter": "csdf__Code__c IN ('HK','TW')",
             "settings": { "INCLUDE_ALL_TOP_LEVEL_GEO_ITEMS": true },
             "items": [
                 {
                     "type": "REGION",
                     "filters": {
                         "include": [
                             [{ "field": "Code", "value": "HK" }],
                             [{ "field": "Code", "value": "TW" }]
                         ]
                     }
                 }
             ]
         }
     }

3. Upload Configuration: 
   • Ensure the configuration file is uploaded as an attachment, not as a file, to the Ad Server.
4. Run Inventory Synchronization: 
   • Trigger the inventory synchronization process.
   • Verify that the synchronization completes without errors.
5. Verify Resolution: 
   • Check Salesforce to confirm that Hong Kong and Taiwan are now appearing under Geography.
   • Use the following query to verify: 

     SELECT Id, Name, csdf__Category__c, csdf__Code__c, Top_Level_Node__c FROM csdf__Geo_Item__c WHERE CreatedDate = TODAY

Note: Ensure that all incoming and outgoing messages are processed correctly to avoid synchronization issues.