1. joomlis
  2. RO CSVI
  3. Tuesday, 07 August 2018
  4.  Subscribe via email
Hi,
Please, I need to import Excel file to virtuemart,

What do I need to think about
which column names / fieldnames to add

I have the following column names:

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

Best regards,
J.
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
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
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Joomlis,
Debug log is missing in your post, can you post that to check?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
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?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
The imported categories do not appear in ''Product categories'' in Virtuemart!

best wishes,
Joomlis
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!