No-code uniqueness rules for any field
Configure, validate, and clean up duplicate values on any model field — directly from the Odoo interface, with ready-made templates, batch rollout, and a full audit trail.
The problem
Odoo has no built-in way to guarantee that a field like a customer reference, badge number, SKU, or email address never repeats. The only native path is custom code or a database constraint, so businesses either hire a developer or live with duplicate records that corrupt reporting, break integrations, and require manual clean-up.
The solution
Unique Fields Support lets an administrator mark any stored field on any model as unique, straight from the UI. Rules take effect instantly, can be switched on and off with zero downtime, and come with a wizard to find and clean up the duplicates that already exist before a rule goes live.
Everything you need to keep data clean
Every capability below is implemented in the module.
No-Code Uniqueness Rules
Pick a model and a field from the UI and enforce uniqueness at save time — no database migration, no downtime, no developer needed.
Broad Field-Type Coverage
Apply rules to text, selection, integer, float, and monetary fields — not just plain text — covering codes, emails, and amounts alike.
Configurable Comparison
Toggle case-sensitivity and whitespace trimming per rule, so "ABC" and "abc" (or "x" and "x ") are treated exactly the way your data demands.
Clear, Actionable Conflict Messages
Every rejected save names the field, the value, and the exact conflicting record — so resolving it never means guessing.
Duplicate Detection & Cleanup
A one-click scan groups every conflicting value, then lets you open the records or keep the first and archive the rest.
Activation Guard
A rule cannot be switched on while unresolved duplicates exist, so you can never enable protection on top of dirty data by accident.
Ready-Made Templates
Apply proven presets for email, reference/SKU codes, badge numbers, and VAT/tax IDs in a single click, with sensible defaults already set.
Batch Rollout
Apply uniqueness rules to several fields in one pass, with a safe mode that keeps new rules inactive until you have reviewed a duplicate report for each one.
Scale Warnings & Audit Trail
See the target table's row count before enabling a rule on a large dataset, and review a full chatter history of who created, changed, or disabled every rule.
How it works
Pick a field
Open Unique Fields, choose a model and field, or start from a ready-made template.
Set comparison options
Toggle case sensitivity and whitespace trimming to match how your business treats a matching value.
Check & resolve duplicates
Run "Check for duplicates," review the grouped conflicts, and archive the extras you no longer need.
Enable & enforce
Switch the rule on. Every future create or write is checked instantly, and every change is tracked in the chatter.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
Text, long text, selection, integer, float, and monetary fields on any stored field of any concrete model — covering codes, emails, IDs, and numeric references.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Unique Fields Support
No-code uniqueness rules on any field of any model, with configurable comparison, clear conflict messages, duplicate detection and cleanup, an activation guard, ready-made templates and batch rollout with scale warnings.
Buy on Odoo App Store