import characteristics

I have product with 2 characteristics (size from 38 to 52 and color (green, blue, black, white)

I would like to import automatically these characteristics by CSV but not all for all products in order not to load too much database. By exemple, I have one product on size 38 and 40 only and with only color black)
I tried to import file with only these specifications but it created automatically all the variants
Please could help me. Thanks in advance

Hi,

Do you tried to set your csv as explain in the tutorial ?
www.hikashop.com/en/support/documentatio...shop-import.html#csv

Something like:

product_code,product_parent_id,size,color

main_product,,38,green
first_variant,main_product,42,white
second_variant,main_product,41,blue

Doens't work ? Else in the variant listing of a product, you can check and delete the variants, they will be removed from the database.

Great and Bravo !!! It works fine !
Thanks again

Hello it's me again,

Your process is working properly, but the variant of the first line is not taking into account. This means that at the product page when it's loaded the variant by default (the first line) it's displayed "item unvailable for these option" In sample below, variant : Blanc and 40 are displayed in product backend as default but when I check the variants list they don't exist. Thanks again for your help

product_code product_parent_id Bonnet Coloris Taille product_manufacturer_id product_type product_quantity product_published price_value categories
3999 0 Blanc 40 ChantelleFR main 1 1 34 BASTILLE
3999V2Cha 3999 Blanc 42 ChantelleFR variant 1 1 34
3999V3Cha 3999 Blanc 44 ChantelleFR variant 1 1 34

Hi,

Yes I forgot one thing, for the main product (the first) the values are for the default value. You need to create this variant, like:

product_code,product_parent_id,size,color

main_product,,38,green
first_variant,main_product,42,white
second_variant,main_product,41,blue
third_variant,main_product,38,green

Does it means that for the main product default values are fictitious ? In your sample : 38 and green ?
That's it

Hi,

The default values are the pre-selected values.
When you edit the product in the backend, the variants options dropdown contains a value, this is the default value, the pre-selected value.

Regards,