Skip to Content
This question has been flagged
developmentsetupxmlrpcvariants
2 Replies
130 Views
Avatar
soportesap@sicura.com.ve

For an Odoo.sh v17 implementation.


I have loaded the products (footwear) and created the sizes attribute.


I can identify the IDs of `product.product` or `product.template` using: 


product_ids = lnk_dbcom.execute(

        'product.product',

        'search_read',

        [[('default_code', 'in', codes)]],  # codes = list of product's code 

        {'fields': ['id', 'product_tmpl_id']})


I can also locate the IDs for the attribute and for the different variants: 


product_attribute_ids = lnk_dbcom.execute(

    'product.attribute.value',

    'search_read',

    [[('name', 'in', sizes)]],

    {'fields': ['id', 'attribute_id']}

)


Which model should the variants be linked to? product.product or product.template

How can I assign the selected size variants to each of the products (or templates) using XML/RPC?

I've tried several ways but I can't get it to work


# -

operation = [(1, attribute_line_id, {'value_ids': [(6, 0, product_attribute_ids)]})]

lnk_dbcom.execute(

    'product.template', 

    'write',

    [product_template_id]],

    {'attribute_line_ids': operation})




*note: **lnk_dbcom** es un objeto que encapsula la conexion a odoo usando xml/rpc*

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Please refer to the code:

# Suppose you already have:

# product_template_id -> ID of product.template

# attribute_id -> ID of 'Size' attribute

# product_attribute_value_ids -> list of value IDs for sizes [id_7, id_8, id_9]


# 1. Check if the attribute line already exists for this template

existing_lines = lnk_dbcom.execute(

    'product.template.attribute.line', 'search',

    [[

        ('product_tmpl_id', '=', product_template_id),

        ('attribute_id', '=', attribute_id),

    ]]

)


if existing_lines:

    # 2. Update the existing line with all size value_ids

    lnk_dbcom.execute(

        'product.template.attribute.line', 'write',

        existing_lines,

        {'value_ids': [(6, 0, product_attribute_value_ids)]}

    )

else:

    # 3. Create a new attribute line with all size values

    lnk_dbcom.execute(

        'product.template.attribute.line', 'create',

        [{

            'product_tmpl_id': product_template_id,

            'attribute_id': attribute_id,

            'value_ids': [(6, 0, product_attribute_value_ids)]

        }]

    )


Hope it helps.

Avatar
Discard
Avatar
soportesap@sicura.com.ve
Author Best Answer

Final working code: (thx)

def  get_attribute_line_id (product_template_id, attribute_id, value_ids, create= True ):
     # Search for existing attribute line on the product
    existing_line_ids = lnk_dbcom.execute(
        'product.template.attribute.line' , 'search' ,
        [[
            [ 'product_tmpl_id' , '=' , product_template_id],
            [ 'attribute_id' , '=' , attribute_id]
        ]]
    )

    # If it doesn't exist and creation is allowed, create it
    if not existing_line_ids and create:
        print('create: ', product_template_id, attribute_id, value_ids)
        line_id = lnk_dbcom.execute(
            'product.template.attribute.line', 'create',
            [{
                'product_tmpl_id' : product_template_id,
                'attribute_id' : attribute_id,
                'value_ids' : [( 6 , 0 , value_ids)]
            }]
        )
        existing_line_ids = [line_id]

    return existing_line_ids



Avatar
Discard
Related Posts Replies Views Activity
Database selector for on-premises instance first setup
development setup database
Avatar
0
Apr 22
109
I am unable to setup odoo 18 locally. I am facing issues when running pip install on requirements.txt
development setup debug mac
Avatar
Avatar
2
Aug 25
4232
Epson TM-M10 printer
security development setup shop
Avatar
Avatar
2
Jun 25
1178
error when activate module dental clinic management system
development configuration setup shop
Avatar
Avatar
1
Jul 25
1487
[Need Advice ] I want run Odoo in Raspberry pi (8GB) running in bear metal is better or docker containr
development setup project workflow
Avatar
0
Mar 25
1187