xappex-icon-logo-dark Get Started Free

Merge Opportunities in Salesforce

By: Perez Victor | Published: April 27, 2026 | 8 min read
Share on Facebook Share on Twitter Share on LinkedIn
To merge Opportunities in Salesforce, you need a workaround because Salesforce does not provide a merge action for Opportunity records. Opportunities must be handled manually, through automation, or with external tools. The right approach depends on how many records you have and how complex the data is, including related records.

Why You Can’t Merge Opportunities

Salesforce lets you merge Accounts, Contacts, and Leads. But Opportunities are different, and there’s a reason for that. Accounts, Contacts, and Leads represent entities. When you have two records for the same person or company, that is usually a data error.
Opportunities are transactions; they handle different information, they include products, price books, activities, or any custom object related to them. Two Opportunities under the same Account might look like duplicates, but they could actually be different, like renewal or an upselling, or two completely separate deals for the same Account.
This is the reason Salesforce does not support merging Opportunities by design. It is not a missing feature; it’s a decision based on how complex the data model is.

When Not to Merge Opportunities

Not every Opportunity that looks like a duplicate is actually one. Multiple Opportunities related to the same Account can be intentional, for example:
  • A renewal Opportunity after a contract ends;
  • An upsell being tracked as a separate deal;
  • Separate deals with different products or price books;
  • Two Opportunities with different processes handled by different teams.
Merging any of these Opportunities would wipe out revenue history, break pipeline reporting, and create confusion for other users involved.
Before attempting to merge Opportunity records, ask yourself one question: Are these records tracking the same deal, or are these different processes?

How To Find Duplicate Opportunities

The first step to merging Opportunities is to identify real duplicate records. Real duplicates almost always relate to the same Account; if two Opportunities feel like duplicates but relate to different Accounts, that might be a data quality problem and should be handled differently.
What to look for when identifying duplicates:
  • Same Account
  • Similar Opportunity Name
  • Overlapping Close Date
  • Similar Amount

  • Same Owner

It’s important to note that duplicates are not always identical; usually, one of the records has partial information or outdated data.
A very common scenario for duplication is integrations, where records are created automatically, but sales reps keep creating Opportunities manually. Both records are active, but they are tracking the same deal.
Duplicates also tend to appear during specific moments:
  • Bulk data imports;
  • After integrating the external system;
  • Multiple users creating records in parallel.
Warning icon

Tip

Build a Salesforce report grouped by Account Name and filter for similar Opportunity names and overlapping close dates. You can then export that to a spreadsheet to easily spot duplicates.

Before You Merge

Merging Opportunities is a final decision. In Salesforce, once you merge records and the duplicate is gone, there is no “Undo” button. This makes preparation your most important step. Merging Opportunities directly affects data structure, reporting, and automations. In many cases, the merge process can fail due to permissions, limitations on related objects, or data dependencies.
Risks to keep in mind:
  • Closed Won Opportunities: Merging Closed Won Opportunities can break historical data, commissions, and forecasting, making it unreliable data.
  • Custom Child Objects: Some custom objects related to the Opportunities can block the process or fail to reassign correctly.
  • Permission and ownership: If users don’t own the records they are trying to merge, the process might fail.
  • Pricebooks: You cannot easily combine products from Opportunities with different pricebooks; this will have to be done manually.

  • Products: If both Opportunities have products, Salesforce won’t know which ones to keep. You have to decide which quantities and prices are correct before you proceed.

Warning icon

Tip

Always back up your data before attempting to merge Opportunities. This way, you make sure that if something goes wrong, you have the original data.

What Happens to Your Data

Because there is no native merge feature in Salesforce, most Opportunity merge workflows involve a combination of updates, reassignments, and record deletions. One Opportunity becomes the master record, and the other record is removed. What happens to related records depends on how the process is handled, for example:
  • Activities, Tasks, and Events: In most custom workflows, these records are reassigned to the master Opportunity by updating the lookup field. But this requires manual configuration; it’s not a built-in Salesforce rule.
  • Opportunity Products: An Opportunity can only handle one Pricebook at a time. If your two records use different ones, you’ll have to choose a single Pricebook for the master record, which means you might have to manually re-add line items from the duplicate.
  • Contact Roles: There’s no automatic way to transfer these. Whatever process you use to consolidate the records, contact roles need to be handled separately. Review both Opportunities, then manually add the relevant contacts to the record you’re keeping. If you don’t, that context is gone.
  • Files and Attachments: These are linked through an object called ContentDocumentLink. During a custom merge, those links are typically updated to point to the master record so your documents stay attached to the right deal.
  • Custom child objects: Some custom objects can be automatically assigned if you update the parent lookup, but others might block the process, and others need to be manually handled to be successfully merged. Behavior depends on the Custom Object configuration.
After merging, make sure you review the surviving Opportunity and make sure that Activities, Products, and Contact Roles, and other Custom related objects are correct. Avoid assuming everything transferred correctly just because the duplicate record is deleted.

How to Merge Opportunities in Salesforce

