Setting XML_ID for materialized relations

[emyllymaki]

Hello, I've been using odoo_csv_import successfully with a v14 database.

One issue I'm haivng is how to set the xml_id on a materialized relationship - product_template_attribute_value.

This is a new object since v13 and is created by the product_template_attribute_line (also a new object) and so I am not seeing how to set this xml_id so that I can reference it later.

Maybe I am missing something obvious?

Thanks.

[gediminasvenc]

I was trying to use this script on v15, i tried to import products with variants, but also stuck at this new relationship field import. Maybe somebody could share how this can be done?

[Rad0van]

Hello, I've been using odoo_csv_import successfully with a v14 database.

One issue I'm haivng is how to set the xml_id on a materialized relationship - product_template_attribute_value.

This is a new object since v13 and is created by the product_template_attribute_line (also a new object) and so I am not seeing how to set this xml_id so that I can reference it later.

Maybe I am missing something obvious?

Thanks.

Not having a solution here but just a bit of info as I was struggling with this quite much using normal import.

What I did is first importing product.template.attribute.line records like this:

product_tmpl_id_ext_id	attr_id	attr_values
CB 184 HC	attr_cooling	attr_cooling:water,attr_cooling:air

This assigns attribute to product.template and creates 2 product.template.attribute.values as possible options (attr_cooling:water and attr_cooling:air are external identifiers of attribute values).

I the exported created product.template.attribute.value records into Excel to have lookups. The I import attribute_line_ids for product.template using those lookups.

I guess you could import the separately like this:

ext_id	product_tmpl_id_ext_id	attr_id	attr_values
ptav_1	CB 184 HC	attr_cooling	attr_cooling:water
ptav_2	CB 184 HC	attr_cooling	attr_cooling:air

And then import attribute_line_ids using external identifiers.

Hope this makes sense and I didn't screw up describing it...

[bosd]

This is a new object since v13 and is created by the product_template_attribute_line (also a new object) and so I am not seeing how to set this xml_id so that I can reference it later.

Facing a similar issue. I was able to use the https://github.com/tfrancoi/odoo_import_example on a database on version 12.
As you inidcated the datamodel has changed for the product with attributes.
Did anyone find a solution to generate the product.product records manually on odoo 13+?
Similarly to the example?

We need to have a predictable (self generated) XMLID on the product.product to use it in filters.
And data enrichment (e.g. setting a unique barcode for a specific variant.).

Doing it in one throw is way easier then the workaround mentioned by @Rad0van

I see this message coming up a lot on forums / app groups.
Yet, all online tutorials just seems to mention the product.template method (W/O XMLID)
cc: @tfr-odoo @tfrancoi @bartvanbossche Can you help us out here? 🙏