Resolved Import Excel file to virtuemart

Hello Joomlis,
Here are the list of fields related to your columns for VirtueMart Product import.

Product sku ->product_sku
Product Name ->product_name
Product Categories ->category_path
Product Price ->product_price
Product images thumb ->file_url_thumb
Product images ->file_url

To import category you need to use VirtueMart category import operation
category name -> category_name
category description -> category_description

Have a look at the linked documents to know on how to use these fields in your import.
Let me know if this helps.

Hello Joomlis,

I should import categories before products?

Yes, import categories and then products.

How do products combine with each category?

In your product import use category_path field with category you want to link the product to. Example of category_path will be like parent category/child category1/child category2.

Is there any documentation about it?

The document VirtueMart Product import linked in my previous reply will explain on how to use category_path field in product import.

Hello Joomlis,
Debug log is missing in your post, can you post that to check?

Hello,
Thank you for posting the debug log. It shows the category has been updated in your database to sv-SE language tables. There is nothing wrong i could see with your debug log. Can you tell us what went wrong with your import?

Hello Joomlis,
Are you using sv-SE language for your VirtueMart? Your categories are updated to sv-SE language tables. If you are using a different language, you need to set the primary language in your import template and Options tab and run the import again.

Hello,

What do I need to think about

First and foremost memory. Importing XLS files require a lot of memory. Of course this depends on how many products you import and how many fields. Due to the way XLS files are, they must be read entirely into memory.

which column names / fieldnames to add

You have not told us what you are importing, so we can't say. Looking at your list of column names I assume you want to import products.

Have a look as well at our VirtueMart Products Import tutorial. This explains which fields you need.

What is also very helpful is to manually enter 1 product and export those fields, so you can see where the data goes to. You can apply that to your import file.

Hi,
Thanks for your reply. Here is list of column names I want to import products:

Product sku
Product Name
Product Categories
Product Price
category name
category description
Product images thumb
Product images

Best regards,
J

Hello,

What is your question? The link to the tutorial I gave you has these fields. We have a separate tutorial on Import VirtueMart images.

Hi,
My question is what should I name ''the column names'' in Excel file in order to be coordinated with CSV when Import to
vm?

I need to import the following:

Product sku
Product Name
Product Categories
Product Price
category name
category description
Product images thumb
Product images


Best regards,
Joomlis

Hi tharuna,
I should import categories before products?
How do products combine with each category?
Is there any documentation about it?

Thanks,

Best wishes,
Joomlis

Thanks Tharuna for help!
I tried to import a simple file but it went wrong,
Please what's wrong?
I enclosed the original file

Best Wishes,
Joomlis

import-CAT.csv

Thanks,

com_csvi.log.18.zip

The imported categories do not appear in ''Product categories'' in Virtuemart!

best wishes,
Joomlis

Hi Tharuna,
Thank you so much Tharuna for your professional help!
Now it's working fine, thank you for your time and your
fantastic explanation


My Best Wishes to you,
Joomlis