How to Set Up Custom Opportunity Product Field Sync in Salesforce
Overview
This guide walks you through the process of configuring a custom opportunity product field in Salesforce and ensuring it syncs correctly with PandaDoc.
Prerequisites
- You must have admin permissions in Salesforce.
- Ensure you have PandaDoc integration enabled in Salesforce.
Step 1: Create a Custom Field in Salesforce
- Navigate to your Salesforce Opportunity.
- Create a Custom Field with the same Label and API Name as your existing fields.
- Populate the values (e.g.,
1, 2, 3).
Step 2: Configure Field Sync in Salesforce
- Go to Salesforce Setup.
- Add the newly created custom field to Configure Tokens.
- You can do this via the PandaDoc Documents Widget or the PandaDoc Setup Page.
- Click on Configure Tokens.
- Select Opportunity Product.
- If it is not available, add it manually.
- Choose Duration (Non-Recurring).
- Click Save.
Step 3: Configure Workflow in PandaDoc
- Open Workflows in PandaDoc.
- Unpublish the workflow to make changes.
- Locate the Pull Data from Integration step:
- Go to the Data tab.
- Click Refresh to ensure all fields are updated.
Step 4: Configure Quote Fields
- Navigate to the Create Quote step.
- Add a Custom Column:
- Select New Column.
- Choose Text as the field type.
- Name it Duration.
- Click Save.
- Move to the Data tab in the Create Quote step.
- Click on Setup.
- Map the Quote Column (Duration) to Duration (Non-Recurring) in Salesforce.
- Click Save.
Step 5: Publish and Test
- Publish the Workflow.
- Start a New Workflow.
- Verify that the opportunity product field values appear correctly (e.g.,
1, 2, 3). - Modify the values (e.g., change to
5, 5, 5). - Click Next.
- Create a Document (this triggers the sync process).
- Return to the Opportunity in Salesforce and check if the Duration field is updated.
Notes
- The field sync occurs after document creation, not during quote creation.
- The document does not need to be sent for the sync to complete.