[SOLVED] CSV import - problems with variants

Hello,

Can anyone help me with this, I don't know what I'm doing wrong. I already read all post related to CSV on this forum but I don't get it.

First I exported csv file from hikashop and start adding products and variants. I use LibreOffice Calc for that. When I made an import it kind of scrambled some variants and prices were not defined. At import is always the message that I have invalid product codes.

After several tries I decided to clean hikashop database and start over again. So I deleted all the products and variants from hikashop backend. In phpmyadmin I deleted the all the rows and Empty the tables (TRUNCATE) of: hikashop_variant, hikashop_product_category, hikashop_product and hikashop_price.

After this I import a new created csv file (please see atached file), with some products and all its variants with prices. I get this notification: "192 products found, 136 products imported, 14 invalid product codes and 42 already existing products.

Why do I have invalid product codes and already existing products? Did I not deleted them all? What do I have to delete more?

Next I export a new csv file (see attachement) and realized it only imports all main products and only the variants of the last main product in the list. Also some cells of the variants have duplicate values:

If you need more info just ask. I'm trying this for 2 days now. Any help is very appreciated.

regards,
Mainzer

UPDATE: The "14 invalid product codes" is solved, I found the error. All the other problems remain.

Sorry bordering you.

At last I figured it out.

I gave every variant an exclusive product_name and it worked. (I thought that the name of the variants were irrelevant and that hikashop would automaticly create different prodruct_code for each variant)

But this is very time consuming. I have to import tousands of products, with 12 variants each
Does leaving it blank work?

Is there a faster way to do this?

Thank you,
Mainzer

Hi nicolas,

Like I said in my 2nd post it only worked renaming each variant with an exclusive product name. I didn't need to eliminate the column product_id, only its content.

Isn't there a "automatic" way to do this?

Thanks

Thank you nicolas,

that was exactly what I needed to know