Skip to Content
This question has been flagged
1 Reply
5153 Views
Avatar
Stewart

Good Morning,

I am loading products into odoo community edition 11, and while uploading the product variants is going quite well there is one issue which I cannot seem to overcome.

I need to update the internal reference for product variants, as many of these items have 2-16 options and need to be referenced internally by those variant specifications.

Is there a field which can be used for the bulk update of product variant internal ID's and/or a way to set these fields on the initial product import? Any assistance to getting me in the right direction on this would be greatly appreciated.


While the answer below appeared to be a solution, the fields (attribute_value/value and external_ID) mentioned do not exist under the export fields listing in the community edition 11 under the master data, product variants export tool. When using the fields provided  there, I am able to export the information however all of the product variants are displayed multiple times (product variant x number of product variants) so if there are two variations, it is shown 4 times.

Thank You

Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

The database name for the  Internal Reference  field is  default_code.


You can find this out by opening a Product Variant and, in Developer Mode, hovering over the field:



If I wanted to change the Internal Reference for these Product Variants:



I would Export them (Master Data --> Product Variants) using these fields:



This gives me:



Then I would edit the CSV / Excel file to look something like:


(Note that I deleted the blank rows and the Attribute Values after using them to construct the Internal Reference.)


Then, import the data back into Odoo.


This gives me:




Avatar
Discard