Subscription Product & Charge Object currently has a lookup to a custom Product Object

[benj]

Subscription Product & Charge Object currently has a lookup to a custom Product Object and we need to be able to lookup to the native salesforce Product2 object. I can see that the lookup is deprecated but there doesn't appear to be an alternative.

Is this something that is pending fix in an upcoming release?

The lookup relationship on the Subscription Product & Charge object:

The lookup to the custom Product object:

[benj]

To give the full picture the object highlighted in red is the managed Product object and it has no relationship to the Product2 native object.

[Ben-]

The Product2, Product Rate Plan, Product Rate Plan Charge hierarchy is Zuora Quotes, not Zuora for Salesforce. Because of this we've always had to use triggers to link the SP&C to the product catalog info we need for reporting.

Thankfully the more recent versions of Zuora for Salesforce include the Zuora__ProductRatePlanChargeId__c field and it's a lot easier than it used to be.

[benj]

Thanks Ben,

Reporting is where we are having some trouble too. Having spoken to a support rep at Zuora and now tested myself, the Zuora__Product__c object syncs to Salesforce with the Accounts & Objects related sync whereas the Product2 object syncs with the Product Catalog sync. It looks like this was intended behavior and I think by recreating all fields that are needed in reporting as custom fields in Zuora on the Product and on the Zuora__Product__c object in Salesforce and syncing across then it will sync to both the Product2 and the Zuora__Product__c objects.

What my follow-up question would be is how this works when bundling is enabled and managing the product catalog from Salesforce. With this enabled you have to sync from Salesforce to Zuora, I'm not sure which object it would sync from. Will try and test soon.