Categories
View Replies (3)

Resolved Multiple vm product image import and custom field update

  1. antag
    antag
  2. RO CSVI
  3. Wednesday, 29 March 2017
  4.  Subscribe via email
Hello!

I have a Joomla 3.6.5 with Virtuemart 3.0.18 and CSVI 6.6.3

1) I need to import multiple images. So, I have created a template (import -> Virtuemart -> media product) and in template fields I created product_sku and file_url fields.
I have already uploaded my images in stories/virtuemart/product directory of the website.
So, I suppose that I need to create a CSV file and this file should have as much rows per productas its images? For example if I have 3 images from a specific product, then I should have 3 lines, each line will have product's SKU and the image file name.
Is this correct or should I include more fields or other settings?

2) I need to update products with more custom fields. I do the same procedure as uploading custom fields for the first time?
I suppose that I should need columns: product_sku, custom_title and custom_value to just update current products with new custom fields? Is this correct? Should it rewrite the current custom fields or just add the new ones?

Thank you in advance.
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
1) I need to import multiple images. So, I have created a template (import -> Virtuemart -> media product) and in template fields I created product_sku and file_url fields.
I have already uploaded my images in stories/virtuemart/product directory of the website.
So, I suppose that I need to create a CSV file and this file should have as much rows per productas its images? For example if I have 3 images from a specific product, then I should have 3 lines, each line will have product's SKU and the image file name.
Is this correct or should I include more fields or other settings?

You can import multiple images separated by | like for example file_url field will be image1.jpg|image2.jpg|image3.jpg instead of having multiple rows.

2) I need to update products with more custom fields. I do the same procedure as uploading custom fields for the first time?

Yes, you would need to create your custom fields from VirtueMart custom fields page.

I suppose that I should need columns: product_sku, custom_title and custom_value to just update current products with new custom fields? Is this correct?

Yes, thats correct. Please have a look at product with custom fields import document to know more on it.

Should it rewrite the current custom fields or just add the new ones?

You can use the current custom fields, just need to follow the way to import them which is explained in the above linked document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
antag
antag
Accepted Answer Pending Moderation
Thank you very much for your answers!

Regarding custom fields I have products with for example custom field video.
Now I need for all those products to add extra custom fields.
So if I prepare a file like importing I won't lose my current custom fields in products, I will just add the new ones correct?
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
So if I prepare a file like importing I won't lose my current custom fields in products, I will just add the new ones correct?

Yes, it would just add the new ones. But i would still advice you to take a backup of virtuemart_product_customfields table before doing the import.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


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