Duplicate records are always a challenge in any CRM, but when you’re working with integrated systems like HubSpot and Chargebee, handling duplicates becomes even more critical to ensure billing and customer data remain accurate and synchronized.
Fortunately, Koalify gives you the flexibility to set up custom duplicate detection, allowing you to maintain clean, reliable company data, even with Chargebee in the mix.
In this post, we’ll walk through three common duplicate scenarios and show you exactly how to handle each when the Chargebee integration is enabled.
Scenario 1: Both Duplicate Companies Have a Chargebee Customer ID
✅ Action: DO NOT MERGE
If both records have a different Chargebee Customer ID, merging them can cause data inconsistencies and syncing issues between Chargebee and HubSpot. These represent two distinct billing entities, even if they look similar.
💡 Tip: EDIT DUPLICATE RULES
To avoid these types of duplicates being flagged, update your duplicate rules to include:
-
Chargebee Customer ID matches (or is unknown) Chargebee Customer ID
This ensures duplicates will only be suggested when:
-
One or both records are missing a Chargebee Customer ID
-
The Chargebeen Customer IDs match
-
But never when two records have different Chargebee Customer IDs.
Scenario 2: Only One Company Has a Chargebee Customer ID
✅ Action: Merge the Companies
But with one important condition:
Ensure the company that has the Chargebee Customer ID becomes the primary record during the merge.
This retains the billing data and sync behavior with Chargebee.
💡 Tip: EDIT PRIMARY RULE
Set your primary duplicate rule to:
-
Chargebee Customer ID is known
(as the first priority)
This ensures that during merges, HubSpot will automatically keep the Chargebee-connected record as the primary, protecting the integrity of your billing data.
Scenario 3: Neither Company Has a Chargebee Customer ID
✅ Action: Merge the Companies
When there’s no Chargebee data, you can safely consolidate the records, but still aim to keep the most complete or relevant one as the primary.
💡 Tip: EDIT PRIMARY RULE
Use a secondary rule, like:
-
Company Registration Number / VAT Number is known
- Has first or last create or activity date
This helps Koalify to choose the company with more relevant data as the primary during bulk merges via the workflow action.
Happy deduping!