Skip to Content
This question has been flagged
importvariantsodooV13
2 Respostes
4588 Vistes
Avatar
Guido Veldhuijzen

To import a product with variants using a xls/csv sheet I know I can use a colom 'attribute values' and place the variants comma separated like L,S,M. This wil make the product.template with 3 variants.

But now I want to do a import where every attribute value is on it own line in the sheet. In this example it would be 3 lines with each it's own value. The result should be one product.template with 3 variant as above.

The import sheet can look like if you do an export of a product.template and his variants. Every variant has it's own line and not on one line with comma separated values for the attribute.

I was not able to do this. Everytime I end up with several product.templates. Who knows how to take care of this?


Odoo V13


Avatar
Descartar
Avatar
Thuy Ngoc
Best Answer

Hi  Guido Veldhuijzen,

I think this video can help you: https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1

Avatar
Descartar
Avatar
Tuan Bui VKS
Best Answer

The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.  Please contact me via email anhtuan.acoi@gmail.com  if you need further assistance.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Is it possible to batch import New Products with their New Variants at the same time? Solved
import variants
Avatar
Avatar
1
de jul. 25
1218
Importing product variants from Odoo 12 to Odoo 18
import variants
Avatar
Avatar
Avatar
Avatar
3
de jul. 25
2513
Can Variants in Odoo 18 Have Different Sales Prices by Importing an excel file (Without Custom Modules)? Solved
import variants sale price
Avatar
Avatar
1
de jul. 25
1355
Bulk import product variants and automatically assign individual barcodes
import variants product variants
Avatar
Avatar
1
de jul. 25
980
Exporting data V15
export import variants
Avatar
Avatar
Avatar
2
de març 24
3006