One product, one code — guaranteed

Block duplicate internal references and product names at the point of entry, auto-generate missing SKUs, and sweep your existing catalog clean with a one-click duplicate scan.

The problem

Odoo does not stop two products from sharing the same internal reference or the same name. Barcode scanning, picking, purchasing, and reporting all assume one code maps to one product — so a silent duplicate corrupts stock counts, sends pickers to the wrong shelf, and skews margin reports. The damage is usually found only after a bulk import or a busy warehouse day, when cleanup is already manual and expensive.

The solution

Unique Product Name & Internal Reference enforces uniqueness on both fields at save time and names the exact conflicting product in the error, so nothing ambiguous ever reaches the database. It fills in missing references automatically, keeps a full audit trail of every reference change, and gives administrators a one-click scan to find and fix the duplicates already hiding in the catalog.

Capabilities

Everything you need to keep the catalog clean

Every capability below is implemented in the module.

01

Unique Internal Reference

Blocks any product from saving with an internal reference already used elsewhere, including archived products, so a code can never point to two records.

02

Unique Product Name

The same duplicate-blocking constraint applies to product names, closing the second most common cause of picking and ordering mistakes.

03

Names the Exact Conflict

The save-blocked error states the duplicate value and identifies the other product that already holds it, so users can jump straight to the conflict instead of hunting for it.

04

Auto-Generated References

New products saved with no internal reference are given one automatically from a configurable prefix and sequence — existing references are never touched.

05

Per-Category Prefixes

Set an optional reference prefix on any product category so auto-generated codes follow your own catalog conventions by product family.

06

Reference Change History

Every internal reference change is logged with the old code, the new code, who made it, and when — visible from a stat button right on the product form.

07

Catalog Duplicate Scan

Scan the entire existing catalog for reference and name duplicates on demand, optionally including archived products, and get a grouped summary of every conflict found.

08

One-Click Reference Fix

Resolve found reference duplicates in one click: every conflicting product but the one you keep is renumbered to a fresh, unique reference. Name conflicts are listed for manual review, since renaming a product is never done automatically.

09

Fully Configurable

Every rule — reference enforcement, name enforcement, case sensitivity, whitespace trimming, auto-generation, and history tracking — is a toggle in Settings, so the module fits your process instead of the other way round.

Workflow

How it works

1

Configure the rules

Open Settings and switch on the checks you need: reference uniqueness, name uniqueness, case sensitivity, auto-generation, and history tracking.

2

Scan the catalog

Run the Duplicate Scan wizard to find every existing reference and name conflict before enforcement starts blocking new saves.

3

Fix what it finds

Auto-fix duplicate references in one click, and review the flagged duplicate names manually before your catalog is fully clean.

4

Stay clean going forward

New products get auto-generated references, every future change is logged, and any attempted duplicate is blocked with a clear, specific error.

Questions

Frequently asked

No sales fog. If your question isn't here, email us and we'll answer it the same way.

Installing the module does not touch existing data. Run the Duplicate Scan wizard to find every conflicting product, then use the one-click fix to auto-renumber duplicate references. Duplicate names are listed for manual review, since renaming a product is never done automatically.

Get the app

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 Product Name & Internal Reference

Stops duplicate SKUs and product names before they reach the database, auto-generates missing references, and gives a one-click scan to clean up existing conflicts.

Buy on Odoo App Store