Syntho Unique Prod Ref

v 19.0 Third Party 9

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	Discuss (mail)
Lines of code	22
Technical Name	`syntho_product_unique_reference`
License	LGPL-3
Website	https://www.synthoerp.com/

You bought this module and need support? Click here!

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	Discuss (mail)
Lines of code	22
Technical Name	`syntho_product_unique_reference`
License	LGPL-3
Website	https://www.synthoerp.com/

Catalog Integrity

Syntho Unique Product Reference

Prevent duplicate internal references across products and variants so the catalog stays clean, searchable, and safe for downstream sales, stock, and purchasing flows.

Odoo 19 Product SKU Control Validation

Key Capabilities

A focused safeguard for teams that rely on unique internal references.

Single Source of Truth

Stops the same internal reference from being reused elsewhere in the product catalog.

Batch-Safe Validation

Checks duplicates inside the current create or update batch before anything is saved.

Database Check

Also searches existing records so duplicates cannot slip through from earlier data.

Blank Values Allowed

The rule only applies when an internal reference is set, so optional SKUs still work.

Where It Helps

Teams importing or creating products in bulk and needing SKU discipline.
Companies where stock, sales, or purchasing rely on internal references for daily operations.
Catalog clean-up projects where duplicate SKUs must be blocked going forward.

Implementation Style

The module is intentionally lightweight: it adds a Python constraint on product.product and does not introduce new models, menus, or configuration screens.

Installation

Step 1

Copy syntho_product_unique_reference into your addons path.

Step 2

Restart Odoo and update the Apps list.

Step 3

Install Syntho Unique Product Reference.

Step 4

From that point onward, duplicate internal references are blocked automatically.

Technical Snapshot

Dependency	`product`
Target Field	`default_code` on product variants
Validation Scope	Current batch plus existing database records
Blank References	Allowed
Support Contact	info@synthoerp.com

Please log in to comment on this module

The author can leave a single reply to each comment.
This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.