Dear,

To check exist the same Product in the line level.

from odoo import models, fields, api
from odoo.exceptions import ValidationError


class SaleOrder(models.Model):
    _inherit = "sale.order"

    @api.multi
    @api.constrains('order_line')
    def _check_exist_product_in_line(self):
      for sale in self:
          exist_product_list = []
          for line in sale.order_line:
             if line.product_id.id in exist_product_list:
                raise ValidationError(_('Product should be one per line.'))
             exist_product_list.append(line.product_id.id)

Hope this code help you

Best Thanks,

Ankit H Gandhi.

Hi,

if the order is validated you can not change it.

and you can not remove products while other records still reference it.

so I think the only solution is to make SQL requettes in postgresql.