Happy Business Starts Here

Foreign key external ID: xxx not found for field zqu__ZuoraId__c in entity zqu__ZProduct__c

Highlighted
Support SME
Support SME

Foreign key external ID: xxx not found for field zqu__ZuoraId__c in entity zqu__ZProduct__c

Question or Problem Statement
We have a Product that had previously been synced to SFDC was removed and now will not sync back over. When I try and sync it I get the below error:
Update INVALID_FIELD:Foreign key external ID: 2c92a0fb4e292826014e2af7f915463f not found for field zqu__ZuoraId__c in entity zqu__ZProduct__c 2c92a0f94e291b72014e2af7fde9349d a4b500000009z32AAA






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Support SME
Support SME

Re: Foreign key external ID: xxx not found for field zqu__ZuoraId__c in entity zqu__ZProduct__c

Solution:
Generally speaking, this error is caused by the data migration or refresh. This error means that Z360 attempted to Update the product a4b500000009z32AAA with Zuora tenant product ID 2c92a0fb4e292826014e2af7f915463f, but Z360 could not locate SFDC record Id a4b500000009z32AAA. You can verify if a4b500000009z32AAA is existing in your SFDC by using(for example) https://naXX.salesforce.com/a4b500000009z32AAA. If it is not existing in your SFDC, please do a query with 2c92a0fb4e292826014e2af7f915463f in your SFDC developer console to see if there is a product in your SFDC.

Query:
SELECT Id, Name, zqu__ZuoraId__c FROM Product2 where zqu__ZuoraId__c = '2c92a0fb4e292826014e2af7f915463f'

If there is, please delete this product then do a product catalog sync from Zuora tenant, the error should be fixed.






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

Tags (1)
1 REPLY 1
Highlighted
Support SME
Support SME

Re: Foreign key external ID: xxx not found for field zqu__ZuoraId__c in entity zqu__ZProduct__c

Solution:
Generally speaking, this error is caused by the data migration or refresh. This error means that Z360 attempted to Update the product a4b500000009z32AAA with Zuora tenant product ID 2c92a0fb4e292826014e2af7f915463f, but Z360 could not locate SFDC record Id a4b500000009z32AAA. You can verify if a4b500000009z32AAA is existing in your SFDC by using(for example) https://naXX.salesforce.com/a4b500000009z32AAA. If it is not existing in your SFDC, please do a query with 2c92a0fb4e292826014e2af7f915463f in your SFDC developer console to see if there is a product in your SFDC.

Query:
SELECT Id, Name, zqu__ZuoraId__c FROM Product2 where zqu__ZuoraId__c = '2c92a0fb4e292826014e2af7f915463f'

If there is, please delete this product then do a product catalog sync from Zuora tenant, the error should be fixed.






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

Tags (1)