Subscription Product Charge not Syncing to Salesforce due to missing picklist Value in Custom Field
Subscription Product Charge is not syncing to Salesforce when tried multiple times for a particular product only and the Rate Plan is already existing in Salesforce. It also had the Product and Product Rate Plan existing in Salesforce.
It failed with the error :
INVALID_FIELD:Foreign key external ID: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx not found for field Zuora__External_Id__c in entity Zuora__Product__c
In this case, there was a custom field in Salesforce in the zuora__product__c object which was of picklist value Family__c and the picklist value Network Services was not there in Salesforce for that field.
The Subscription Production Charge could not sync for that product because the Family field had the value Network Services which was not present in the Salesforce end.
As a generic statement to be said when a field in the Product Object uses a picklist value that is not present in SFDC but in Zuora then they will fail to sync to Salesforce. Thus kindly check if the Picklist values are populated as the same in Zuora.