Importing Products with variants, including internal reference and barcode PER variant.

Question

We are working with Odoo.sh and Version 13
We have successfully tested and imported products with variants (name, image, description, price, size and color etc.), no problem.
That said, we haven't managed to figure out *how to import variants, and include the internal reference and barcode for  each of the variants  successfully.*
As a retailer, with purchases two times per year for seasonal orders, and thousands of variants, barcodes and internal reference (SKU's) - this becomes quite important

Paresh Wagh · Answer

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 v

Thuy Ngoc · Answer

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)

Yusup Khasbulatov · Answer

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

id
default_code
name
product_template_variant_value_ids
id

__export__.product_product_2447_cd250014
My Company Tshirt (GRID)
Size: XL,Color: Rainbow,Gender: Women
__export__.product_product_2447_cd250014

__export__.product_product_2385_795dcb9b
ST1
Color: White
__export__.product_product_2385_795dcb9b

__export__.product_product_2448_0eccbb43
ST1
__export__.product_product_2448_0eccbb43

__export__.product_product_244

T.A. Geldart · Answer

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.

Simon Linder · Answer

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

Related Posts	Replies	Views
How to import a product in english and arabic with fields such as website description and advantages and benefits and features in odoo 12? import importing importing data from excel file	1 Jul 22	5125
Import products with variants and barcodes import products variants barcodes	1 Jul 25	3842
Export to Import variants fails export importing Exporting importing data from excel file	2 Feb 24	2479
How can I import Products with Internal Categories and Website Categories without Errors (Odoo can't find the category)? Solved importing importerror importation importing data from excel file	5 Jan 18	16270
How to import 'extra value price' ? V14 variants extra_price importing data from excel file e-commerce v14	3 Jan 24	7755

This question has been flagged

Enjoying the discussion? Don't just read, join in!

id	default_code	name	product_template_variant_value_ids	id
__export__.product_product_2447_cd250014		My Company Tshirt (GRID)	Size: XL,Color: Rainbow,Gender: Women	__export__.product_product_2447_cd250014
__export__.product_product_2385_795dcb9b		ST1	Color: White	__export__.product_product_2385_795dcb9b
__export__.product_product_2448_0eccbb43		ST1		__export__.product_product_2448_0eccbb43
__export__.product_product_2449_ecdbe447		ST1	Color: cool white	__export__.product_product_2449_ecdbe447
__export__.product_product_2450_565628de		ST1	Color: Dark Grey	__export__.product_product_2450_565628de