There’s no single way to do this. Since Salesforce doesn’t have a native merge option for Opportunities, every approach is a workaround. The right approach depends on how many records you are dealing with and how complex the data is. These are some of the methods:

Manual method

This is the most common approach when dealing with a small number of records.
General logic involves:
  • Decide which Opportunity will be the master;
  • Copy the relevant field values from the duplicate to the master if they are missing;
  • Review products on both records and manually consolidate them on the master record;
  • Reassign related records if needed (Contact Roles, Activities, Tasks, and Events);

  • Create a backup in case something goes wrong before deleting the duplicate records.

This is not the optimal way to handle duplicate Opportunities when dealing with more than a handful of records; this method leaves a lot of room for errors.

Salesforce Flow

Flow lets you automate the consolidation logic so you do not have to repeat the same manual steps every time.
At a high-level, the flow-based approach uses:
  • Identifying the master and the duplicate Opportunities;
  • Loop through related records like activities and products;
  • Collections and variables to store and reassign data;

  • Duplicate deletion once everything is transferred.

The advantage of this approach is consistency; every merge follows the same rules. But this approach requires building and maintaining the flow, which requires time and an experienced Salesforce Admin or Developer.

Using Excel or Google Sheets

If you are looking for a data-first approach, this is the safest approach. Using Excel or Google Sheets gives you full visibility before changing anything in Salesforce.
The workflow looks like this:
  • Export Opportunity data into Excel or Google Sheets;
  • Review records side by side;
  • Decide which values to keep and which record becomes the master;

  • Update Salesforce with clean consolidated data.

The biggest advantage here is control. You can see exactly what you’re working with before anything gets deleted or updated.
Tools like XL-Connector let you work with Salesforce data directly in spreadsheets without building complex automations. Instead of manually exporting and importing CSV files, you can pull up-to-date Salesforce data directly into a spreadsheet, make your changes, and push updates back without using the import wizard or data loader. Learn how to merge records at scale in this guide on mass merging Accounts, Contacts, and Leads with XL-Connector.
XL-Connector Excel interface showing Salesforce data sync, edit, and bulk update workflow directly from a spreadsheet.

Conclusion

Salesforce doesn’t have a native merge feature for Opportunities, and that’s intentional. The data attached to an Opportunity is too complex for a one-click solution to handle safely.
The real challenge isn’t technical. It’s knowing which record to keep, what data needs to move, and what happens to everything linked to both records. Here’s a simple way to think about which method fits your case:
  • A few records: Manual consolidation is usually enough;
  • Recurring duplicates: Build a Flow so the process is consistent and repeatable;
  • Bulk cleanup or complex data: Work in a spreadsheet first so you have full visibility before touching anything in Salesforce.
Whatever method you use, always check the surviving Opportunity when you’re done. Don’t assume everything transferred correctly. A quick review can save you from data loss you won’t notice until it’s too late.

FAQ

Can you merge opportunities in Salesforce?

No. Salesforce doesn't include a built-in merge option for Opportunities. To consolidate duplicates, you'll need to use a manual process, build automation with Salesforce Flow, or work with your data in a spreadsheet first.

How do you merge two opportunities under one account?

There's no direct merge option. Pick one Opportunity as the master, manually transfer any relevant field values and products from the duplicate, and then decide whether to delete the duplicate or remove it from your active pipeline.

Can you merge more than two opportunities at once?

No. Salesforce doesn't have a native merge feature for Opportunities, so bulk merging isn't available out of the box. Teams handling large volumes of duplicates typically rely on a custom Flow or third-party tools to manage the process at scale.

How to merge Opportunities in Salesforce Lightning?

There's no native merge option for Opportunities in Lightning. The same approaches covered in this article apply: manual consolidation, a custom Flow, or a spreadsheet-based workflow.

How to merge Opportunities in Salesforce Classic?

Classic does not have a native merge option for Opportunities. The same approaches apply regardless of which interface you're using: manual consolidation, a custom Flow, or a spreadsheet-based workflow.

What happens to related records when you merge opportunities?

It depends on how you handle the consolidation and which records are involved. Some will need to be reassigned, others recreated, and a few may require manual review before you close out the duplicate.

Data Management
|
Share on Facebook Share on Twitter Share on LinkedIn
Perez Victor

Perez Victor

Content Manager

About the Author

Victor Perez is a Salesforce Administrator and Technical Support Specialist at Xappex with experience in administration and consultancy. Driven by a passion for enhancing operational efficiency and business effectiveness, Victor leverages his deep understanding of Salesforce and Xappex tools to develop solutions and resources that empower users across various industries.

Initially starting his career in law, Victor transitioned into the Salesforce ecosystem and quickly advanced to become the Lead Administrator for a prominent B2B company in Mexico, where he significantly improved workflow efficiency and data management. His unique blend of analytical thinking and technical experience allows him to identify and address business challenges effectively.
In his personal time, Victor enjoys golfing and exploring insights from diverse industries, continually seeking innovative approaches to problem-solving and adding value both professionally and personally.

Linkedin Salesforce
flash-icon Xappex Blog

Explore More Insights & Stories