Milie44
commented
6 years ago Thank you drewgillson for providing such a great example of how to do this !
As you may know, we provide documentation on https://help.akeneo.com/ and you can contribute ! The github repository is here : https://github.com/akeneo/pim-helpcenter
Thanks to your contribution, you can help the other community members by preventing them to spend an inordinate amount of time figuring out how to create variant products for apparel by uploading spreadsheets. In the help center, people can easily search what they need in order to gain time and product information quality in Akeneo PIM, for free.
If you want to take part of this virtuous ecosystem of the opensource, do not hesitate to contribute! Github repository : https://github.com/akeneo/pim-helpcenter
Cheers!
parveen12345
I spent an inordinate amount of time last week figuring out how to create variant products for apparel by uploading spreadsheets. Since this is such a common use case, I think it's silly that there isn't a great example of how to do this in the Akeneo documentation! I tried to post this on the forums, but it appears they've been locked, so I'm posting this as an issue in the hopes that someone from the team publishes this for others who are almost certainly struggling.
How to import variant products (like apparel in different colors and sizes) from spreadsheets:
First make sure the color and size attributes exist, and associate them to a family variant group. In this example, I first created a family named Apparel that has a two-level variant group associated to it, with color as the first level, and size as the second level. The code for my variant group is _apparel_colorsize and this value goes in the _familyvariant column when importing product models. Make sure you drag the appropriate attributes to the right levels in the variant group, most importantly the picture attribute, since we are importing and associating pictures in this example.
To import products, you need to upload the product model file first (upload shirt_parent.xlsx using the Demo XLSX Product Model Import profile) and then upload a zipped file containing the child products and images (shirt_children.zip, using the Demo XLXS Product Import profile).
Note that you need a sub-line for each color in the product model sheet—it would sure be great to eliminate this in the future, why can't it be more simple?
Unfortunately your pictures need to be associated to each child product, and can't be associated to the product model and inherit as they do in the interface. This means you don't associate the picture for a particular color of shirt with the sub-line in the product model spreadsheet, but in the SKU line in the product spreadsheet.
Attached are my example files. Good luck!
shirt_parent.xlsx shirt_children.zip