Trouble importing(CSV) product variants

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Mathlin Comos
Posts: 5
Joined: 01 Feb 2018, 16:14

Trouble importing(CSV) product variants

Post by Mathlin Comos » 01 Feb 2018, 16:33

Hello,

It may be a simple task to you but I am having trouble with the import of different variants for a product.

My test.csv file:

Code: Select all

1001,"select","Example_Name","default","color","green",
1002,"default","Example_Variant","variant","color","yellow",1001
And my mapping ( I am using typo3):

Code: Select all

item{
0=product.code
1=product.type
2=product.label
}
attribute{
3=product.lists.type
4=attribute.type
5=attribute.code
}
product{
6=product.code
}
I want to add different variants to the first product, but I may missunderstood sth. in the documentation.
I also tried a lot of different methods (e.g. changing the order of the products) but the solution seems to be far away...
The import creates 2 different products and the variants/attributes of the first product are not showing up in the first product.

Thank you!
Greetings

Typo3: 8.7.9 Aimeos:18.1.0 PHP:7.2 Environment:Linux/Debian

Mathlin Comos
Posts: 5
Joined: 01 Feb 2018, 16:14

Re: Trouble importing(CSV) product variants

Post by Mathlin Comos » 02 Feb 2018, 14:18

So I actually managed to create the variants in the selection product by importing the variants first and then linking the selection product to the variant products. I hope there is another way because you will have to have tons of lines with links in the selection product column.

Please let me know if you have any solution
Thank you!
Greetings

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Trouble importing(CSV) product variants

Post by aimeos » 02 Feb 2018, 17:52

Unfortunately no. You have to create the articles before your can create the selection products because you can't reference non-existing articles. That will cause integritiy errors which you can't avoid.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Mathlin Comos
Posts: 5
Joined: 01 Feb 2018, 16:14

Re: Trouble importing(CSV) product variants

Post by Mathlin Comos » 02 Feb 2018, 18:32

Sorry if I repeat myself, but is there no way in adding the link to the selection product by creating the default product / the variant ?
I've read through some other threads (e.g. laravel-package-f18/import-from-csv-t834.html) which has been created 2 years ago. It seems to work for him by creating the selection product first and then adding the different variants of the product to the selection product. Did this feature got removed?

Thank you again.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Trouble importing(CSV) product variants

Post by aimeos » 04 Feb 2018, 15:22

Not at the moment. It's only possible in the selection product by listing the product codes of the articles separated by comma. You could implement another import processor that adds the reference for the article to the selection product. But in this case, you can only add references but not delete old ones.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply