Can I enforce unique (Refence code) Internal Reference for Products?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Can I enforce unique (Refence code) Internal Reference for Products?

unique duplicates

2 Odpowiedzi

2449 Widoki

Thomas Guénard

Every week I place Purchase orders with various suppliers.

Each order is made of say 20 different lines with 1 line per ordered product.

some lines for already existing productss, others for non existing products;

I have no way to predict i one product is already existing of not; hence the risk to duplicate products.

My odoo db contains say 20 000 unique products

when Importing the order lines from documents (csv files) received from suppliers, Odoo is able to create new product on the fly (for instance on the criteria Name).

This criteria is weak as it is not (apparently ) able to REFUSE the import of a order line when the name is misspelled ((spelling errors etc...)

How to instruct ODOO to manage unique skus numbers?

Balagopal R

Najlepsza odpowiedź

In Odoo 17, this feature is already there. Internal Reference in the product master can be used for the same.

Thomas Guénard

Autor

Thanks Bagalopal; I will migrate to v17 from v16 as soon as available for Enterprise Saas.

do you confirm this is a v17 NEW FUNCTION WORKING AT SERVER LEVEL WHEN IMPORTING OR CREATING NEW PRODUCTS?

Balagopal R

For importing, it's not working. It's working only for Creating New Products

Josep Anton Belchi Riera

This works at least on Odoo v15 and Odoo v16.

Thomas Guénard

Autor

Deceiving that Odoo dev do not consider importing data as a full way to create new products; they did it but with limited constraints

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
CLIENTE DUPLICADO Rozwiązane duplicates	3 mar 24	2466
how to make a field unique with combination of two fields in the same table Rozwiązane unique	6 kwi 25	17361
It is possible to have duplicate serial numbers for a product across warehouses [?] unique serial_numbers	4 cze 24	6718
Find duplicates of refused and active applicants in Recruitment app, v.16 duplicates hr_recruitment	1 paź 23	1701
How can duplicate receipts be detected by Odoo in the Expenses App? To ensure a submitted image is not submitted more than once. Rozwiązane duplicates Expenses	1 lis 21	3998

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!