how to validate import excel default

Question

I want to prevent the import of duplicate internal product codes. I hope someone who has dealt with it before can help

Tuan Bui VKS · Accepted Answer

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.

Adil Akbar · Answer

Hi, you can follow https://youtu.be/SgFmOD9Q2S4?si=46y7nPM_rumGs9NU [1]
I hope it helps, thanks

[1] https://youtu.be/SgFmOD9Q2S4?si=46y7nPM_rumGs9NU

Freda Mcbride · Answer

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.

Kiran K · Answer

Hi
​ [1] TTN SOLUTION [2] ,
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 !" )]  Hop

Этот вопрос был отмечен

Enjoying the discussion? Don't just read, join in!