Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
developmentsetupxmlrpcvariants
2 Odgovori
147 Prikazi
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
Opusti
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
Opusti
Avatar
soportesap@sicura.com.ve
Avtor 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
Opusti
Related Posts Odgovori Prikazi Aktivnost
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
avg. 25
4238
Epson TM-M10 printer
security development setup shop
Avatar
Avatar
2
jun. 25
1182
error when activate module dental clinic management system
development configuration setup shop
Avatar
Avatar
1
jul. 25
1494
[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
1190