Import multiple characteristics

I am trying to import for products with 3 variants (characteristics). I looked up the import documentations and cannot understand the explanation:

For example, suppose that you have a product with 1 characteristic being the size and two variants:
product_code,product_parent_id,size
main_product,,big
first_variant,main_product,big
second_variant,main_product,small

Can anyone explain it? Has anyone done this successfully?

I finally figured it out.. used this import
product_code,product_parent_id,reel-color,rod size
100,0,black,3x
12,100,amber,4x
13,100,clear,4x
336,100,green,5x

But it only updates 1 characteristics... any idea why?

The main product is not a variant. You just need to have the default characteristic selected there. So you're missing a line in your CSV. It should actually be:
product_code,product_parent_id,reel-color,rod size
100,0,black,3x
11,100,black,3x
12,100,amber,4x
13,100,clear,4x
336,100,green,5x

I have a problem importing products that have variants. All together, with variants, I have more than 4k products. Whe I import the attached file, the results say i imported the products, but only one displays. any help would be appreciated, as this is getting to be very frustrating

Hi,

I invite you to read our documentation regarding the import of CSVs. There is section explaining the import of products with variants:
www.hikashop.com/support/support/documen...hikashop-import.html
As explained there, you should have 1 line for the main product and 1 line for each variant (which is not the case in your CSV).
Here is how it should look like for the first product of your CSV:
take.ms/vqoYU