Selection product not importing properly in CSV Import
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Selection product not importing properly in CSV Import
I am using Sample CSV file for import.
There are no errors on import and the products are added to tables.
But the variants are not being added. Here are the screen shots. My shop.php is :
CSV file is attached.
What I am missing here, please help.
There are no errors on import and the products are added to tables.
But the variants are not being added. Here are the screen shots. My shop.php is :
Code: Select all
'controller' => [
'jobs' => [
'product' => [
'import' => [
'csv' => [
'location' => public_path() . '/tmp',
'skip-lines' => 1,
'container' =>[
'type' => 'Directory',
'content' => 'CSV',
],
'mapping' => [
'item' => [
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' => [
4 => 'text.type',
5 => 'text.content',
6 => 'text.type',
7 => 'text.content',
],
'media' => [
8 => 'media.url',
],
'price' => [
9 => 'price.currencyid',
10 => 'price.quantity',
11 => 'price.value',
12 => 'price.taxrate',
],
'attribute' => [
13 => 'attribute.code',
14 => 'attribute.type',
],
'product' => [
15 => 'product.code',
16 => 'product.lists.type',
],
'property' => [
17 => 'product.property.value',
18 => 'product.property.type',
],
'catalog' => [
19 => 'catalog.code', // e.g. Unique category code
20 => 'catalog.lists.type', // e.g. "promotion" for top seller products
],
],
],
]
]
]
],
What I am missing here, please help.
- Attachments
-
- products-import-example.zip
- (528 Bytes) Downloaded 113 times
Re: Selection product not importing properly in CSV Import
Did you create the attributes first? The product CSV import doesn't do that automatically if you forgot to add them before.
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
Re: Selection product not importing properly in CSV Import
The documentation says that attributes are automatically created.
"Nevertheless, if an attribute doesn't exist, it will be created automatically."
"size" attribute was already added.
"S/M" & "M/L" no. But I also tried adding them. Still same result.
I can see the attributes in list if I try to manually add them.
"Nevertheless, if an attribute doesn't exist, it will be created automatically."
"size" attribute was already added.
"S/M" & "M/L" no. But I also tried adding them. Still same result.
I can see the attributes in list if I try to manually add them.
Re: Selection product not importing properly in CSV Import
OK, then it's the missing product.lists.type column for each attribute type/value pair column with the value "variant" so the attributes are added as variant attributes instead of regular attributes. Instead of:
Use:
Code: Select all
attribute.type;attribute.code;attribute.type;attribute.code
size;M/L;color;blue
Code: Select all
product.lists.type;attribute.type;attribute.code;product.lists.type;attribute.type;attribute.code
variant;size;M/L;variant;color;blue
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
Re: Selection product not importing properly in CSV Import
Thanks alot.
Yes, this fixed the issue.
Yes, this fixed the issue.