Skip to Content
This question has been flagged
importvaluesexcelattribute
1 Respondre
5489 Vistes
Avatar
Berkay Tunalı

I am using Odoo13 ce.

I need to import all product with variants, so

started with attributes and imported already. Right now I want to import attribute values then Product and variants 

Is there any way (or excel template) to do it as functional ?

Avatar
Descartar
Avatar
Berkay Tunalı
Autor Best Answer

I found answer of my own question. Simply added some values on attribute then export it then some testes and template is ready to use! 

You could this :


name display_type create_variant value_ids value_ids/name value_ids/html_color
Legs Radio Instantly Legs: Steel Steel
Legs: Aluminium Aluminium
Legs: Custom Custom
Bulb Color (C) Color Instantly Bulb Color (C): White White #FFFFFF
Bulb Color (C): Black Black #000000
Bulb Color (C): Blue Blue #0019ff
Bulb Color (C): Pink Pink #ff00a5
Bulb Color (C): Yellow (57) Yellow (57) #e9ff00
Bulb Color (C): Rainbow Rainbow #9d00ff
Bulb Color (C): Red (68C) Red (68C) #ff0000
Bulb Color (C): Green Green #29b641
Brand Radio Never Brand: Global Vision Global Vision
Brand: Cla-Valve Cla-Valve
Brand: FireChem FireChem
Avatar
Descartar
Parker D

Thank you very much, that helped! But in Odoo 14 I had to leave out the column "value_ids". Then it worked.

Related Posts Respostes Vistes Activitat
large Purchase Order excel import
import excel purchase_order
Avatar
Avatar
Avatar
Avatar
Avatar
4
de maig 24
3900
OdooV13 write a module to get an excel file as input Solved
import excel odooV13
Avatar
Avatar
Avatar
Avatar
3
de nov. 23
8332
Mapping imported data
import values v7
Avatar
Avatar
2
de gen. 23
16342
Upload excel and import to sale order line Solved
import sale.order.line excel
Avatar
Avatar
1
de des. 21
5494
Read out certain product attribute values in purchase.order.line
product values attribute
Avatar
Avatar
1
d’ag. 21
3955