1. webmarketingtrento
  2. RO CSVI
  3. Friday, 05 January 2018
  4.  Subscribe via email
Hi I'm trying to import products via csv in virtuemart 3 and everything works ok only that for a product I have to set more values for a string field, how can I pass this information? using | or / it does not seem to go ..
I attach screen

Thanks
Christopher
Accepted Answer Pending Moderation
Hello Christoper,
Have a look at Product import with custom fields document and under section CUSTOM FIELDS WITH MULTIPLE VALUES to know on how to use multiple values for custom fields.
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
Accepted Answer Pending Moderation
Thanks for the reply but I do not think so I can solve, I'm importing products from a csv and I can in the same csv also import custom fields only that it does not create more string fields when set more values for a string field.

I can not use one for the categories o / when there are multiple values or duplicate the custom field column?

Is it possible to import only specific custom fields?

I'm also noticing that if I export the products in csv it exports only 132, why? I have not set limits and there are more than 1000 products

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Thanks for the reply but I do not think so I can solve, I'm importing products from a csv and I can in the same csv also import custom fields only that it does not create more string fields when set more values for a string field.

Yes, you can use one csv file to import product and custom fields. Can you post a sample import file to check? Also post the debug log of your import. To know on how to get the debug log check the blue box on top of this page.

I can not use one for the categories o / when there are multiple values or duplicate the custom field column?

Can you explain more on this?

Is it possible to import only specific custom fields?

What you have in your import file is what imported. You can add specific custom fields you need to import to your import file.

I'm also noticing that if I export the products in csv it exports only 132, why? I have not set limits and there are more than 1000 products

CSVI will export product details from the VirtueMart language table as set in your export template settings and on Options tab. Check if you have correct language set in your export template.
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
Accepted Answer Pending Moderation
Attach file test.csv and file log (com_csvi.log.92.zip) The problem is in the field "Un regalo per sempre"
I have to create 2 strings for the same field see attachment screen-string.jpg

--CSVI will export product details from the VirtueMart language table as set in your export template settings and on Options tab. Check if you have correct language set in --your export template.

I set up Italian and exports only 132 products. I enclose log n.94
Attachments (4)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Attach file test.csv and file log (com_csvi.log.92.zip) The problem is in the field "Un regalo per sempre"
I have to create 2 strings for the same field see attachment screen-string.jpg

Since you are importing multiple values for a single string custom field you need to use custom_title and custom_value in your import file instead of having your custom field as an individual column. This is explained in the document i linked in my previous post.

So example of your custom field import for string field Un regalo per sempre will be like

product_sku;custom_title;custom_value
12345r;Un regalo per sempre~Un regalo per sempre;Cresima~Battesimo


I set up Italian and exports only 132 products. I enclose log n.94

In your export template settings on Fields tab, you have set few number of Group by fields. Remove them and run the export.
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. # 5
Accepted Answer Pending Moderation
--Since you are importing multiple values for a single string custom field you need to use custom_title and custom_value in your import file instead of having your custom --field as an individual column

OK I did not understand, I thought I had to do a different import, now I try. Thank you

--In your export template settings on Fields tab, you have set few number of Group by fields. Remove them and run the export.
No, I am attaching screens
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
No, I am attaching screens

I did not say File tab but Fields tab(as per your screenshot Campi). click on the Select button next to Group by fields and you can see the fields added. Remove them and run the export.
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. # 7
Accepted Answer Pending Moderation
Sorry if I was late with the answer but you were right, it works, thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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