---
title: How Cogent Fixed Duplicate Data Between HubSpot and OrderWise (with Koalify)
description: Discover how Cogent Connective used Koalify to clean duplicate HubSpot data during a Freshsales-to-HubSpot and OrderWise ERP migration, improving data accuracy.
image: https://koalify.io/hubfs/How%20Cogent%20Fixed%20Duplicate%20Data%20Between%20HubSpot%20and%20OrderWise%20%28with%20Koalify%29.png
---
[Skip to content](https://koalify.io/blog/how-cogent-fixed-duplicate-data-between-hubspot-and-orderwise-with-koalify#main-content)
[](https://koalify.io)
- Products
Show submenu for Products
- [Deduplication](https://koalify.io)
- [Email Validation](https://koalify.io/hubspot-email-validation)
- Pricing
Show submenu for Pricing
- [Deduplication](https://koalify.io/pricing)
- [Email Validation](https://koalify.io/hubspot-email-validation-pricing-koalify)
- [Partners](https://koalify.io/partners)
- [Blog](https://koalify.io/blog)
- Knowledge base
Show submenu for Knowledge base
- [Deduplication](https://koalify.io/knowledge-base)
- [Email Validation](https://koalify.io/email-validation-knowledge-base)
- Products
Show submenu for Products
- [Deduplication](https://koalify.io)
- [Email Validation](https://koalify.io/hubspot-email-validation)
- Pricing
Show submenu for Pricing
- [Deduplication](https://koalify.io/pricing)
- [Email Validation](https://koalify.io/hubspot-email-validation-pricing-koalify)
- [Partners](https://koalify.io/partners)
- [Blog](https://koalify.io/blog)
- Knowledge base
Show submenu for Knowledge base
- [Deduplication](https://koalify.io/knowledge-base)
- [Email Validation](https://koalify.io/email-validation-knowledge-base)
[Get Started Free](https://api.koalify.io/hubspot/install?utm_source=koalify&utm_medium=website&utm_campaign=navigation)
[HubSpot Data Quality](https://koalify.io/blog/tag/hubspot-data-quality)
# How Cogent Fixed Duplicate Data Between HubSpot and OrderWise (with Koalify)
[By \- Jonas,](https://koalify.io/blog/author/jonas) Oct 07, 2025
When integrating CRMs and ERPs, duplicate data is almost guaranteed.
Migrating from **Freshsales** and **Freshdesk** to **HubSpot**, while also syncing with **OrderWise ERP**, one client faced a tangle of duplicate contacts, mismatched companies, and unreliable data.
In this episode of *How I Fixed Your Data*, **Daryl Michel**, founder of **Cogent Connective**, shares how his team used **Koalify** to bring order to the chaos — safely merging duplicate records, enriching data with ERP IDs, and creating a long-term system to prevent duplication.
🎥 **Watch the full conversation with Daryl Michel from Cogent Connective:**
## The Industry Problem: Two Systems, Two Realities
When businesses run **both a CRM and an ERP**, the data often lives in silos.
ERPs hold customer and order data; CRMs manage relationships and communication. But without a clean sync, duplicates and mismatches multiply fast.
For this client, the problem started during a **migration from Freshsales/Freshdesk to HubSpot**.
They already had thousands of records in **OrderWise ERP**, plus contacts and companies from the Freshworks ecosystem, and none of the IDs or data formats matched.
**Key challenges:**
- Different unique identifiers across systems.
- Shared inboxes causing duplicate contacts (e.g., `sales@company.com`).
- Inconsistent company names and email formats.
- Two separate datasets that didn’t map neatly to one another.
As Daryl explains: *“Each system had its own logic. Freshsales stored one set of IDs, OrderWise another, and HubSpot needed clean, unified data. Once we imported everything, duplication exploded.”*
---
## The Fix – Smarter Deduplication with Koalify
The first attempt to fix the problem used **Operations Hub** inside HubSpot.
While useful for data quality monitoring, it lacked the flexibility to merge based on **multiple properties or business logic**.
So the team turned to [**Koalify**](https://koalify.io/).
*“We’d used Koalify before and knew it could handle multiple match conditions — not just email. That was key for us,” says Daryl.*
### Step 1: Identify Duplicates Using ERP IDs
The team started by enriching the imported data from Freshsales with **OrderWise IDs** — unique identifiers from the ERP system.
This allowed them to:
- Instantly detect records representing the same customer across systems.
- Merge duplicates confidently, knowing they matched on verified ERP data.
- Reduce risk of merging unrelated companies or contacts.
### Step 2: Configure Koalify Duplicate Rules
Inside Koalify, Cogent built granular rules to catch duplicates based on:
- **First Name + Last Name**
- **Company Name + OrderWise ID**
- **Phone Number + Account Number + Postcode**
These flexible, multi-criteria rules gave them precision that HubSpot’s native tools couldn’t provide.
### Step 3: Bulk and Workflow-Based Merges
Using **Koalify’s workflows**, Cogent automated bulk merges safely:
- Duplicates with **exact ID matches** merged automatically.
- Others were flagged for manual review and validation.
*“We could merge thousands of duplicates in minutes — but only once we knew the rules were airtight,” Daryl explains.*
---
## Results for the Client
Once Koalify was in place, data clarity improved immediately:
- ⚙️ **Thousands of duplicates removed** within hours.
- 📊 **Unified CRM + ERP view** — HubSpot users could see real-time ERP data.
- 🔍 **Better visibility for sales and service teams.**
- 💡 **Automation-ready CRM** — clean data powering workflows, not breaking them.
“The client was shocked at how fast we could clean things up. Before Koalify, they’d been manually merging records for weeks. Now it’s a few clicks.”
---
## Building for the Future: A HubSpot–OrderWise Integration
Cogent didn’t stop after the cleanup.
Using lessons from this project, the team began developing a **native OrderWise–HubSpot integration**, allowing clients to sync key data objects — customers, contacts, products, orders, and quotes — directly between systems.
The integration gives users:
- Full control over which properties sync.
- Real-time updates both ways.
- A clean starting point for all future imports.
“We wanted clients to own their sync. They choose what maps between OrderWise and HubSpot, and Koalify ensures duplicates never get in the way.”
---
## Lessons Learned
The biggest takeaways from this project:
### 1. Enrich Before You Import
Adding **ERP IDs** before migration ensures you can merge safely later.
If you import first and enrich later, you risk losing track of relationships.
### 2. Use Unique Properties
HubSpot allows multiple **unique value properties** per object. Use them to track external IDs (like from ERP systems) and prevent duplicates early.
### 3. Combine Tools Strategically
Operations Hub is great for monitoring; **Koalify** is built for merging.
Together, they cover both detection and correction.
### 4. Create ID Properties for Every System
Even if it’s not unique, always store external system IDs. They’re invaluable for re-imports, matching, and historical analysis.
*“Having those OrderWise IDs stored in HubSpot was a lifesaver. You can’t manage large integrations without consistent identifiers.”*
---
## Why Koalify
**Koalify** gave Cogent the flexibility, safety, and speed needed for large-scale deduplication:
- Custom rules based on multiple fields
- Seamless integration with HubSpot workflows
- Transparent merging process
- Peace of mind when syncing complex systems
*“It’s simple enough for end users but powerful enough for advanced integrations. For duplicate management, Koalify is a no-brainer.”*
---
## FAQ
**Q: How do duplicates form when syncing ERP and CRM data?**
A: Different systems use different IDs and field formats. Without matching properties, imports create new records instead of updating existing ones.
**Q: How can I prevent duplicates before migrating?**
A: Add unique IDs from your ERP or old CRM as custom fields in HubSpot before import. Use Koalify to catch overlapping records after the import.
**Q: Can Koalify merge based on external IDs like ERP numbers?**
A: Yes. You can create duplicate rules that match on custom properties (e.g., `OrderWise ID`) or combinations like `Company + Phone + Postcode`.
**Q: Will Cogent’s OrderWise integration be available publicly?**
A: Yes. Cogent Connective plans to release it in 2025, bringing full two-way sync and custom property mapping between HubSpot and OrderWise.
###### Category
- [HubSpot Data Quality](https://koalify.io/blog/tag/hubspot-data-quality)
- [HubSpot Integration Duplicates](https://koalify.io/blog/tag/hubspot-integration-duplicates)
- [HubSpot Revenue Operations](https://koalify.io/blog/tag/hubspot-revenue-operations)
- [HubSpot Email Validation](https://koalify.io/blog/tag/hubspot-email-validation)
- [HubSpot Associations](https://koalify.io/blog/tag/hubspot-associations)
- [HubSpot Deduplication](https://koalify.io/blog/tag/hubspot-deduplication)
###### Popular Post
- [HubSpot best practices for contacts that leave a company](https://koalify.io/blog/hubspot-best-practices-for-contacts-that-leave-a-company)
- [How to Bulk Merge HubSpot Duplicates: Contacts, Companies, Deals and More](https://koalify.io/blog/how-to-bulk-merge-hubspot-duplicates-contacts-companies-more)
- [How to Merge Companies in HubSpot (Safely, Manually or in Bulk)](https://koalify.io/blog/how-to-merge-companies-in-hubspot-manual-or-in-bulk)
- [HubSpot Deduplication: How to Find, Manage, and Remove Duplicates in HubSpot](https://koalify.io/blog/hubspot-deduplication-the-ultimate-guide-to-zero-duplicates-in-hubspot)
- [How to Merge Duplicate Contacts in HubSpot Without Losing Data](https://koalify.io/blog/how-to-merge-contacts-in-hubspot-manual-or-in-bulk)
### Similar Blogs
#### [How Jon Mogard Fixed 18,000 Duplicate HubSpot Records for a Swedish SaaS Company (with Koalify)](https://koalify.io/blog/how-jon-mogard-fixed-18000-duplicate-hubspot-records-for-a-swedish-saas-company-with-koalify)
By [Jonas](https://koalify.io/blog/author/jonas) 8 October 2025
When you connect multiple systems to HubSpot — ERP, e-commerce, licensing, and a legacy CRM — data...
[READ MORE](https://koalify.io/blog/how-jon-mogard-fixed-18000-duplicate-hubspot-records-for-a-swedish-saas-company-with-koalify)
#### [How Karin Tamir Fixed HubSpot Duplicate Chaos from Complex Integrations (with Koalify)](https://koalify.io/blog/how-karin-tamir-fixed-hubspot-duplicate-chaos-from-complex-integrations-with-koalify)
By [Jonas](https://koalify.io/blog/author/jonas) 31 March 2025
[READ MORE](https://koalify.io/blog/how-karin-tamir-fixed-hubspot-duplicate-chaos-from-complex-integrations-with-koalify)
#### [How to Manage HubSpot Duplicates with the Salesforce Integration (Without Breaking the Sync)](https://koalify.io/blog/how-to-manage-duplicate-contacts-and-companies-with-the-hubspot-salesforce-integration)
By [Jonas](https://koalify.io/blog/author/jonas) 28 November 2024
When you run HubSpot and Salesforce side by side, duplicates cause problems for marketing, sales...
[READ MORE](https://koalify.io/blog/how-to-manage-duplicate-contacts-and-companies-with-the-hubspot-salesforce-integration)
## Koalify
HubSpot deduplication and email validation
-
-
[Review us on HubSpot](https://app-eu1.hubspot.com/l/marketplace/listing/koalify-io/write-review?eco_review_source=external-button)
[](https://trust.koalify.io/)
[](https://trust.koalify.io/)
## Company
[Product](https://koalify.io)
[Pricing](https://koalify.io/pricing-usd)
[Knowledge Base](https://koalify.io/knowledge-base)
[Blog](https://koalify.io/blog)
[Partners](https://koalify.io/partners)
## Blog
[HubSpot Deduplication](https://koalify.io/blog/hubspot-deduplication-the-ultimate-guide-to-zero-duplicates-in-hubspot)
[Merge HubSpot Contacts](https://koalify.io/blog/how-to-merge-contacts-in-hubspot-manual-or-in-bulk)
[Merge HubSpot Companies](https://koalify.io/blog/how-to-merge-companies-in-hubspot-manual-or-in-bulk)
[Merge HubSpot Deals](https://koalify.io/blog/how-to-merge-deals-in-hubspot-manual-or-in-bulk)
[Bulk Merge HubSpot](https://koalify.io/blog/how-to-bulk-merge-hubspot-duplicates-contacts-companies-more)
## Security
[Trust Center](https://trust.koalify.io/)
[Terms of Service](https://koalify.io/terms-of-service)
[Privacy Policy](https://koalify.io/privacy-policy)
[Data Processing Addendum](https://koalify.io/data-processing-addendum)
[Security](https://koalify.io/security)
© 2026 Koalify. All rights reserved.
```json
{
"@context" : "https://schema.org",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Jonas",
"url" : "https://koalify.io/blog/author/jonas"
},
"dateModified" : "2026-02-09T20:27:49.408Z",
"datePublished" : "2025-10-07T12:42:08.000Z",
"headline" : "How Cogent Fixed Duplicate Data Between HubSpot and OrderWise (with Koalify)",
"image" : [ "https://koalify.io/hubfs/How%20Cogent%20Fixed%20Duplicate%20Data%20Between%20HubSpot%20and%20OrderWise%20%28with%20Koalify%29.png" ],
"mainEntityOfPage" : {
"@id" : "https://koalify.io/blog/how-cogent-fixed-duplicate-data-between-hubspot-and-orderwise-with-koalify",
"@type" : "WebPage"
},
"publisher" : {
"@type" : "Organization",
"logo" : {
"@type" : "ImageObject",
"url" : "https://koalify.io/hubfs/koalify_rectangle_100px.png"
},
"name" : "Koalify"
}
}
```