Copado Data Deploy for CPQ

Updated 3 months ago by Copado Solutions


As part of the Copado Data Deploy feature, Copado has configured pre-built data templates to help you deploy data for several widely-used tools such as Salesforce CPQ:

If you are not familiar with data templates, a data template is a configuration file that defines a data structure you want to migrate between Salesforce orgs. For example, in CPQ, you can have a data template for the price book, another one for the price rule, etc.

These pre-built data templates have been designed to:

  • Speed up your data deployment process
  • Save you the hassle of deploying different data templates in several steps or deployments. You can select parent and child records within the main object template and deploy them in one go.
Please note that although you can deploy related records by deploying the main template, you will need to create a data template for each of the records you want to deploy and select them within the main template.

When you download a pre-built data template, the template is exported in a JSON file that you can then import to any of your Salesforce orgs. This JSON file includes the template of the main object and those for each of the related objects selected.

Once the templates have been imported, open each imported template record to select the External Id field since this is not included by default. This field prevents you from inserting duplicate records when deploying templates between orgs.
You can use Copado's Automatic Record Matching feature to populate a value for the External Id Field.

Since every CPQ configuration is different, you may need to adjust the data templates to ensure they match your requirements.

Important Considerations Before Deploying

When working with data deployments, there are some things you should bear in mind to guarantee a successful deployment, even more so when deploying CPQ data given its complex structure. Here is a list of the most important things to consider:

  • It is a good practice to disable CPQ triggers in the destination environment before deploying. To do so, follow the steps below:
  1. Navigate to Setup > Installed Packages > Salesforce CPQ > Configure.
  2. Open the Additional Settings tab and flag the Triggers Disabled checkbox:


  • Make sure you have the same version of Salesforce CPQ installed in the source and destination environments.
  • If you are deploying to or from a production organization, make sure there is a user with a CPQ license in that production organization.
  • Make sure Salesforce CPQ global picklist values match in the source and destination environments.
  • The user you use to create the credentials for the destination orgs needs to have write access to all the objects included in the data templates.
  • Assign the Salesforce CPQ Admin permission set to the org credential user.
  • If you are using multi-currency in your source organization, ensure this is enabled in the destination organization, and currency ISO codes match your source and destination organizations. 
  • In your Salesforce destination organization, ensure the Standard Price Book is active.
  • Create external Id fields in all your CPQ objects. 
  • Import the desired data templates into Copado.

For more information about best practices to keep your data clean and ready to be deployed, check out the article Copado Data Deploy Best Practices.


Salesforce CPQ consists of objects which contain reference data, such as products or price books;  objects that include transaction data, such as opportunities, and objects for internal use. For this reason, CPQ data should be migrated following a specific order. Here are some guidelines about the order in which CPQ data should be deployed:

  • When migrating all CPQ records to an org, deploy the Price Book template first, followed by the Products, Price Rules, Product Rules, Quote Terms, and Quote Templates.
  • If you only need to deploy one type of CPQ record (e.g., only price rules), deploy this single template.
  • When deploying price records (PricebookEntry), do not check the Product Code and Product Name fields in the PricebookEntry template since these are not updatable.
  • If the CPQ triggers are not disabled, you may experience errors with custom conditions linked to the price rules template, given that these records need to be upserted following custom logic. To avoid this issue, uncheck the Conditions Met field in the price condition template the first time you execute the deployment to avoid condition validations, and redeploy it again with this field selected.

Post-Deployment Steps

Once the deployment has been completed successfully, it is important to re-enable the triggers you deactivated before deploying.

To re-enable CPQ triggers in the destination, follow the steps below:

  1. Navigate to Setup > Installed Packages > Salesforce CPQ > Configure
  2. Open the Additional Settings tab.
  3. Deselect the Triggers Disabled checkbox.
  4. Click on Save.
  5. Once you have re-enabled the trigger, don’t forget to run Salesforce CPQ post-install scripts to detect and fix any potential issues with the deployed records. 

How did we do?