Updates to Salesforce OPPORTUNITY_LINE_ITEM Fields Aren't Reflected in the Destination

You may notice that updates to the ListPrice or Name field in the Salesforce OPPORTUNITY_LINE_ITEM table aren't reflected in the destination, even though the data has changed in Salesforce.

Why some OPPORTUNITY_LINE_ITEM field updates are missed

In Salesforce, when you update the ListPrice or the Name field for an existing OPPORTUNITY_LINE_ITEM record, its SystemModstamp or LastModifiedDate fields aren’t modified. As a result, we can't capture these updates in our incremental syncs.

How to ensure OPPORTUNITY_LINE_ITEM field updates are captured

Contact our support team to enable the re-import of the OPPORTUNITY_LINE_ITEM table. Once enabled, we will re-import this table regularly to capture all updates for this table.