Odoo - Bulk Update Product Variant Internal ID
I am working with odoo community edition 11 and have been looking for the correct way to bulk import internal reference numbers for product variants.
I have attempted to export the data in a usable format however each time I am able to get the necessary fields, the product variants are duplicated in the export. In the image below you can see that each product in this case is shown twice.
With approximately 1800 variant products currently, this issue isn't something that's a simple workaround. And this number is expected to increase dramatically over the next few weeks.
I'm looking for guidance on how to get the initial export of all product variants with no assigned internal reference to function properly.
The fields I need to be able to bring down is the product ID (reference for import) the internal reference (or blank) and the variant attributes assigned to that particular product variant.
Any assistance in pushing me in the right direction would be greatly appreciated.
** Output from first answer below:
Go to Inventory > Master data > Product variants, select a product and got to action>export, select radio button Export all Data. Select columns 'Display name, Internal Reference, ID', then choose save export and save the export with any name. Now cancel the export, select all product variants, go to export again and this time keep 'Import compatible' selected, choose that saved export from earlier.
You will have exported list of product variants with column Full name which contains 'variant attributes' in it. and you can import this modifying the Internal reference column.
For example, check this from a new demo database in odoo:
