Skip ke Konten
Pertanyaan ini telah diberikan tanda
uniqueduplicates
2 Replies
2462 Tampilan
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
Buang
Avatar
Balagopal R
Jawaban Terbai

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


Avatar
Buang
Thomas Guénard
Penulis

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
Penulis

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

Post Terkait Replies Tampilan Aktivitas
CLIENTE DUPLICADO Diselesaikan
duplicates
Avatar
Avatar
Avatar
3
Mar 24
2475
how to make a field unique with combination of two fields in the same table Diselesaikan
unique
Avatar
Avatar
Avatar
Avatar
6
Apr 25
17370
It is possible to have duplicate serial numbers for a product across warehouses [?]
unique serial_numbers
Avatar
Avatar
Avatar
Avatar
Avatar
4
Jun 24
6729
Find duplicates of refused and active applicants in Recruitment app, v.16
duplicates hr_recruitment
Avatar
Avatar
1
Okt 23
1706
How can duplicate receipts be detected by Odoo in the Expenses App? To ensure a submitted image is not submitted more than once. Diselesaikan
duplicates Expenses
Avatar
Avatar
1
Nov 21
4033