Import from csv
Posted: 04 Oct 2016, 10:43
Dear Aimeos support, thank you for your excelent job, right now, we need You again
We have our csv, where the products are different by size or by color.
---------------------------------------------------------------------
Product code label color size
118391-56 4 Bourke vibrant green 2 size XL
118391-56 5 Bourke vibrant green 2 size XXL
118391-57 4 Bourke pirate black 2 size XL
118391-57 5 Bourke pirate black 2 size XXL
--------------------------------------------------------------------
We use this import:
'mapping'=> array(
'item' => array(
0 => 'product.code', // e.g. unique EAN code
1 => 'product.label', // UTF-8 encoded text, also used as product name
2 => 'product.type', // type of the product, e.g. "default" or "selection"
3 => 'product.status', // enabled (1) or disabled (0)
),
'text' => array(
4 => 'text.languageid',
5 => 'text.type', // e.g. "short" for short description
6 => 'text.content', // UTF-8 encoded text
7 => 'text.languageid',
8 => 'text.type', // e.g. "short" for short description
9 => 'text.content', // UTF-8 encoded text
10 => 'text.languageid',
11 => 'text.type', // e.g. "long" for long description
12=> 'text.content', // UTF-8 encoded text
),
'media' => array(
13 => 'media.url', // relative URL of the product image on the server
),
'price' => array(
14 => 'price.currencyid',
15 => 'price.quantity', // the quantity the price is valid from (for block pricing)
16 => 'price.value', // price with decimals separated by a dot, no thousand separator
17 => 'price.rebate',
18 => 'price.taxrate', // tax rate with decimals separated by a dot
),
'stock' => array(
19 => 'product.stock.stocklevel',
20 => 'product.stock.warehouse',
// 2 => 'product.stock.warehouseid',
// 3 => 'product.stock.dateback',
),
'catalog' => array(
21 => 'catalog.code', // e.g. Unique category code
// 21 => 'catalog.list.type', // e.g. "promotion" for top seller products
),
'attribute' => array(
22 => 'attribute.typeid',
23 => 'attribute.type',
24 => 'attribute.code',
25 => 'attribute.label',
26 => 'attribute.position',
27 => 'attribute.status',
28 => 'attribute.typeid',
29 => 'attribute.type',
30 => 'attribute.code',
31 => 'attribute.label',
),
)
--------------------------------------------------------------------
My question is:
How can we have a base product and plus four variant?
- we need a base product with short and long description, price etc. (No. zero line in the csv)
- and we need 4 variants
first variant: color: vibrant green, size: XL
second: variant: color: vibrant green, size: XXL
third: variant: color: pirate black, size: XL
fourth: variant: color: pirate black, size: XXL
Please let me know what to do.
Thank you
We have our csv, where the products are different by size or by color.
---------------------------------------------------------------------
Product code label color size
118391-56 4 Bourke vibrant green 2 size XL
118391-56 5 Bourke vibrant green 2 size XXL
118391-57 4 Bourke pirate black 2 size XL
118391-57 5 Bourke pirate black 2 size XXL
--------------------------------------------------------------------
We use this import:
'mapping'=> array(
'item' => array(
0 => 'product.code', // e.g. unique EAN code
1 => 'product.label', // UTF-8 encoded text, also used as product name
2 => 'product.type', // type of the product, e.g. "default" or "selection"
3 => 'product.status', // enabled (1) or disabled (0)
),
'text' => array(
4 => 'text.languageid',
5 => 'text.type', // e.g. "short" for short description
6 => 'text.content', // UTF-8 encoded text
7 => 'text.languageid',
8 => 'text.type', // e.g. "short" for short description
9 => 'text.content', // UTF-8 encoded text
10 => 'text.languageid',
11 => 'text.type', // e.g. "long" for long description
12=> 'text.content', // UTF-8 encoded text
),
'media' => array(
13 => 'media.url', // relative URL of the product image on the server
),
'price' => array(
14 => 'price.currencyid',
15 => 'price.quantity', // the quantity the price is valid from (for block pricing)
16 => 'price.value', // price with decimals separated by a dot, no thousand separator
17 => 'price.rebate',
18 => 'price.taxrate', // tax rate with decimals separated by a dot
),
'stock' => array(
19 => 'product.stock.stocklevel',
20 => 'product.stock.warehouse',
// 2 => 'product.stock.warehouseid',
// 3 => 'product.stock.dateback',
),
'catalog' => array(
21 => 'catalog.code', // e.g. Unique category code
// 21 => 'catalog.list.type', // e.g. "promotion" for top seller products
),
'attribute' => array(
22 => 'attribute.typeid',
23 => 'attribute.type',
24 => 'attribute.code',
25 => 'attribute.label',
26 => 'attribute.position',
27 => 'attribute.status',
28 => 'attribute.typeid',
29 => 'attribute.type',
30 => 'attribute.code',
31 => 'attribute.label',
),
)
--------------------------------------------------------------------
My question is:
How can we have a base product and plus four variant?
- we need a base product with short and long description, price etc. (No. zero line in the csv)
- and we need 4 variants
first variant: color: vibrant green, size: XL
second: variant: color: vibrant green, size: XXL
third: variant: color: pirate black, size: XL
fourth: variant: color: pirate black, size: XXL
Please let me know what to do.
Thank you