Skip to Content
This question has been flagged
uniqueduplicates
2 Replies
3667 Views
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
Discard
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
Discard
Thomas Guénard
Author

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
Author

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 Replies Views Activity
CLIENTE DUPLICADO Solved
duplicates
Avatar
Avatar
Avatar
3
Mar 24
3338
how to make a field unique with combination of two fields in the same table Solved
unique
Avatar
Avatar
Avatar
Avatar
6
Apr 25
18614
It is possible to have duplicate serial numbers for a product across warehouses [?]
unique serial_numbers
Avatar
Avatar
Avatar
Avatar
Avatar
4
Jun 24
7974
Find duplicates of refused and active applicants in Recruitment app, v.16
duplicates hr_recruitment
Avatar
Avatar
1
Oct 23
2757
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
Nov 21
5189