I want to prevent the import of duplicate internal product codes. I hope someone who has dealt with it before can help
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 회계
- 재고 관리
- PoS
- Project
- MRP
신고된 질문입니다
4
답글
1265
화면
In addition to using _sql_constraints you can try to combine the following solutions:
Step 1: Declare the attribute compute = False for the default_code field of the product.template model (The default Odoo declaration is compute='_compute_default_code').
Step 2: Using _sql_constraints for default_code field of both model product.template and product.product.
Thank you. This is a great way.
Define columns' needed fields and data types to guarantee that critical information is captured and presented correctly. Invalid character and string checking - Examine the information to find any errors, anomalies, or irrelevant details that can be discarded. Limit the maximum length of text strings, the permissible range of numeric values, etc., to prevent inaccuracies. Put in place data validation and drop-down menus - Limit input fields to pre-defined choices rather than free text.
Hi
TTN SOLUTION,
Adding a constraint for the field will help you in this case. During the test import, if there's a record with the same internal product code, the constraint will trigger an error indicating that a record with the same code already exists. This prevents the creation of duplicate entries with the same internal product code and maintains the uniqueness.
_sql_constraints = [('default_code_uniq', 'unique (default_code)', "Internal Reference already exists !")]
Hope it helps,
Kiran K
you're welcome for the solution. However, I've tried it, and it only works when I create it manually. For imports, it doesn't function.
I am facing this same issue. Have you found solution for it?