Hi,

The error you are encountering indicates that you are trying to create a product variant with a combination of attributes that already exist. The unique constraint on product_tmpl_id and combination_indices ensures that each combination of attribute values for a product template is unique.

To avoid this error, you should first check if the product variant with the given attribute values already exists before creating a new one. Follow the below to modify your code to handle this:

# Check if the variant already exists

existing_variant = env['product.product'].search([

    ('product_tmpl_id', '=', paddle.id),

    ('product_template_variant_value_ids', 'in', translated_values)

], limit=1)

# Use the existing variant or create a new one

if existing_variant:

    used_variant = existing_variant

else:

    used_variant = env['product.product'].create({

        'product_tmpl_id': paddle.id,

        'product_template_variant_value_ids': [(6, 0, translated_values)]

    })

# Add the variant to the order line

order_line = env['sale.order.line'].create({

    'order_id': order.id,

    'product_id': used_variant.id,

    'product_uom_qty': 1,

    'price_unit': used_variant.lst_price,

})

Hope it helps