Skip to Content

Product Auto Internal Reference

by
Odoo
v 19.0 Third Party 3
Download for v 19.0 Deploy on Odoo.sh
You bought this module and need support? Click here!

Product Auto Internal Reference

Automatically assign a unique internal reference to every product variant the moment it is created — zero manual effort.

Odoo 19 Multi-company Configurable sequence Variant-level

What it does

⚡

Instant auto-assignment

References are generated at the moment a product variant is saved — no extra clicks, no manual entry.

🔢

Configurable sequence

Pick your own prefix, padding length, and starting number. Ships with PROD-00001 out of the box.

🏢

Multi-company ready

Each company can have its own independent sequence, keeping references clean across business units.

🔒

Uniqueness enforced

A database-level constraint prevents duplicate references from ever being saved, even on import.

📋

Copy-safe

Duplicating a product clears the old reference so a fresh one is automatically assigned to the copy.

🎯

Variant-level precision

Works at the product.product level — each variant (size, colour, etc.) gets its own unique reference.

How to configure

1

Install the module

Go to Apps, search for Product Auto Internal Reference, and click Install.

2

Open Settings

Navigate to Settings → Product Auto Reference. A default sequence (PROD- prefix, 5-digit padding) is already selected.

3

Choose or create a sequence

Select any existing ir.sequence or create a new one from Settings → Technical → Sequences. Set any prefix and padding you like.

4

Save and start creating products

Every new product variant will automatically receive a reference from your chosen sequence — that's it!

Tip: Existing products are not touched on install. The module only assigns references to new variants created after installation. To back-fill existing products, update them manually or via a one-time script.

Technical notes

The module extends product.product (variant model) at the create level. It falls back gracefully: company sequence → module default sequence → sequence by code product.auto.ref. A _sql_constraints entry enforces uniqueness on default_code. No core Odoo files are modified.


Dependencies: product, stock, base_setup  |  License: LGPL-3  |  Author: Odoo Nerd

Product Auto Internal Reference  ·  v19.0.1.0.0  ·  Odoo Nerd
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Discuss (mail)
Lines of code 121
Technical Name auto_reference_generate
LicenseLGPL-3
Websitehttps://www.odoo.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.