Import of Variants

Hi,

If I wish to import variants, I believe the characteristics need to be created first, Is this correct?

The problem that I am having is if for example I have two products:
Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green
Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White

Do I need to create separate characteristics for these before I import?

Any help would be greatly appreciated as always.

I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear.

I am figuring this out, but it does seem to that I then have to go to every single products add the characteristics and then import each product at a time?

I also have to manually add the characteristics to each product, before importing each product.
For example throughout the whole product range their are 628 unique colours and combinations and 150 sizes.

With 1012 unique products without variants being the parent products. Surely there must be a way to automate this process?

Help would help so much

Thanks so much for you help Nicolas,

I put in one sample product and with the characteristics manually.
The after exporting the csv I opened it up in Excel and simply changed the data.

It seems I have to click manage variants to save each product with the variants?

The Categories have been imported successfully.

I have included the exported CSV, does anything seem odd in this to you?

Thanks nicolas,

Can I remove columns that I simply don't need ?