Skip to Content
This question has been flagged
uniqueduplicates
2 Respostes
3466 Vistes
Avatar
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?



Avatar
Descartar
Avatar
Balagopal R
Best Answer

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


Avatar
Descartar
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

Related Posts Respostes Vistes Activitat
CLIENTE DUPLICADO Solved
duplicates
Avatar
Avatar
Avatar
3
de març 24
3197
how to make a field unique with combination of two fields in the same table Solved
unique
Avatar
Avatar
Avatar
Avatar
6
d’abr. 25
18452
It is possible to have duplicate serial numbers for a product across warehouses [?]
unique serial_numbers
Avatar
Avatar
Avatar
Avatar
Avatar
4
de juny 24
7780
Find duplicates of refused and active applicants in Recruitment app, v.16
duplicates hr_recruitment
Avatar
Avatar
1
d’oct. 23
2590
How can duplicate receipts be detected by Odoo in the Expenses App? To ensure a submitted image is not submitted more than once. Solved
duplicates Expenses
Avatar
Avatar
1
de nov. 21
5017