Questions about importing product with variants from csv

Hi,

Your CSV is not bad, but I'm surprised it works at all.
The column titles are missing the prefix product_ for almost all of them.
type should be product_type, code should be product_code, category should be categories, name should be product_name, description should be product_description, image1 image2 image3 and image4 should be regrouped into one column separated with commas or semi colons with the column name "images", etc.
Please create a product like you want via the interface and export it. Then, open the CSV generated and you'll see all the correct column names you should use.
Also, note that if all the variants have the same text as the main product for a column, you can only fill the cell of the main product and leave the variants cell empty. That way, the variants will automatically use the information of the main product on the product details page.

Hi,

It's normal that the product_parent_id is 0 for the main product in the database.
It should be the id of the parent product for the variant entries in the hikashop_product table.
If you have 0 in there for the variant entries after a HikaShop import, it means that the import saw the variant rows as main products and not variants of the first entry (probably because the "type" and "parent_id" columns should be named "product_type" and "product_parent_id" in the CSV).

I can't comment on RO CSVI. I don't know how it handles variants import.

Hi,

What is not true ?
Everything you say in your message after this is compatible with what I say in my previous message.
I never said that the product_parent_id column in the database accepts letters, which it doesn't.
As I said:

It's normal that the product_parent_id is 0 for the main product in the database.
It should be the id of the parent product for the variant entries in the hikashop_product table.

So either the value should be 0 or the product_id of the variant in that same table. And the product_id is always a number since it's an auto_increment integer column.

Hi,

In the CSV file, in the "product_parent_id" column of variant rows, you need to have the product_code of the main product row, not the product_id. And YES, in the CSV file, the column product_parent_id can have letters.
The import script will automatically replace the product_code in that column with the product_id of the main product.
This is because when you import a new product, it doesn't have yet a product_id, but you still need to link the variants to the main product in the product_parent_id column. Thus, we're using the product_code in the product_parent_id column of the CSV instead.

I already told you what you should do to change your CSV file in my first message:

The column titles are missing the prefix product_ for almost all of them.
type should be product_type, code should be product_code, category should be categories, name should be product_name, description should be product_description, image1 image2 image3 and image4 should be regrouped into one column separated with commas or semi colons with the column name "images", etc.
Please create a product like you want via the interface and export it. Then, open the CSV generated and you'll see all the correct column names you should use.
Also, note that if all the variants have the same text as the main product for a column, you can only fill the cell of the main product and leave the variants cell empty. That way, the variants will automatically use the information of the main product on the product details page.

In all your messages here since then, you didn't talk about all that I said in that quote and just talked about the product_parent_id column.
Please do the modifications I talked about and try again.
If that still doesn't work, please provide your new CSV file so that I can tell you what you're still missing in it.