How to Use Odoo 19 Data Cleaning Module: Complete Step by Step Guide
By Braincuber Team
Published on May 19, 2026
Odoo 19 Data Cleaning Module serves as an intelligent assistant for your database maintenance. In a business environment, a database works much like a digital filing system that stores important information such as customer details, supplier contacts, sales leads, and product records. Since this data is updated daily from multiple sources, errors and inconsistencies can naturally develop over time. This complete tutorial will guide you through using the Data Cleaning module to identify duplicate records, detect inconsistencies, remove unnecessary data, and improve overall data accuracy.
What You'll Learn:
- How to access and navigate the Data Cleaning module in Odoo 19 Enterprise
- Finding and managing duplicate records with customizable criteria
- Using the smart merge feature to consolidate records without data loss
- Standardizing data with formatting rules for names, phones, and addresses
- Setting up automated cleaning schedules (daily or weekly)
- Creating custom cleaning rules for your specific business needs
Duplicate Detection
Scan your database for duplicate entries based on emails, phone numbers, or custom criteria with adjustable threshold levels.
Smart Merging
Compare duplicate entries side-by-side and merge them into a single master record without losing any associated data.
Data Standardization
Fix formatting inconsistencies including capitalization, spacing, phone number formats, and address standardization.
Automated Cleaning
Schedule cleaning processes to run automatically on a daily or weekly basis for continuous data quality maintenance.
Understanding the Data Cleaning Module
The Data Cleaning module is one of the default modules of Odoo 19 Enterprise. The main goal of this module is to support users in finding and fixing problems with their data. A key advantage of this module is that it does not automatically modify any data on its own. On the contrary, it provides users with detailed information about problematic records and provides them with options to correct the same.
Duplicate customer entries, incorrect phone numbers, outdated records, and unnecessary information can easily accumulate within the system. These issues can reduce the accuracy of reports, affect decision-making, and lower overall operational efficiency. Odoo 19 Data Cleaning ensures that your business information remains organized, reliable, and ready for efficient operations.
| Business Area | Benefit of Clean Data |
|---|---|
| Sales | Unified client view prevents duplicate emails and ensures accurate pipeline tracking |
| Marketing | Better campaign results with emails sent to proper addresses that recipients can open |
| Reporting | Accurate business insights from reliable reports and dashboards without duplicate skewing |
| General Efficiency | Staff saves time by focusing on business tasks instead of sorting out messy data |
Step 1: Access Data Cleaning Module Dashboard
Getting started with the Data Cleaning tool is easy. After installation, you will find everything inside the Data Cleaning application. The dashboard shows you all the information related to all records which were processed by the application or are available for review.
Open Data Cleaning App
From the Odoo 19 Enterprise dashboard, locate and click on the Data Cleaning module to access the main interface.
Review Dashboard Overview
The dashboard displays processed records, pending reviews, and cleaning activity summaries for quick status assessment.
Step 2: Define Data Cleaning Rules
In the configuration part, you set up your data cleaning criteria. You pick the type of your data (for instance, products, contacts, etc.) and establish the rules according to which a particular record can be considered to be a duplicate or erroneous. Each business is unique, and you can develop customized policies for cleaning to cater to individual industries or companies.
Select Data Type
Choose the type of data to clean, such as contacts, products, leads, or any other model in your Odoo database.
Set Duplicate Detection Criteria
Configure how duplicates are found based on emails, telephone numbers, names, or other custom fields. Control the threshold level for matching accuracy.
Create Custom Cleaning Policies
Develop customized rules for specific business requirements using logical reasoning and drop-down menus without needing programming knowledge.
No Technical Expertise Required
The Data Cleaning module is designed for common users. Rules can be created through logical reasoning and drop-down menus, so you just choose the criteria that interest you without getting into technicalities.
Key Features of Data Cleaning
Finding Duplicate Records
The program will go through your database and try to find duplicate entries. It is up to you to determine how the duplicates are found. You can base it on the emails, telephone numbers, or other criteria. You can control the threshold level and ensure that everything is covered.
Smart Merging
If duplicates have been found, then Odoo 19 will assist you with merging them. You will be able to compare both the entries and pick up the most relevant information. Once merged, all the data will be consolidated in one master entry without losing any information.
Merge Process Steps:
1. Module identifies duplicate entries
2. Side-by-side comparison of both records
3. User selects which values to keep
4. All data consolidated into one master record
5. Associated records (invoices, orders) retained
6. Audit trail tracks all cleaning actions
Standardizing Your Data
Being consistent is very important when it comes to collecting quality data. This feature will allow you to fix the minor details within your data entry. It could include such actions as capitalizing names, eliminating any unnecessary spacing between characters, and formatting phone numbers properly.
Setting Up Automatic Cleaning
It does not necessarily mean that you need to start each cleaning session by yourself. With Odoo version 19, you will be able to set up the cleaning process to perform automatically. You will be able to choose whether you want it to occur on a daily basis or once per week.
Step 3: Execute Cleaning Actions and Manage Results
In case you are running the cleaning process manually, then at any time you can set up the rules, and if some problems will be found, you can decide to either hide or delete it completely. If it comes to automatic mode, all changes will be noted down. You can enable notification services in order to keep yourself informed about the process.
Review Identified Issues
Examine the records flagged by the cleaning rules. The module provides detailed information about each problematic record.
Choose Action: Hide, Delete, or Merge
For each identified issue, decide whether to hide the record, delete it completely, or merge duplicate entries into a master record.
Enable Notifications and Audit Trail
Activate notification services to stay informed about cleaning progress. The audit trail tracks all actions for accountability.
Step 4: Undo Actions and Recover Records
You can also undo whatever actions you have taken in case of a wrong move and also retrieve hidden records whenever necessary. Odoo 19 was built with caution in mind. There is an audit trail that tracks any record cleaning that takes place. Should something happen, the mistake can be undone. In addition, if you opted to archive the record, you could easily locate the record under your archived documents.
Access Audit Trail
Review the complete history of cleaning actions through the audit trail to track what changes were made and when.
Undo Mistaken Actions
Reverse any cleaning action if you accidentally merged or deleted the wrong record. The system allows full recovery.
Retrieve Archived Records
Locate and restore hidden or archived records from the archived documents section whenever needed.
Data Safety Guarantee
Cleaning your data will not affect your past sales orders or invoices. The intelligent merge retains all associated data. When merging customers, all past invoices, orders, and comments will be associated with your single, newly created record.
Is Data Cleaning available in Odoo 19 Community?
No, the Data Cleaning module is exclusive to Odoo 19 Enterprise edition and is not available in the Community version.
Can I recover accidentally merged or deleted records?
Yes, Odoo 19 maintains an audit trail of all cleaning actions. You can undo mistakes and retrieve archived records from the archived documents section.
How does the module choose the master record during merge?
The module does not auto-select. It shows conflicting values side-by-side so you can decide which entry to keep in the final merged record.
Will data cleaning affect past sales orders or invoices?
No. The intelligent merge retains all associated data. Past invoices, orders, and comments remain linked to the newly merged record.
Do I need technical skills to set up cleaning rules?
No programming knowledge is needed. Rules are created through drop-down menus and logical criteria selection designed for everyday users.
Need Help with Odoo Data Management?
Our experts can help you configure and optimize the Data Cleaning module in Odoo 19 for maximum data quality and operational efficiency.