How to import products from CSV with multiple attributes

[gingerbg]

Hi, my problem is that i have lingerie products with multiple attributes.

Here is the example: Product ID, name, color, size, price, quantity

At this point the software recognize the product as different products. Different product for every size and color.
My table looks like this:

001, bikini, red, M, 5.00, 24
001, bikini, white, M, 5.00, 24
001, bikini, white, S, 5.00, 24

When I import the products this way, the system recognize them as 3 different products. How to fix them?

Thanx.

[rocky]

You should create two separate CSV files: one for products and one for combinations. For example, create a product CSV file like this:

ID;Name
1;"Bikini"

and a combination CSV file like this:

Product ID;Options (Group:Value);Price;Quantity
1;Color:Red,Size:M;5.00;24
1;Color:White,Size:M;5.00;24
1;Color:White,Size:S;5.00;24

[salesfromisrael]

Rocky,
you made the attribute module with radio buttons. is there a way to import the information through CSV?

Nofia

[rocky]

Sure, just use the same | syntax for the attribute group and names in the combination CSV file.

[DeepVoid]

Rocky, I don't have words to thank you for your hints, you save me a lot of time!!! If you'll ever plan to come to Rome, Italy, please let me know, I owe you a good beer

[alicu90]

I created these two csv files and doesn't work properly

 

This one to import products

 

http://pvmag.ro/Fisiere-directoare/IMPORT%202%20-%20Copy.csv

 

And this one to add combinations

 

http://pvmag.ro/Fisiere-directoare/combinations_import.csv

 

What is wrong?

Edited June 25, 2016 by alicu90 (see edit history)