creating specific variations with Product CSV import suite
-
Hi,
I am trying to create variable products with product CSV import suite.
I have two attributes used for variation: size and color. I need to manage stock for each variation and obviously I want the photos to change based on color.First I create a parent product with all variable values, among them are:
sku AHGKKSS
parent_sku
tax:product_type variable
attribute:pa_size 3-4 years|5-6 years|7-8 years|9-10 years
attribute_data:pa_size 1|1|1
attribute_default:pa_size 3-4 years
attribute:pa_color Blue|Red|Green
attribute_data:pa_color 1|1|1
attribute_default:pa_color Blue
images image1.jpg|image2.jpg|image3.jpgThen I create the file for variation products including the values:
sku BBBBGGJS
parent_sku AHGKKSS
tax:product_type variation
attribute:pa_size 3-4 years
attribute_data:pa_size 1|1|1
attribute_default:pa_size
attribute:pa_color Blue
attribute_data:pa_color 1|1|1
Image: specific image for this variation image2.jpg- e.g. blue dresseach variation has unique values of color+size, stock and image in the file
Both of the files create a variable product indeed, it shows colors and sizes to choose from, however, stock is not displayed properly while I choose different options and photos do not change in line with what I have uploaded for each variation.
In product edit page, I see that under variation it shows:
any: size any:color
any: size any:color
any: size any:color
any: size any:color
etc.
And I have to configure each variation manually. Now I need to upload hundreds of products, each having 15-20 variations at least, so doing this manually would not be practical.Instead of any size, any color – how can I fill out the file so that I will get specific variations:
blue 3-4 years instock, 2
blue 5-6 years instock, 5
red 9-10 years instock, 7
etc?Also, another issue is that while uploading a CSV file for either parent or variation, the first field automatically is assigned “do not import” – does not matter if I change the sequence of the column headers, for the first field I need to find the corresponding field manually – if you could help me with that, too that would be great.
thanks
- The topic ‘creating specific variations with Product CSV import suite’ is closed to new replies.