Hi Troy:

A quick way to do this would be to do the following to update the Internal Reference and Barcode fields after the variants are created through your current loading process:

• Go to Inventory > Master Data > Product Variants​

• Select and export all the variants to an importable csv file. Export only the External Id, Name, Internal Reference and Barcode fields. The Name field is for verification purpose only so you know which product variant you are referencing in each record.

• Update the values in the Internal Reference and Barcode columns. Do not touch the External Id values since these will be used by Odoo for updating the records.​

• Import the updated csv file. Make sure you skip the Name field and import just the Internal Reference and Barcode fields.

Hi  T.A. Geldart,

I think this video can help you: https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1 (starting at minute 23 in this video)

When I export my Product Variants it does not contain Internal Reference

As you can see there is two "id" columns but no Internal Reference

https://imgur.com/JCARJ9x

Worked like a charm - definitely can get the job accomplished using this method.

I presume there is no way to do this at the time of the original import?

This does work, just adds an additional step lining up the appropriate info for a two-thousand variants.

Thanks so much Paresh for the details - much appreciated, and will work with this technique.

Hi T.A. Geldart

We're facing the same problem. As we are a retailer too - with two times a year of new collections in Store. We found a solution with an import module made by globalteckz. Please contact abraar@globalteckz.com - and refer to the SOL-ID.ch project - the import module they made for us.

With this module we are able to import variants with barcode in one step.

Best Regards.

Simon

Hi,

Checkout this app: https://apps.odoo.com/apps/modules/13.0/import_products_advance/