CSV import for product variants
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
CSV import for product variants
Hi all,
after following the docs and demo csv files I can´t get an product variant CSV import working. The variant relations are not imported into the selection article.
This is my mapping setup:
With this CSV data
Thanks for any hint.
after following the docs and demo csv files I can´t get an product variant CSV import working. The variant relations are not imported into the selection article.
This is my mapping setup:
Code: Select all
mapping {
item {
0 = product.code
1 = product.label
2 = product.type
3 = product.status
}
text {
4 = text.type
5 = text.languageid
6 = text.content
7 = text.type
8 = text.languageid
9 = text.content
10 = text.type
11 = text.languageid
12 = text.content
13 = text.type
14 = text.languageid
15 = text.content
16 = text.type
17 = text.languageid
18 = text.content
19 = text.type
20 = text.languageid
21 = text.content
22 = text.type
23 = text.languageid
24 = text.content
25 = text.type
26 = text.languageid
27 = text.content
}
price {
28 = price.currencyid
29 = price.quantity
30 = price.value
31 = price.taxrate
32 = price.type
}
stock {
33 = stock.stocklevel
34 = stock.type
}
product {
35 = product.code
}
property {
36 = product.property.type
37 = product.property.value
38 = product.property.type
39 = product.property.value
40 = product.property.type
41 = product.property.value
42 = product.property.type
43 = product.property.value
44 = product.property.type
45 = product.property.value
46 = product.property.type
47 = product.property.value
}
attribute {
48 = attribute.type
49 = attribute.label
50 = attribute.code
51 = product.lists.type
}
catalog {
52 = catalog.code
53 = catalog.list.type
54 = catalog.code
55 = catalog.list.type
56 = catalog.code
57 = catalog.list.type
58 = catalog.code
59 = catalog.list.type
60 = catalog.code
61 = catalog.list.type
62 = catalog.code
63 = catalog.list.type
64 = catalog.code
65 = catalog.list.type
66 = catalog.code
67 = catalog.list.type
68 = catalog.code
69 = catalog.list.type
70 = catalog.code
71 = catalog.list.type
72 = catalog.code
73 = catalog.list.type
}
}
Code: Select all
"item code","item label","item type","item status","text type","text languageid","text content","text type","text languageid","text content","text type","text languageid","text content","text type","text languageid","text content","text type","text languageid","text content","text type","text languageid","text content","text type","text languageid","text content","text type","text languageid","text content","price currencyid","price quantity","pricevalue","price tax rate","price type","stocklevel","stock type","product code","property type","property value","property type","property value","property type","property value","property type","property value","property type","property value","property type","property value","attribute.type","attribute.label","attribute.code","product.lists.type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type","catalog code","catalog list type"
"0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71","72","73"
"880720845170","Lorem ipsum dolor","default","1","matno","de","8807 20845170","name","de","Cum sociis natoque penatibus et magnis dis parturient monte","short","de","Cum sociis natoque penatibus et magnis dis parturient monte","long","de","Cum sociis natoque penatibus et magnis dis parturient monte","matno","en","8807 20845170","name","en","Lorem ipsum dolor","short","en","Cum sociis natoque penatibus et magnis dis parturient monte","long","en","Cum sociis natoque penatibus et magnis dis parturient monte","EUR","1","1,00","0","gross","99999999","default","880720833205k1","package-weight","70","package-length","1200","package-width","800","package-height","400","","","","","diameter","450 mm","450","variant","cat1","default","","default","","default","","default","","default","","default","","default","","default","","default","","default","","default"
"880720851170","Lorem ipsum dolor","default","1","matno","de","8807 20851170","name","de","Cum sociis natoque penatibus et magnis dis parturient monte","short","de","Cum sociis natoque penatibus et magnis dis parturient monte","long","de","Cum sociis natoque penatibus et magnis dis parturient monte","matno","en","8807 20851170","name","en","Lorem ipsum dolor","short","en","Cum sociis natoque penatibus et magnis dis parturient monte","long","en","Cum sociis natoque penatibus et magnis dis parturient monte","EUR","1","1,00","0","gross","99999999","default","880720833205k1","package-weight","70","package-length","1200","package-width","800","package-height","400","","","","","diameter","510 mm","510","variant","cat1","default","","default","","default","","default","","default","","default","","default","","default","","default","","default","","default"
"880720859170","Lorem ipsum dolor","default","1","matno","de","8807 20859170","name","de","Cum sociis natoque penatibus et magnis dis parturient monte","short","de","Cum sociis natoque penatibus et magnis dis parturient monte","long","de","Cum sociis natoque penatibus et magnis dis parturient monte","matno","en","8807 20859170","name","en","Lorem ipsum dolor","short","en","Cum sociis natoque penatibus et magnis dis parturient monte","long","en","Cum sociis natoque penatibus et magnis dis parturient monte","EUR","1","1,00","0","gross","99999999","default","880720833205k1","package-weight","70","package-length","1200","package-width","800","package-height","400","","","","","diameter","590 mm","590","variant","cat1","default","","default","","default","","default","","default","","default","","default","","default","","default","","default","","default"
"880720833205k1","Cras dapibus.","select","1","matno","de","8807 20833205 k1","name","de","Cum sociis natoque penatibus et magnis dis parturient monte","short","de","Cum sociis natoque penatibus et magnis dis parturient monte","long","de","Cum sociis natoque penatibus et magnis dis parturient monte","matno","en","8807 20833205 k1","name","en","Cras dapibus.","short","en","Cum sociis natoque penatibus et magnis dis parturient monte","long","en","Cum sociis natoque penatibus et magnis dis parturient monte","EUR","1","2,0","0","gross","99999999","default","","package-weight","400","package-length","1200","package-width","800","package-height","1000","some-chapter","2.8","some-category","","","","","","cat2","default","","default","","default","","default","","default","","default","","default","","default","","default","","default","","default"
Re: CSV import for product variants
You must reference the articles in the selection product, not the selection product in the articles (column 35)
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
give us a star